Prevent Worksheet from being deleted

[Mike]

Is there any way to prevent a Worksheet from being deleted or renamed?

Thanks

 

[Gord Dibben]

Yes. Sort of.


Protect the workbook with a password under Tools>Protection>Protect Workbook for
Structure and Windows.

The "sort of" is generated by the fact that Excel's internal security is very
weak and passwords easily cracked.


Gord Dibben MS Excel MVP

 

[JLGWhiz]

Try this site:

http://office.microsoft.com/en-us/help/HP100785801033.aspx

 

[Mike]

I guess I should have made my question a little more exact. What I need is
to protect only a few out of many sheets. It's OK for the user to delete the
"other" sheets but not the ones I need to keep. Doesn't do me much good to
protect the contents of a sheet when someone can come along and delete the
whole sheet.

Mike