I have a workbook with approximately 15 worksheets. One of the worksheets
has confidential information that I do not want the general user to see
unless they have the password to "uhide" the worksheet. I have a main
worksheet (visible at all times) with hyperlinks to each worksheet. I want
to piggyback a macro off the hyperlink for the confidential worksheet that
prompts a password. If the password is correct, the macro will unhide the
worksheet. If the password is not correct, an message box will appear
informing the user the password is incorrect and to try again. When closing
the workbook, I want the macro to hide the confidential worksheet.

Also...I want to protect the workbook so the user cannot manually "unhide"
the confidential worksheet from the toolbar. I want to protect the
confidential worksheet since certain cells will be locked to avoid user data
entry.

Will someone please help me with the VBA code? and what is the code to get
around the conflict of having the workbook and worksheet protected?

Thank you very much.
Andy

To make a long story short there is nothing we can give you that can not be
broken or hacked quite easily. Protection in Excel is very week. Check out
this link...

http://www.mcgimpsey.com/excel/removepwords.html
--
HTH...

Jim Thomlinson


"Anolan" wrote:

I have a workbook with approximately 15 worksheets. One of the worksheets
has confidential information that I do not want the general user to see
unless they have the password to "uhide" the worksheet. I have a main
worksheet (visible at all times) with hyperlinks to each worksheet. I want
to piggyback a macro off the hyperlink for the confidential worksheet that
prompts a password. If the password is correct, the macro will unhide the
worksheet. If the password is not correct, an message box will appear
informing the user the password is incorrect and to try again. When closing
the workbook, I want the macro to hide the confidential worksheet.

Also...I want to protect the workbook so the user cannot manually "unhide"
the confidential worksheet from the toolbar. I want to protect the
confidential worksheet since certain cells will be locked to avoid user data
entry.

Will someone please help me with the VBA code? and what is the code to get
around the conflict of having the workbook and worksheet protected?

Thank you very much.
Andy