| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I password protect a hidden column in Excel? | Excel Worksheet Functions | |||
| Password Protect a Worksheet | Excel Discussion (Misc queries) | |||
| how to protect excel worksheet and still use the outline buttons? | Excel Worksheet Functions | |||
| How can I protect an excel worksheet containing filters? | Excel Discussion (Misc queries) | |||
| worksheet deleted | Excel Discussion (Misc queries) | |||
Hybrid Mode
