Hiding worksheets:needed for the front sheet

Hi, I need a secure way to hide worksheet tabs? I can do it in options, but this will not stop people looking at it.

I have tried to go into the VB scripting, and in properties, and select visible to 2, but i just get an error saying I cant do that.

All the sheets (4 of them) are needed for the front sheet to function, so needs to be accessible in regards to macros and formulars...

I am lost on what else to try, but need them gone, and ideas?

Thanks in advance!!

Hi Addy,

Your method of hiding a worksheet programmatically should work fine.

If the messages says "Unable to set the Visible property of the Worksheet class" then you're trying to hide the only visible worksheet in the workbook, which can't be done.

If not, jot down the error message down and re-post.

HTH

Robert