Password Macro

Stephen · Jul 16, 2004

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 · Jul 16, 2004

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 · Jul 16, 2004

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

Stephen

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

sebastienm · Jul 16, 2004

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

Stephen · Jul 16, 2004

Hi

The code works great! Thanks for help

)

Stephen

Charles · Jul 16, 2004

Stephen,

Check this attachment. You may find it useful.

Charle

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