Deleting a Sheet

  • Thread starter Thread starter Abdul Salam
  • Start date Start date
A

Abdul Salam

If you Protect the workbook sheet delete will be disabled

Tools>Protection>Protect Workbook

Abdul Salam
 
Thanks Abdul, but I need to allow the user to delete the sheet if it
does not contain certain information (which I can catch in my code).
Basically I need to catch the deleting in an event and then determine if
they are allowed to delete it or not. If not, then I need to display a
message and stop them from deleting. Displaying the message if fine, but
how to I stop the actual deletion of the sheet once they have selected
delete on the Excel message box? Can this be done?

Thanks, Rick
 
Back
Top