/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 vote200 views1 answer
Vbnet chart make 0 gridline line different color
VBA
0 vote196 views1 answer
Vba leading zeros in string
VBA
0 vote197 views1 answer
Vbnet access System.InvalidOperationException: 'Update requires a valid UpdateCommand when passed DataRow collection with modified rows.'
VBA
0 vote202 views1 answer
Loop through each cell in dgv vbnet
VBA
0 vote200 views1 answer
Loop through all text boxes in a form vb
VBA
0 vote210 views1 answer
Excel vba protect sheet
VBA
1 vote192 views2 answers
Vba string to date
VBA
5 votes205 views1 answer
Excel-vba get integer high byte
VBA
1 vote195 views1 answer
Excel vba Populating a combobox on a userform from a range of cells
VBA
0 vote199 views1 answer
Excel vba protect worksheet without password
VBA