第3个回答 2012-08-27
Sub mima2()
Dim sht As Worksheet, rng As Range
On Error Resume Next
For Each sht In ThisWorkbook.Worksheets
With sht
.Unprotect Password:="khgx123" '撤销工作表保护
.Range("A:IV").Locked = False '取消所有单元格格式》保护 中的锁定选项
With .UsedRange.SpecialCells(xlCellTypeFormulas) '定位所有含有公式的单元格
.Locked = True '选中所有单元格格式》保护 中的锁定选项
.FormulaHidden = True '隐藏公式
End With
.Protect Password:="khgx123" '保护工作表,并将密码设置为khgx123
End With
Next
End Sub