Avoiding sheet deletion by VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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"
 
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.
 
Back
Top