InputBox and Password
 

HELP !!!
This is my problem. I have a workbook that has about 10 worksheets,
each individually named. All sheets apart from the Master Sheet is
hidden. On the master sheet, I have 10 individual WordArt pictures,
each with individual names. I am assigning one macro to all the
Wordart pictures. This is my problem:

I want to modify my macro so that whenever a person clicks one of the
WordArt pictures, something (even an input box) will appear asking the
person to enter a password. Based on the password entered, the
program will open a particular worksheet. At this point, my only
problem is to get something like an input box to request the password,
but I want a special character to appear instead of what the person
types. If I use the InputBox function, then everyone will see what the
person types. Can anyone assist me please??


---
Message posted from http://www.ExcelForum.com/

InputBox and Password
 

Hi

You need a userform for that. Insert one (vb editor, insert menu), put a textbox onto it
and set its password character to * or % or whatever.

Still, the audience can see the keyboard when entering the password ;-)

--
HTH. Best wishes Harald
Followup to newsgroup only please.

"carvil16 " wrote in message
...
HELP !!!
This is my problem. I have a workbook that has about 10 worksheets,
each individually named. All sheets apart from the Master Sheet is
hidden. On the master sheet, I have 10 individual WordArt pictures,
each with individual names. I am assigning one macro to all the
Wordart pictures. This is my problem:

I want to modify my macro so that whenever a person clicks one of the
WordArt pictures, something (even an input box) will appear asking the
person to enter a password. Based on the password entered, the
program will open a particular worksheet. At this point, my only
problem is to get something like an input box to request the password,
but I want a special character to appear instead of what the person
types. If I use the InputBox function, then everyone will see what the
person types. Can anyone assist me please??


---
Message posted from http://www.ExcelForum.com/