Hide a password

[edhaddock]

I am using the InputBox to require a password before running a macro. It works fine but the password displays when it is entered. Is there a way to display asterisks (*) instead?

If InputBox("Please enter the password") <> "password" Then Exit Sub

Thanks for your help. Ed

[dominicb]

Good afternoon edhaddock

There is a way of doing this - Daniel Klann shows how here :
http://www.danielklann.com/excel/hid...a_inputbox.htm

However, it is probably easier to use a textbox on a userform which has a property called "PasswordChar" which allows you to use any character you like as a password mask.

HTH

DominicB

[edhaddock]

Thanks for the help. It seems to work perfectly.

Ed