/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 vote309 views1 answer
System.Data.OleDb.OleDbException: 'No value given for one or more required parameters.'
VBA
0 vote342 views1 answer
Vba leading zeros in string
VBA
0 vote475 views1 answer
Vba change active sheet
VBA
0 vote346 views1 answer
Search combobox items vb.net
VBA
0 vote326 views1 answer
Excel R1C1 mode
VBA
0 vote313 views1 answer
Enter into cells data grid view
VBA
0 vote353 views1 answer
Excel vba disable screen update
VBA
1 vote365 views1 answer
Vba ubound array 2-dimensional
VBA
5 votes399 views1 answer
Excel vba last byte from INTEGER
VBA
0 vote324 views1 answer
How to make a a msgbpx in vbs
VBA