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 vote266 views2 answers
Get unique random number in vb.net
VBA
1 vote231 views1 answer
Excel vba last column in range
VBA
0 vote235 views1 answer
Vbs send keys
VBA
1 vote229 views1 answer
Textbox find and replace vb
VBA
0 vote229 views1 answer
Hello world vb.net
VBA
0 vote265 views1 answer
Send text to clipboard vb.net
VBA
0 vote283 views1 answer
Excel vba protect sheet
VBA
0 vote263 views1 answer
Amd64 vs arm64 linux
VBA
0 vote264 views1 answer
Find database connection string vb
VBA
0 vote246 views1 answer
Vba variable number of arguments
VBA