![]() |
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? |
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? |
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 |
All times are GMT +1. The time now is 06:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com