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
Xlbycolumns is not declared
VBA
0 vote133 views1 answer
Vba like with wildcard
VBA
0 vote139 views1 answer
Vba integer to double
VBA
5 votes170 views1 answer
Excel vba first byte from INTEGER
VBA
7 votes146 views1 answer
Vba array declaration
VBA
0 vote135 views1 answer
Excel vba formatconditions range
VBA
5 votes156 views1 answer
Excel vba second byte from INTEGER
VBA
0 vote141 views1 answer
Vba get application version
VBA
0 vote134 views1 answer
Vba open report
VBA
0 vote144 views1 answer
Putting marquee in vb.net
VBA