/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 vote341 views1 answer
Pivot data source not accepting table named range vba
VBA
4 votes303 views1 answer
Excel vba check cell not empty
VBA
0 vote293 views1 answer
Vba dropdown event
VBA
0 vote293 views2 answers
Excel vba close without saving
VBA
0 vote322 views2 answers
Open url from vba
VBA
0 vote296 views1 answer
Vb net dgv doesn't keep currency format
VBA
0 vote298 views1 answer
How to carry text to the next line in a label in vb.net
VBA
0 vote278 views1 answer
How to make a if statement with vbs
VBA
0 vote314 views1 answer
.net crash app
VBA
18 votes484 views2 answers
Vba make word from bytes
VBA