View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Protect an Excel WorkSheet from being deleted

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.