How can I password protect a worksheet from being deleted

K

Kathy081403

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

Gord Dibben

Kathy

Yes. Protect the workbook under Tools>Protection>Protect Workbook.

Select both Windows and Structure then enter a password.


Gord Dibben Excel MVP
 
D

Dave Peterson

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