preventing access to hidden worksheets
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.
Glenn wrote:
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
|