View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default 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.