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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with copying a sheet from One workbook to another workbook 1
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
Search , then copy and paste from multiple worksheets. VBA help 1
Can't delete sheets 8
How to avoid Compatibility Checker MsgBox? VBA to avoid or prevent? 1
VBA Bypass Delete Sheet Warning 8
Trying to delete sheet code with VBA 2
Preventing sheet deletion 2

Back
Top