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