Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Format Cell as Password Richard_123[_2_] Excel Discussion (Misc queries) 4 December 8th 08 10:14 PM
Password Protection - paste to unprotected cell locks the cell Jimbob Excel Discussion (Misc queries) 7 September 7th 07 06:22 PM
Password Protect - put password in a cell in the workbook Mike R. Excel Programming 2 September 1st 06 06:29 AM
PASSWORD REMOVAL I have the password to open the file and the password to modify the file now how to remove them LJ[_4_] Excel Programming 0 April 27th 06 03:18 AM
how to automate opening a password protected excel file? e.g. a .xls that has a password set in the security tab. Daniel Excel Worksheet Functions 0 June 23rd 05 11:56 PM


All times are GMT +1. The time now is 09:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"