/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 votes151 views2 answers
Excel vba last column with data
VBA
31 votes261 views1 answer
Excel-vba how to convert a column number into an excel column
VBA
0 vote146 views1 answer
Vba array of integers
VBA
7 votes156 views1 answer
Vba array declaration
VBA
0 vote142 views1 answer
Vba collection key list
VBA
0 vote162 views1 answer
How to get value from clipboard in vbnet
VBA
0 vote148 views1 answer
How to get the value of optionbutton in vba
VBA
0 vote154 views1 answer
VBA Sleep Snippet
VBA
0 vote139 views1 answer
Excel vba disable screen update
VBA
0 vote145 views1 answer
Excel vba chrw max value
VBA