preventing access to hidden worksheets

[Glenn]

I have hidden worksheets on my program. How can I prevent someone from
unhiding a worksheet? I know how to protect the worksheet from changes but
there are certain worksheets I want to keep from others eyes.
Thanks
Glenn

 

[Dave Peterson]

You can protect the workbook's structure.

This'll stop the user from inserting/deleting/renaming/moving sheets.

In xl2003, you can find it under:
Tools|Protection|protect workbook|Check Structure

Leave Windows unchecked.

Give it a memorable password. But be aware that this password is easily broken
by anyone who really wants to.

 

[Office_Novice]

Set the worksheets property to xlVeryHidden the user will not be able to
unhide them unless they are in vba which you can password protect. or use
something like

ActiveWorkbook.Worksheets(3)= (xlVeryHidden)

 

[Office_Novice]

ActiveWorkbook.Worksheets(3).Visible = (xlVeryHidden)