ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I prevent users to delete a worksheet, but allow to edit? (https://www.excelbanter.com/excel-discussion-misc-queries/43541-how-do-i-prevent-users-delete-worksheet-but-allow-edit.html)

[email protected]

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?

James W.

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?


Dave Peterson

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