/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 vote193 views1 answer
Winforms dark title bar
VBA
1 vote148 views2 answers
Vba remove first 2 characters from string
VBA
4 votes155 views1 answer
Excel vba determine number of elements in an array
VBA
0 vote151 views1 answer
Vba line feed
VBA
3 votes157 views1 answer
Excel vba get the workbook full file name with path
VBA
22 votes303 views1 answer
Excel vba check if directory exists
VBA
0 vote173 views1 answer
Vbscript Trim
VBA
1 vote170 views1 answer
Vb.net get name by Selection Changed
VBA
1 vote170 views1 answer
Excel vba last row of range
VBA
0 vote162 views1 answer
Send text to clipboard vb.net
VBA