/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 vote388 views1 answer
Vba remove the first character of string
VBA
0 vote364 views1 answer
Vba sheet hide unhide
VBA
0 vote316 views1 answer
Excel vba concatenate range
VBA
2 votes350 views1 answer
Vba round number
VBA
1 vote337 views1 answer
Vba delete array element
VBA
5 votes403 views1 answer
Xlvba double quotes in string literal
VBA
0 vote381 views1 answer
Create links in msgbox in vb
VBA
0 vote372 views1 answer
VBA OR vb6 find OR replace string from the end
VBA
25 votes488 views2 answers
Excel vba folder exist
VBA
0 vote351 views1 answer
Vbscript for loop
VBA