Macro Button Password

  • Thread starter Thread starter Steve C
  • Start date Start date
S

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
 
Hi Steve

Not possible with a inputbox

Create a small userform with a textbox
See the PasswordChar Property in the properties window
 
Thank you,
I have been losing sleep over this!

Ron de Bruin said:
Hi Steve

Not possible with a inputbox

Create a small userform with a textbox
See the PasswordChar Property in the properties window
Click to expand...
 
Back
Top