Macro Button Password

[Steve C]

Hi,

Can someone please help with this query,

I'm trying to password protect a macro.
When I use the following it will ask the user for a password and *******
will be displayed in the input box, however when the user types in their
password it is visible to all.
How do I change this so that the users password is displayed as ****** when
entered

Dim MyPassword
MyPassword = InputBox("Please enter a valid password", "Password Prompt",
"********")

Many thanks

 

[Ron de Bruin]

Hi Steve

Not possible with a inputbox

Create a small userform with a textbox
See the PasswordChar Property in the properties window

 

[Steve C]

Thank you,
I have been losing sleep over this!

Hi Steve

Not possible with a inputbox

Create a small userform with a textbox
See the PasswordChar Property in the properties window

 

[Ron de Bruin]

Hi Steve

See this page for Userfom stuff
http://support.microsoft.com/default.aspx?scid=kb;EN-US;829070