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 vote235 views1 answer
Power query M substract minimum value of column -dax
VBA
0 vote240 views1 answer
Vba code to select image in sheet
VBA
2 votes244 views2 answers
Excel vba if sunday or staurday
VBA
0 vote214 views1 answer
Excel vba chrw max value
VBA
0 vote256 views1 answer
Check if cell is dbnullvb.net
VBA
1 vote214 views1 answer
Excel vba last column in range
VBA
0 vote193 views1 answer
Vbnet make a string to unicode converter
VBA
0 vote246 views1 answer
Excel vba urlmon
VBA
0 vote234 views1 answer
Prive sub enter clicked vb
VBA
0 vote235 views1 answer
Tester si une case est vide vba
VBA