View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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