/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 vote239 views1 answer
Weekday vba
VBA
0 vote206 views1 answer
Add items to combobox vb.net
VBA
3 votes261 views1 answer
Vba continue for each loop
VBA
31 votes291 views1 answer
Excel vba function to convert column number to letter
VBA
5 votes239 views1 answer
Xl vba double quotes in string literal
VBA
0 vote227 views1 answer
System.Runtime.InteropServices.COMException: 'Call was rejected by callee. (Exception from HRESULT: 0x80010001
VBA
0 vote231 views1 answer
Ribbon show/hide
VBA
0 vote214 views1 answer
Remove first character from string vb
VBA
5 votes231 views1 answer
Xlvba double quotes in string literal
VBA
0 vote251 views1 answer
Vbnet check if string is only letters
VBA