Disabling or capturing a Delete Sheet command
I think I would protect the workbook (not worksheet), then provide a macro to
add and delete sheets.
Then the macro can validate the request and block them if it's not right.
Your macro would unprotect the workbook, do its stuff, and then reprotect the
workbook.
SteelDetailer wrote:
I have a workbook with a few pages that I do not want to allow the user to
delete, but other sheets (ones that the user adds) I want to allow the user
to delete.
I cannot find a "Before_Sheet_Delete" event, or anything similar to it.
Is there anything I can do? Thanks in advance!!
Rich
--
Dave Peterson
|