Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
InputBox Help | Excel Discussion (Misc queries) | |||
InputBox with VBA | Excel Discussion (Misc queries) | |||
InputBox | Excel Discussion (Misc queries) | |||
inputbox | Excel Discussion (Misc queries) | |||
inputbox | Excel Programming |