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.

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.

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.