You must protect the workbook to prevent deleting or renaming a sheet.
ToolsProtectionProtect Workbook.
Checkmark "structure".
Gord Dibben MS Excel MVP
On Fri, 25 May 2007 11:28:01 -0700, Trader_in_Paradise
wrote:
I have a blank WorkSheet called "Scratch" in an Excel workbook with lots of
VB code.
I want the user to be able to do anything with the blank WorkSheet called
"Scratch" except to Rename it or to Delete it.
Stumped. Please help. Thank you.