Wimpie
Board Regular
- Joined
- Aug 12, 2008
- Messages
- 210
Good day
Please assist with the below
I did a lot of research and found the below code that works , I only need all the cells with formulas protected and everything else to work
The problem is that after unprotecting and protecting a few time I can not group (+) and ungroup (-) any more
How can I solve for this
I also need some code added to the below if the incorrect password as per the above is used to say "Incorrect password please try again" and to not create a Run-time error 1004 and direct me to developer to Debug
Thank you in advance
Please assist with the below
I did a lot of research and found the below code that works , I only need all the cells with formulas protected and everything else to work
Code:
Sub Lock_Formulas()
ActiveSheet.Protect "pass", True, True
With ActiveSheet
.Protect EnableOutlining = True
.Protect UserInterfaceOnly = True
.Protect DrawingObjects = True
.Protect Contents = True
.Protect Scenarios = True
.Protect AllowFormattingColumns = True
.Protect AllowFormattingRows = True
End With
End Sub
The problem is that after unprotecting and protecting a few time I can not group (+) and ungroup (-) any more
How can I solve for this
I also need some code added to the below if the incorrect password as per the above is used to say "Incorrect password please try again" and to not create a Run-time error 1004 and direct me to developer to Debug
Code:
Sub Unlock_Formulas()
ActiveSheet.Unprotect
End Sub
Thank you in advance
Last edited: