Avoiding sheet deletion by VBA

[Guest]

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.

 

[Chip Pearson]

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"

 

[Tom Ogilvy]

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.