In your code, you'll have to check the configuration, unprotect the workbook,
delete the sheet, reprotect the workbook.



Trader_in_Paradise wrote:

"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.

--

Dave Peterson