passwordchar

keithkemble · Mar 2nd, 2002, 04:10 AM

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 · Mar 2nd, 2002, 05:19 AM

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 · Mar 2nd, 2002, 09:47 AM

I am using an inputbox.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 2nd, 2002, 04:10 AM	#1
keithkemble Board Regular Join Date: Feb 2002 Location: Leicestershire, U K Posts: 157	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.

Mar 2nd, 2002, 05:19 AM	#2
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	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

Mar 2nd, 2002, 09:47 AM	#3
keithkemble Board Regular Join Date: Feb 2002 Location: Leicestershire, U K Posts: 157	I am using an inputbox.