How can I password protect a worksheet from being deleted
 

I know how to password protect a worksheet, however, this still allows
someone to delete this worksheet. Is there a way to only allow it to be
deleted with a password?

How can I password protect a worksheet from being deleted
 

Kathy

Yes. Protect the workbook under ToolsProtectionProtect Workbook.

Select both Windows and Structure then enter a password.


Gord Dibben Excel MVP

On Wed, 21 Dec 2005 12:29:02 -0800, "Kathy081403"
wrote:

I know how to password protect a worksheet, however, this still allows
someone to delete this worksheet. Is there a way to only allow it to be
deleted with a password?

How can I password protect a worksheet from being deleted
 

You can protect the workbook.

Tools|protection|protect workbook
and check Structure.

No worksheets can be added/deleted/hidden/unhidden/moved until the workbook is
unprotected.



Kathy081403 wrote:

I know how to password protect a worksheet, however, this still allows
someone to delete this worksheet. Is there a way to only allow it to be
deleted with a password?

--

Dave Peterson