/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 vote345 views1 answer
Discern between file and folder given path vb.net
VBA
0 vote360 views1 answer
Vb get ip address
VBA
2 votes346 views1 answer
Date format for ms chart vb.net
VBA
5 votes404 views1 answer
Excel vba left word from Long Integer
VBA
1 vote379 views1 answer
Excel vba to lower case
VBA
0 vote361 views1 answer
Backspace key has stopped working visual studio
VBA
0 vote461 views1 answer
Excel vba delete columns in range
VBA
15 votes493 views2 answers
Xl vba dynamic string array
VBA
1 vote368 views1 answer
Excel vba last column in range
VBA
0 vote366 views1 answer
Excel vba round to whole number
VBA