Capturing a Delete Sheet event

[Balsak]

Hi again,
There is no default Event Private subroutine that
captures when a user deletes a sheet via rightclicking
the tab.

Does anyone know how to detect a sheet deletion?

I can pick up when rows or cols are deleted because I
know the menu assignments but can't find it for the sheet.

As usual, grateful for any help!

Kind regards,
Balsak

 

[hgrove]

Balsak wrote...

There is no default Event Private subroutine that captures when a use deletes
a sheet via rightclicking the tab.

Does anyone know how to detect a sheet deletion?

I can pick up when rows or cols are deleted because I know the menu
assignments but can't find it for the sheet.

...

If you don't want users deleting worksheets, protect the workbook. I
you want to control the deletion of worksheets, protect the workboo
and add either menu items or command buttons to run macros that will d
whatever clean-up or archival you want to perform, then unprotect th
workbook, delete the worksheet, and reprotect the workbook.

AFAIK, there's no event that will trap worksheet deletion BEFORE i
occurs