VBA hide/unhide rows

hey,
I just started using vba with excel, and I have a hard question (maybe its easy)

I need a workbook to automatically prompt for a password when opened and based on the password typed, certain rows would become unhidden.

the sheets are all protected with password "pass", so the coding needs to:
-prompt for password,
-unprotect all sheets using "pass"
-unhide certain rows (lets say 20 to 100) in all sheets
-protect all sheets again with "pass"

then when closing, the workbook should:
-unprotect,"pass"
-hide rows,
-protect "pass"

I really appreciate anyone trying to help.
Thanks!

1) Press ALT-F11 to access the VBEditor
2) Open the ThisWorkbook module in the VBAProject Properties window
3) Paste in this workbook-event code:

Please Login or Register  to view this content.

4) Edit the code so the correct password is listed at the top and the correct rows are noted in each macro
5) Close the editor and save as a macro-enabled workbook.

Reopen the workbook to test.

JB, this

Please Login or Register  to view this content.

... needs to go in a code module to be in scope outside ThisWorkbook.

Good point, shg.

I put it into ThisWorkbook because it shouldn't be needed outside of there, by setting the UserInterfaceOnly flag on every sheet when the workbook opens, any macro in any module can run freely on all of those sheets without problems, even though the sheet(s) are protected. Hopefully the PWD variable wouldn't be needed in a code module.