Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Password format
Hi !
I am wondering if there is a way to format a cell so that the text beeing entered is displayed as password characters (*) instead of the actual characters. Also is it possible to use a text box in a userform to have the user enter his password and display it the same way in the textbox ? Thanks Pierre |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Password format
You can use a custom number format like this:
;;;"*******" While editing the cell or looking at it in the formula bar, the password being typed will be visible. If you use a textbox from the control toolbox toolbar it has a passwordChar property which you can set. -- Regards, Tom Ogilvy "Pierre Archambault" wrote in message . .. Hi ! I am wondering if there is a way to format a cell so that the text beeing entered is displayed as password characters (*) instead of the actual characters. Also is it possible to use a text box in a userform to have the user enter his password and display it the same way in the textbox ? Thanks Pierre |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format Cell as Password | Excel Discussion (Misc queries) | |||
how to automate opening a password protected excel file? e.g. a .xls that has a password set in the security tab. | Excel Worksheet Functions | |||
bypass password when update linking of password protected file | Excel Discussion (Misc queries) | |||
Excel password but cant hide the sheets before entering password | Excel Programming | |||
VBa, Password protected sheet fails to get unprotected with the same password | Excel Programming |