/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 vote285 views1 answer
Vba select file in folder
VBA
3 votes308 views1 answer
Vba folderexists
VBA
0 vote322 views1 answer
VBA Loop to range
VBA
4 votes311 views1 answer
Excel vba Imitating the "IN" operator from python
VBA
0 vote323 views1 answer
Vba excel do not recalculate before save
VBA
0 vote344 views1 answer
Method showalldata of object _worksheet failed vba
VBA
0 vote305 views1 answer
Combobox dropdown search visual basic -excel -C#
VBA
0 vote332 views1 answer
Vba array dimensions
VBA
0 vote302 views1 answer
Vb net show lines for all axis labels in chart
VBA
0 vote316 views1 answer
Vba code for cutoff time
VBA