/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 vote156 views1 answer
Excel vba disable screen update
VBA
8 votes339 views1 answer
Excel vba make word from bytes
VBA
4 votes181 views1 answer
VBA Deep Clone Dictionary
VBA
3 votes177 views1 answer
Excel vba change format of cell
VBA
4 votes177 views1 answer
Excel vba how to programmatically remove the marching ants after range copy
VBA
0 vote194 views1 answer
Create new worksheet excel visual basic
VBA
0 vote178 views1 answer
Programmatically copy data from one workshet to another excel
VBA
1 vote171 views1 answer
Random number generator vb.net
VBA
0 vote169 views1 answer
COMO GRAVAR U VALOR NO ARQUIVO APPSETINGS EM VB NET
VBA
0 vote157 views1 answer
Vba add shape oval
VBA