/VBA/Excel vba protect cells with formula

Excel vba protect cells with formula

Excel vba protect sheet

'Apply worksheet protection to contents, objects and scenarios
Sheets("Sheet1").Protect Password:="myPassword", _
    DrawingObjects:=True, _
    Contents:=True, _
    Scenarios:=True

Source: exceloffthegrid.com

Excel vba protect cells with formula

' 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 vote231 views1 answer
Vba code to open a file with login rights
VBA
0 vote329 views1 answer
Vba change active sheet
VBA
0 vote240 views1 answer
Excel vba automatic calculation
VBA
0 vote250 views1 answer
Vba string
VBA
0 vote245 views1 answer
VB Error Code BC30201
VBA
0 vote184 views1 answer
Vba code to remove leading and trailing spaces
VBA
0 vote255 views1 answer
Excel vba named range exists
VBA
1 vote262 views1 answer
Vba loop through files in folder
VBA
0 vote259 views2 answers
Vb.net include quotes in string
VBA
0 vote235 views1 answer
Vba find sub dictionary
VBA