make characters unreadable

[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?

 

[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..

 

[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..

 

[Gord Dibben]

Check out VBA help on PasswordChar property.


Gord Dibben MS Excel MVP

 

[Gord Dibben]

Check out VBA help on PasswordChar property.


Gord Dibben MS Excel MVP

 

[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)

 

[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)

 

[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

 

[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

 

[Gord Dibben]

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


Gord

 

[Gord Dibben]

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


Gord

 

[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.

 

[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.