Sub 公式保护()
Dim sht As Worksheet, rng As Range
On Error Resume Next
For Each sht In ThisWorkbook.Worksheets
With sht
.Unprotect password:="***" '撤销工作表保护
.Range("A:IV").Locked = False '取消所有单元格格式-保护-锁定选项
With .UsedRange.SpecialCells(xlCellTypeFormulas) '定位所有含有公式的单元格
.Locked = True '选中所有单元格格式-保护-锁定选项
.FormulaHidden = True '隐藏公式
End With
'.EnableSelection = xlNoRestrictions '选取锁定单元
.EnableSelection = xlUnlockedCells '不选取锁定单元
.Protect password:="***" '保护工作表并设置密码
End With
Next
End Sub
Sub 撤消公式保护()
Dim sht As Worksheet, rng As Range
On Error Resume Next
For Each sht In ThisWorkbook.Worksheets
With sht
.Unprotect password:="***" '撤销工作表保护
.Range("A:IV").Locked = False '取消所有单元格格式-保护-锁定选项
With .UsedRange.SpecialCells(xlCellTypeFormulas) '定位所有含有公式的单元格
.Locked = True '选中所有单元格格式-保护-锁定选项
.FormulaHidden = True '隐藏公式
End With
'.EnableSelection = xlNoRestrictions '选取锁定单元
.EnableSelection = xlUnlockedCells '不选取锁定单元
' .Protect password:="***" '保护工作表并设置密码
End With
Next
End Sub