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 vote357 views1 answer
Openfiledialog specific folder
VBA
3 votes380 views2 answers
Vba date to string
VBA
0 vote404 views1 answer
Excel web scraping
VBA
0 vote349 views1 answer
Vbnet line graph smooth lines
VBA
0 vote364 views1 answer
Vba sheet hide unhide
VBA
0 vote361 views1 answer
Vbs exec hidden
VBA
0 vote345 views1 answer
Sendkeys vba selenium
VBA
0 vote337 views1 answer
Open application from vbnet
VBA
-1 vote372 views1 answer
Code for reading letters only in vb 6
VBA
0 vote380 views1 answer
Excel vba named range exists
VBA