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 vote143 views1 answer
How to get value from clipboard in vbnet
VBA
3 votes130 views1 answer
Vba make long from two shorts
VBA
0 vote137 views1 answer
.net dark title bar
VBA
0 vote125 views1 answer
Excel vba send HTTP POST to server
VBA
3 votes131 views1 answer
Vba request json
VBA
0 vote151 views1 answer
Excel vba move down to next visible cell
VBA
0 vote134 views1 answer
Excel R1C1 mode
VBA
0 vote126 views1 answer
Vba get text file content
VBA
0 vote139 views1 answer
Vba vbcrlf chr
VBA
0 vote130 views1 answer
Vba compare strings
VBA