Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unreadable content | Excel Discussion (Misc queries) | |||
How to make an Excel Cell contain text more than 31,737 Characters | Excel Discussion (Misc queries) | |||
How can I make last characters of y-axis lables in graphs to show | Charts and Charting in Excel | |||
Unreadable date | Excel Discussion (Misc queries) | |||
How do you make some characters in a cell bold and some not? | Excel Discussion (Misc queries) |