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