/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 vote202 views1 answer
Change "location" of binding navigator vb
VBA
0 vote222 views1 answer
Make all controls in an area not visable vb
VBA
0 vote224 views4 answers
How to continue formula in below line in vba code
VBA
0 vote216 views1 answer
Vba dropdown event
VBA
4 votes166 views2 answers
Vba last row
VBA
0 vote216 views1 answer
Vba sheet visible
VBA
2 votes210 views1 answer
Excel vba date to string conversion
VBA
0 vote229 views1 answer
Excel vba Column Name from Column Number
VBA
2 votes215 views2 answers
Vba code to remove duplicates from a column
VBA
0 vote257 views4 answers
Jwt token vb.net validation
VBA