ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Password Macro (https://www.excelbanter.com/excel-programming/304294-password-macro.html)

Stephen[_16_]

Password Macro
 
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


Tom Ogilvy

Password Macro
 
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/




Stephen[_17_]

Password Macro
 
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/


sebastienm

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

Stephen[_18_]

Password Macro
 
Hi

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


Stephen

-Originally posted b
sebastienmǛjbzy.²Ȩɢ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


Charles

Password Macro
 
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



All times are GMT +1. The time now is 04:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com