Hiding/Unhiding worksheets

[Guest]

Hi,
I want to hide several sheets in a workbook yet have one of them unable to
be unhidden. Is there any way I can make is so that a worksheet cannot be
viewed without a password?
Thanks in advance.

 

[Dave Peterson]

Tools|Protection|Protect workbook

Check the Structure box

But be aware that the password you supply is very simple to break.

If you have data you really don't want others to see, excel ain't the
application for you.

 

[Sergio Spencer]

Tools|Protection|Protect workbook

Check the Structure box

But be aware that the password you supply is very simple to break.



Hi Dave

How can I break a password that I have forgoten, the problem is tha
it's been over 5 months since I used the file and I can't remember th
password.

Please Let me know

Thank

 

[Dave Peterson]

Protection via Tools|protection...

If yes, then J.E. McGimpsey has code that will unprotect the workbook/worksheet:
http://www.mcgimpsey.com/excel/removepwords.html

If it's the file|open password, you may want to try:
http://www.lostpassword.com/