![]() |
password in a cell
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. |
All times are GMT +1. The time now is 01:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com