/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 vote205 views1 answer
Returns an array from function vba
VBA
0 vote204 views1 answer
Vba compare strings
VBA
0 vote203 views1 answer
Excel named range sum
VBA
2 votes197 views1 answer
Excel vba check if key is in collection
VBA
0 vote190 views1 answer
Faire appel à la mise en forme conditionnelle vba excel
VBA
0 vote218 views1 answer
Vbnet round to nearnest thousand
VBA
0 vote220 views1 answer
Filesystemobject vba reference
VBA
0 vote191 views1 answer
Excel protect cells with formulas
VBA
0 vote212 views1 answer
Vba collection contains
VBA
0 vote232 views1 answer
Vbnet check if string is only letters
VBA