How do I prevent users to delete a worksheet, but allow to edit?

N

nb91386

How can I allow other users to update an workbook, but not to delete any tabs
or existing information?
 
J

James W.

Take a look at protect worksheet and protect workbook these both can be found
in tools>protection. Use help to guide you the rest of the way.

James
 
D

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.
 
Top