passwordchar

[keithkemble]

this is so so simple and yet I cannot apply it. Can anyone help.

I have a password routine that auto unprotects my sheets in the workbook.

There is an input box that requires the password, but will display said password.

My wish is to hide the typing.

The books etc do not appear to be clear on syntax for spreadsheets.

Does anyone have an example of usage.

Thanks.

 

[dk]

Hi Keith,

Are you using an inputbox or a userform? You can't hide the password in an inputbox but you can with a userform. You can set the PasswordChar property of a textbox to whatever you like so you'll get ******** rather than seeing what's been typed in.

HTH,
D

 

[keithkemble]

I am using an inputbox.