/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 vote107 views1 answer
Vba full date format
VBA
1 vote107 views1 answer
Excel vba first and last row and column in range
VBA
0 vote94 views1 answer
Vbnet display all axis labels in cahrt
VBA
0 vote117 views1 answer
Write listbox to text file vb.net
VBA
6 votes117 views1 answer
Excel vba check if a string only contains letters
VBA
12 votes209 views1 answer
Excel vba write string to text file
VBA
1 vote116 views1 answer
Vba format string as cash
VBA
1 vote100 views2 answers
Vba find last row in range for certain criteria
VBA
0 vote132 views1 answer
Find the name of the last excel sheet vb
VBA
0 vote106 views1 answer
Excel vba DisplayAlerts
VBA