Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet Protection and XLA code
I am trying to unprotect a spreadsheet from some code in a workbook. Below
is the code: ActiveWorkbook.Sheets("TRANSACTIONS") . Unprotect strPassWord €˜*** do stuff to worksheet End with This code is in a xla workbook. If the code is called from the activeworkbook in a non save mode then it works. If the code is called from the Workbook.BeforeSave event then the code stops with a protection error. At this point, even in a debug mode, the sheet protection will not turn off. Is there a known issue that prevents the activeworkbook sheet protection to not be change during the before save event? Any thoughts or work around? Thanks in advance -- Stewart Rogers DataSort Software, L.C. |
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) | |||
Sheet protection code conflicts with Pivot Table "auto refresh" | Excel Discussion (Misc queries) | |||
Sheet Protection and VBA Code | Excel Discussion (Misc queries) | |||
disabling the "view code" tab - sheet protection? | Excel Programming | |||
protection sheet and code ??? | Excel Programming |