Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with sheet protection
I can answer my own question - sorry everyone - just seen a typing error in
the last line. Engage brain before selecting 'post' !! "PigzleFly" wrote in message ... I wanted to toggle sheet protection off and on, but when using the following code ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True ActiveSheet.EnableSelection = x1UnlockedCells which I gleaned from a recorded macro. I still end up with a protected sheet that allows access to locked cells. What am I missing? Sorry if this is a bit simple, but just starting with VBA Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Protection Best Practice: AKA: Real Sheet Protection | Excel Discussion (Misc queries) | |||
Excel Data Protection- AKA: Sheet/Macro Password Protection | Setting up and Configuration of Excel | |||
Q about sheet protection | Excel Discussion (Misc queries) | |||
Sheet Protection | Excel Worksheet Functions | |||
Sheet Protection | Excel Worksheet Functions |