No supported with an inputbox. If you create a userform that looks like an
inputbox, you can use the passwordchar attribute/property of the textbox to
do this.

--
Regards,
Tom Ogilvy

"Diane Mallin" wrote in message
...
I have password protected a proceedure using a simple input box at the
start
of my code - e user has to input a text string "password" for the code to
run - if they don't know the password it will not run. This is only to
prevent certain individuals from inadvertently running the attached macro
assigned to a button on a spreadsheet.

What I have been unable to figure out is how to set this up so that the
users input appears on screen as a series of ******* instead of actual
text.

(Using Excel 2000)

Any help greatly appreciated

I have password protected a proceedure using a simple input box at the start
of my code - e user has to input a text string "password" for the code to
run - if they don't know the password it will not run. This is only to
prevent certain individuals from inadvertently running the attached macro
assigned to a button on a spreadsheet.

What I have been unable to figure out is how to set this up so that the
users input appears on screen as a series of ******* instead of actual text.

(Using Excel 2000)

Any help greatly appreciated