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