Password masking in a cell

  • Thread starter Thread starter Craig
  • Start date Start date
C

Craig

Hi there,
Is there anyway to mask a password as it is typed into the cell. Example is
I type 5555 into cell A1 but to the viewing eye they only see ****. Is this
possible. If so can I set up about 4 password that are validated after entry
into cell A1. To allow or Dismiss.

Thanks
Craig
 
You could use formatting to hide the display in the cell, but the value would
show up in the formula bar when the cell was selected.

If you really want to keep that password private, you could create a userform,
add a textbox and set the .passwordchar to "*".

Debra Dalgleish has a small tutorial at:
http://contextures.com/xlUserForm01.html
 
Back
Top