/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

1 vote166 views1 answer
Export datagridview to excel vb.net
VBA
0 vote168 views1 answer
Vbs expand env var
VBA
9 votes291 views2 answers
Excel vba convert 2 Short integers to a Long integer
VBA
8 votes236 views1 answer
Excel vba determine number of elements in a 2D array
VBA
0 vote158 views1 answer
Vba run command
VBA
0 vote170 views1 answer
For each item in folder outlook vba
VBA
1 vote144 views1 answer
How to do error handling in access vba
VBA
1 vote150 views1 answer
Vba delete array element
VBA
0 vote163 views1 answer
Vba array dimensions
VBA
0 vote150 views1 answer
Vba copy paste value only
VBA