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

31 votes463 views1 answer
Excel-vba how to convert a column number into an excel column
VBA
1 vote203 views1 answer
Vba reverse string
VBA
0 vote214 views1 answer
Vba get workbook name
VBA
0 vote224 views1 answer
Excel web scraping
VBA
0 vote203 views1 answer
Vbnet check if string is only symbols
VBA
0 vote215 views1 answer
Excel vba automatic calculation
VBA
3 votes221 views1 answer
Vba http request json
VBA
0 vote263 views1 answer
Visual basic cmd
VBA
0 vote219 views1 answer
Supprimer la valeur de celule vba
VBA
0 vote211 views1 answer
Excel run macro every 5 minutes
VBA