I like to use InputBox asking a password, but how can I hide the
typing with for instance ****

Maybe there is an easy way to have a name/pass/log/add user to excel
sheets, but at this moment I use a vbVeryHidden sheet where I have the
names and passes. When a new user types in his name/pass there is an
acceptation code asked that only I know and that changes with the
date. After the correct code the user is added to that hidden sheet.

Use a Userform instead of an inputbox. Its Textbox has a password character property that
you can set to *.

--
HTH. Best wishes Harald
Excel MVP

Followup to newsgroup only please.

"Michel" wrote in message
om...
I like to use InputBox asking a password, but how can I hide the
typing with for instance ****

Maybe there is an easy way to have a name/pass/log/add user to excel
sheets, but at this moment I use a vbVeryHidden sheet where I have the
names and passes. When a new user types in his name/pass there is an
acceptation code asked that only I know and that changes with the
date. After the correct code the user is added to that hidden sheet.

Hi.

Try that.
http://disciplus.simplex.free.fr/classeursxl/ac-
passwordinputbox.zip

Alain CROS.

-----Original Message-----
I like to use InputBox asking a password, but how can I
hide the
typing with for instance ****

Maybe there is an easy way to have a name/pass/log/add
user to excel
sheets, but at this moment I use a vbVeryHidden sheet
where I have the
names and passes. When a new user types in his name/pass
there is an
acceptation code asked that only I know and that changes
with the
date. After the correct code the user is added to that
hidden sheet.
.