Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Avoiding sheet deletion by VBA
Hi developers.
I would like to ask you for a little help with one task. I need to avoid deletion of special sheet (= sheet with special name) by using VBA. I tried Sheet events and also workbook events but there is no event like "do befor deletion" os sth. else. Can anybody help me how to prevent this task? Thx. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Avoiding sheet deletion by VBA
As far as I know, there is no way to prevent this, other than
protecting the workbook, which will disable other actions as well. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "PalikeFromSlovakia" wrote in message ... Hi developers. I would like to ask you for a little help with one task. I need to avoid deletion of special sheet (= sheet with special name) by using VBA. I tried Sheet events and also workbook events but there is no event like "do befor deletion" os sth. else. Can anybody help me how to prevent this task? Thx. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Avoiding sheet deletion by VBA
You can protect the structure of the workbook so no sheet can be deleted.
Then provide the user a userform interface (as an example) that allows them to delete or insert sheets by selecting options that run your code. -- Regards, Tom Ogilvy "PalikeFromSlovakia" wrote in message ... Hi developers. I would like to ask you for a little help with one task. I need to avoid deletion of special sheet (= sheet with special name) by using VBA. I tried Sheet events and also workbook events but there is no event like "do befor deletion" os sth. else. Can anybody help me how to prevent this task? Thx. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prevent sheet deletion | Excel Discussion (Misc queries) | |||
How do I link cells, sheet to sheet, to recognize row deletion | Excel Programming | |||
Prevent Sheet Deletion | Excel Programming | |||
Sheet deletion | Excel Discussion (Misc queries) | |||
How to stop sheet deletion | Excel Programming |