Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting a Sheet
If you Protect the workbook sheet delete will be disabled
ToolsProtectionProtect Workbook Abdul Salam -----Original Message----- Hi, I am currently using the Sheet_Deactivate event to check if a user try's to delete a sheet. Is there anyway to cancel the actual sheet deletion after the user has selected Delete on the Excel message box that is displayed when deleting any sheet? Basically what I am trying to do is stop users deleting a sheet if it has particular information on it? Any ideas? Thanks in advance.. Rick . |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting a Sheet
Thanks Abdul, but I need to allow the user to delete the sheet if it
does not contain certain information (which I can catch in my code). Basically I need to catch the deleting in an event and then determine if they are allowed to delete it or not. If not, then I need to display a message and stop them from deleting. Displaying the message if fine, but how to I stop the actual deletion of the sheet once they have selected delete on the Excel message box? Can this be done? Thanks, Rick *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting cliparts in excel sheet | Excel Discussion (Misc queries) | |||
Keep sheet from deleting contents | Excel Worksheet Functions | |||
Deleting a sheet creates a new one | Excel Discussion (Misc queries) | |||
how to protect sheet from adding/deleting | Excel Discussion (Misc queries) | |||
Deleting every-other row in a spread sheet | Excel Discussion (Misc queries) |