Excel protect cells with formulas

' Protects cells containing formulas, with password
' pPwd: password to protect / unprotect
Sub ProtectFormulas(ByRef pRange As Range, ByVal pPwd As String)
    ActiveSheet.Unprotect pPwd
    For Each r In pRange
        r.Locked = IIf(r.HasFormula, True, False)
    Next r
    ActiveSheet.Protect pPwd
End Sub

Sub TestIt()
    ProtectFormulas Range("A1:B4"), "MyPassWord"
End Sub

Similar codes

0 vote271 views1 answer
VBA Sort RossetaCode
VBA
7 votes228 views1 answer
Vba array declaration
VBA
2 votes286 views1 answer
Vba round number
VBA
0 vote220 views1 answer
Afficher un message d'erreur vba
VBA
1 vote269 views1 answer
Find and replace textbox
VBA
0 vote226 views1 answer
How to convert weeks to days into textbox with VB site:stackoverflow.com
VBA
0 vote239 views1 answer
Check if program is running vbnet
VBA
1 vote232 views1 answer
How to check is the value enterd is a number or text in vba
VBA
0 vote250 views1 answer
For each item in folder outlook vba
VBA
0 vote264 views1 answer
VBA is form loaded
VBA