Macro to run if unhide sheet option selected

Posted by Douglas on September 27, 2001 5:02 AM

I'd like to be able to run a macro which prompts for a password before a hidden sheet in a workboolk can be unhidden. Any suggestions?
~thanks

Posted by Greg Collett on September 28, 2001 1:30 PM

Try using an Input Box which requires the user to put the correct password before proceeding. I know they can always try to look at the code to get the password but you can stymie them by paswword protecting the code as well. This makes the project unviewable.

Cheers

Greg