Hi,

Can anyone help me with a macro for accessing a hidden sheet? i have a
hidden sheet named "Cost Data". i have this sheet hidden as it holds cost
information regarding projects that other people are not privy too. i set it
on a button to hide and another button with password to access it. However, i
have found a flaw which is the password only works as long as the VBA forms
are working. you have to close the form to enter certain data onto the sheet.
From this point, you can unhide the sheet.

would it be possible to show a password protected box when
"Format/Sheet/Unhide sheet" is selected from the menu bar and if the password
is incorrect, deny the sheet from being unhidden?

thanks in advance,


Nigel