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 vote150 views1 answer
Vba exit while
VBA
0 vote144 views1 answer
Vba boolean to string
VBA
0 vote147 views1 answer
Move bindingnavigator vb
VBA
0 vote137 views1 answer
Vba pass named range to function
VBA
0 vote145 views1 answer
Excel vba range contains
VBA
0 vote138 views1 answer
Vlookup columns not next to each other
VBA
0 vote133 views1 answer
Quit excel with save changes dialog vb.net
VBA
0 vote137 views1 answer
Excel vba address not absolute
VBA
0 vote154 views1 answer
VBA Sort RossetaCode
VBA
0 vote140 views1 answer
Vba html document reference
VBA