Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting a sheet in a shared and protected workbook
I have code that create a new worksheet for exporting to a 3rd party
application. The workbook is shared and protected. The temporary worksheet is created, data is entered (by my code), saved and then needs to be closed. This works fine as long as the workbook is not shared and protected. When I share it I get an error telling me I cannot delete a protected sheet. I've tried activesheet.unprotect("pwd") with no result. This is Excel97. Any tips? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Password protected and shared workbook | Excel Discussion (Misc queries) | |||
Shared and protected workbook | Excel Discussion (Misc queries) | |||
Help with a protected shared workbook | Excel Worksheet Functions | |||
EnableOutlining with shared workbook protected sheet? | Excel Programming | |||
Protected Shared Workbook | Excel Programming |