/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 vote204 views1 answer
Vb.net get name by Cell Click
VBA
0 vote195 views1 answer
Excel filter by date not working vba
VBA
0 vote176 views1 answer
WGET FTP
VBA
0 vote197 views1 answer
Search for text in every worksheet excel visual basic
VBA
0 vote192 views2 answers
Checking and changing system volume vb.net
VBA
0 vote187 views1 answer
Vba integer to double
VBA
0 vote168 views1 answer
How to use VBA to add new record in MS Access?
VBA
1 vote175 views1 answer
Excel vba Refreshing all pivot tables in workbook
VBA
0 vote199 views1 answer
How to enter Vbox manage commands
VBA
2 votes230 views1 answer
Vba round number
VBA