/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

4 votes290 views1 answer
Excel vba how to get a range's full address including sheet name
VBA
5 votes275 views1 answer
Vba array worksheet.index
VBA
0 vote297 views1 answer
Vba code for cutoff time
VBA
0 vote281 views1 answer
Vb net check if file exists
VBA
0 vote300 views1 answer
VBA Sleep Snippet
VBA
1 vote281 views1 answer
Excel vba Run a Macro every time sheet is changed
VBA
0 vote291 views1 answer
Not allow form to be resized
VBA
0 vote291 views1 answer
Excel vba saveas no prompt for overwrite
VBA
2 votes305 views1 answer
Excel vba check if string entirely alpha
VBA
0 vote293 views1 answer
Vbnet check if string is only numbers
VBA