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

--
Message posted from http://www.ExcelForum.com

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

--
Regards,
Tom Ogilvy

"Stephen " wrote in message
...
Hi People,

How can I get to a macro to ask for a password before it starts
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.

Stephen


---
Message posted from http://www.ExcelForum.com/

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

Stephen


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

--
Regards,
Tom Ogilvy

"Stephen " wrote in message
...
Hi People,

How can I get to a macro to ask for a password before it starts
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.

Stephen


---
Message posted from http://www.ExcelForum.com/
*


---
Message posted from http://www.ExcelForum.com/

ooops, i forgot to remove the line
Msgbox True
in the code of the Sub MyMacro()
--
Regards,
Sébastien

Hi

The code works great! Thanks for help:-))


Stephen

-Originally posted b
sebastienmúÇ›jËbzy�ŠÇ.²È¨žÉ¢rº,¡û\ -
*ooops, i forgot to remove the line
Msgbox True
in the code of the Sub MyMacro()
--
Regards,
Sébastien

--
Message posted from http://www.ExcelForum.com

Stephen,


Check this attachment. You may find it useful.


Charle

Attachment filename: hideunhide.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=62006
--
Message posted from http://www.ExcelForum.com