Disguising data entries

W

Wicked Wizard

I am using MS Excel 2000 and Windows 2000.

My spreadsheet requires users to enter an ID before they can access the info it
holds. But when they type the ID in, it is visible to to client they are
working with, which is not very secure.

I thought I could format the cell as a password so that when the ID is typed in
only asterisks would show, but this does not seem to be possible.

Is there a solution to my problem please?


HTH

Wicked Wizard
 
J

Jason Morin

AFAIK it's not possible to do it directly in a worksheet
cell, but it is possible to do this with a textbox on a
userform. Set the textbox property called "PasswordChar"
to any character you wish, such as "*".

HTH
Jason
Atlanta, GA
 
Top