make characters unreadable

W

widman

is there a way that someone can type a user or password in a cell where only
**** or something appears instead of what is typed?
 
J

Jacob Skaria

One way is to play around with the fonts by changing the font of that
particular cell to Webdings, Wingdings x..but again formula bar will display
the actual text..
 
W

widman

Is there any way to do it without the form/macro, etc?
Or a way to have the formula bar hidden in one particular worksheet, but
appear in the rest (Excel 2003)
 
G

Gord Dibben

Not knowing why you want to do this makes it difficult to suggest a good
method.

1. You can Custom Format the cell with ;;; 3 semi-colons.

Nothing will show in the cell.

2. Format the cell to unlocked and hidden then protect the sheet.

That will prevent anything showing in the formula bar.

Or this method.................

Hiding the formula bar is a global setting but you could hide it whenever
that specific sheet is activated

Private Sub Worksheet_Activate()
Application.DisplayFormulaBar = False
End Sub

Then unhide when sheet is de-activated.

Private Sub Worksheet_Deactivate()
Application.DisplayFormulaBar = True
End Sub

Use the event code in conjunction with 1 above

The two events are stored in the sheet module.

Right-click on the sheet tab and "View Code"

Copy/paste into that module. Alt + q to return to the Excel window.


Gord
 
G

Gord Dibben

Note.............if you want something secure neither of the methods below
will provide that.


Gord
 
W

widman

Excellent. Thanks. the ;;; is great and simple. And I always wondered what
hidden did, so that is great.
It is a simple time record for 5 employees that with their passwords the
time entering or leaving shows up in the right cell.
 
Top