View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Trader_in_Paradise Trader_in_Paradise is offline
external usenet poster
 
Posts: 9
Default Protect an Excel WorkSheet from being deleted



"Dave Peterson" wrote:

There is no Worksheet_delete (or worksheet_beforedelete or
worksheet_afterdelete) event.

Have you thought about protecting the workbook, then giving the user a macro
that would delete any sheet except for the one(s) you don't want deleted??


Thanks, Dave,


I already have two hidden sheets. I also have a VBA routine behind a Delete
Button that allows the user to delete a sheet, except if the sheet is named
Options or Date and as long as the sheet desired to delete is not the only
visible sheet. I did not know I could protect the workbook and still allow
sheets to be deleted.

I will try your suggestion in my code tomorrow. Thanks again.