If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
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? |
#6
|
|||
|
|||
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? |
#7
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|