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

Thanks

Yes. Sort of.


Protect the workbook with a password under ToolsProtectionProtect 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

On Sat, 2 Feb 2008 19:44:48 -0800, "Mike" wrote:

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

Thanks

Try this site:

http://office.microsoft.com/en-us/he...785801033.aspx

"Mike" wrote:

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

Thanks

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

"Mike" wrote in message
om...
Is there any way to prevent a Worksheet from being deleted or renamed?

Thanks