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

Trader_in_Paradise wrote:

"Gord Dibben" wrote:

You must protect the workbook to prevent deleting or renaming a sheet.

ToolsProtectionProtect Workbook.

Checkmark "structure".


Gord Dibben MS Excel MVP


Thanks, Gord,

I still would like to find a way to protect just one named worksheet in a
workbook from being deleted. Is there a way to trap the Woeksheet Delete
event for that particular worksheet? Thank you.


--

Dave Peterson