Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set up worksheet to keep tabs from being deleted?
I have setup certain cells so that they are locked out so that changes cannot
be made to the spreadsheet. There are multiple tabs on the spreadsheet and I cannot see how to protect them. By right clicking on a tab anybody can delete the entire tab even when the worksheet is protected. Am I missing something here? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set up worksheet to keep tabs from being deleted?
You want to protect the workbook's structure.
In xl2003 menus: tools|protection|protect workbook (and check structure). This will stop users from renaming/inserting/deleting/moving sheets. But be aware that just like worksheet protection, this is easily broken. hamlinfl wrote: I have setup certain cells so that they are locked out so that changes cannot be made to the spreadsheet. There are multiple tabs on the spreadsheet and I cannot see how to protect them. By right clicking on a tab anybody can delete the entire tab even when the worksheet is protected. Am I missing something here? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleted worksheet data | Excel Discussion (Misc queries) | |||
how do i retrieve a deleted worksheet | New Users to Excel | |||
Deleted tabs using replace | Excel Discussion (Misc queries) | |||
Deleted worksheet | Excel Discussion (Misc queries) | |||
worksheet deleted | Excel Discussion (Misc queries) |