Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm only a basic novice but you could try protecting the sheet, adding
further, before you protect the sheet select the check box for "Hidden" on the format menu, this will then not show any data on the formula bar, you could then use the windings font for the password in the cell, hope this helps "Rayashe" wrote: You could just try and change the format of the cell: Format CellsNumberCustom and then enter as Type: ;;;*x This will fill the cell with x's - don't think you can use the * by itself though as it is a function. Don't know about a way to prevent it showing in the status bar apart from hiding the status bar "Shaves" wrote: Is there a way to display a cell as "*****" when the user enters data into a particular cell. I realize it may be displayed in the status bar, but I would prefer the contents not be visibile to anyone casually walking by this computer. Thanks for the help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Format Cell as Password | Excel Discussion (Misc queries) | |||
Password Protection - paste to unprotected cell locks the cell | Excel Discussion (Misc queries) | |||
Password Protect - put password in a cell in the workbook | Excel Programming | |||
PASSWORD REMOVAL I have the password to open the file and the password to modify the file now how to remove them | Excel Programming | |||
how to automate opening a password protected excel file? e.g. a .xls that has a password set in the security tab. | Excel Worksheet Functions |