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 vote270 views1 answer
Vbnet check if sting contians symbols
VBA
0 vote283 views1 answer
Add text to combobox drop down vb
VBA
0 vote286 views1 answer
Faire appel à la mise en forme conditionnelle vba excel
VBA
0 vote267 views1 answer
Vba type variable
VBA
9 votes377 views2 answers
Excel vba convert 2 Short integers to a Long integer
VBA
3 votes297 views1 answer
Excel vba make long from two shorts
VBA
13 votes375 views2 answers
Vba write text file
VBA
2 votes274 views1 answer
Vba split string
VBA
0 vote283 views1 answer
Excel VBA web scraping
VBA
0 vote270 views1 answer
Search in richtextbox vb.net
VBA