make characters unreadable
 

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?

make characters unreadable
 

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..
--
If this post helps click Yes
---------------
Jacob Skaria


"widman" wrote:

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?

make characters unreadable
 

Check out VBA help on PasswordChar property.


Gord Dibben MS Excel MVP

On Sun, 17 May 2009 09:47:21 -0700, widman
wrote:

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?

make characters unreadable
 

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" wrote:

Check out VBA help on PasswordChar property.


Gord Dibben MS Excel MVP

On Sun, 17 May 2009 09:47:21 -0700, widman
wrote:

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?

make characters unreadable
 

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


On Sun, 17 May 2009 12:33:01 -0700, widman
wrote:


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" wrote:

Check out VBA help on PasswordChar property.


Gord Dibben MS Excel MVP

On Sun, 17 May 2009 09:47:21 -0700, widman
wrote:

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?

make characters unreadable
 

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


Gord

On Mon, 18 May 2009 12:44:43 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

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


On Sun, 17 May 2009 12:33:01 -0700, widman
wrote:


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" wrote:

Check out VBA help on PasswordChar property.


Gord Dibben MS Excel MVP

On Sun, 17 May 2009 09:47:21 -0700, widman
wrote:

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?

make characters unreadable
 

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.




"Gord Dibben" wrote:

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


Gord

On Mon, 18 May 2009 12:44:43 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

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


On Sun, 17 May 2009 12:33:01 -0700, widman
wrote:


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" wrote:

Check out VBA help on PasswordChar property.


Gord Dibben MS Excel MVP

On Sun, 17 May 2009 09:47:21 -0700, widman
wrote:

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?