| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I prevent users to delete a worksheet, but allow to edit?
How can I allow other users to update an workbook, but not to delete any tabs
or existing information? |
|
#2
|
|||
|
|||
|
Take a look at protect worksheet and protect workbook these both can be found
in toolsprotection. Use help to guide you the rest of the way. James " wrote: How can I allow other users to update an workbook, but not to delete any tabs or existing information? |
|
#3
|
|||
|
|||
|
Protect the workbook.
Tools|protection|Protect workbook Just leave Structure checked. (Users won't be able to rename or change the order of the worksheets, either.) But be aware that this protection is easily broken. wrote: How can I allow other users to update an workbook, but not to delete any tabs or existing information? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
| HOW DO I DELETE A WORKSHEET IN EXCEL? NOT HIDE IT OR RENAME IT | Excel Worksheet Functions | |||
| Select All controls in a worksheet and delete them | Excel Discussion (Misc queries) | |||
| How do you prevent users from pasting over validated cells? | Excel Discussion (Misc queries) | |||
| how do I delete data from a worksheet without deleting the formul. | Excel Discussion (Misc queries) | |||
Linear Mode
