/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 vote251 views1 answer
Vbnet chart make 0 gridline line different color
VBA
0 vote219 views1 answer
How to use if condition in time vba
VBA
2 votes206 views2 answers
Constructor vb.net
VBA
1 vote228 views1 answer
How to INPUT text in shape with enter and spacein vba
VBA
2 votes247 views1 answer
Excel vba check if key is in collection
VBA
1 vote244 views1 answer
S yyyy-MM-dd HH:mm:ss Short Date Local
VBA
0 vote223 views1 answer
Excel vba StartUpPosition
VBA
0 vote229 views1 answer
Dlete rows with blanks and space " " vba
VBA
0 vote229 views1 answer
Combobox dropdown search visual basic -excel -C#
VBA
25 votes555 views3 answers
String to date vb
VBA