Setting the Visible Property of a Worksheet

Hi,

I have seen this done, but can't work out how to do it myself.

I want to set the "Visible" property of a worksheet to xlSheetHidden, and make it so that if a user tries to make it visible it won't allow it and comes up with a Message Box saying "Unable to set the Visible property of the Worksheet class"

I have an old worksheet where a sheet is hidden and I can't display it, even by the Properties window. It comes up with the above error message. Being able to display it will help me work out how to hide it.

Thanks, Paul.

Thanks for your reply.
The sample worksheet I have is unlocked (both the worksheet and VB).
But I still can't change the worksheet Visible property to xlvisible. It comes up with the error. Is there somewhere else it could be locked?

Unfortunately, I can't. While it's an old (obsolete) file, it's classified and cannot be distributed.

Okay, I inspected the code. "Protect" commands (with password) were against almost every function the worksheet does (probably 50 or so commands). I removed them all and I can now change the Visible property.

Thanks for your help.