Password Macro

[Stephen]

Hi People,

How can I get to a macro to ask for a password before it start
running. For example;

I start the macro,
then a pop-up box shows where I can type the password,
Press enter and macro starts.

Please help.

Stephe

 

[Tom Ogilvy]

that is exactly how you would do it. Write the code in the macro to do
exactly that. What help are you looking for?

 

[Stephen]

How do I get the box where I can type in the password? Also that it
check the password before going on.

Stephen

*that is exactly how you would do it. Write the code in the macro to
do
exactly that. What help are you looking for?

 

[Guest]

ooops, i forgot to remove the line
Msgbox True
in the code of the Sub MyMacro()

 

[Stephen]

Hi

The code works great! Thanks for help)


Stephen

 

[Charles]

Stephen,


Check this attachment. You may find it useful.


Charle

Attachment filename: hideunhide.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=62006