Capturing a Delete Sheet event

  • Thread starter Thread starter Balsak
  • Start date Start date
B

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
 
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.
Click to expand...
...

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
 
Back
Top