formatting the cell as a password character * * *

srinivas14 · Mar 27th, 2002, 11:53 PM

I have a spreadsheet that contains the following data of the about 150 people:
User Id
Password
Full Name
E-Mail
Telephone
But I want to format the password column in the usual ( " ***** ") style. I tried using the custom formatting as ["*"](#####), which MS-Excel would not allow me.
Any help???

_________________
Here is a follow-up:
I tried putting * "****" in the custom formating. This shows the password as ***** in the cell but the formula bar betrays you.

[ This Message was edited by: srinivas14 on 2002-03-27 22:59 ]

Dave Hawley · Mar 28th, 2002, 12:02 AM

Hi srinivas14

The only way you can get around this is to have these cells have their "Hidden" Property set (Format>cell-Protection) and then protect the sheet. You would then keep the Custom format you have and enter each password as a formula, eg

="MyPassword"

srinivas14 · Mar 28th, 2002, 12:10 AM

Thanks for the help, Boss.
But that leads to another problem. When protected (for only contents, say), I will not be able to adjust column widths or format text (Bold, color, etc).

Dave Hawley · Mar 28th, 2002, 12:24 AM

I thought that might be a problem. The only other option is some VBA. Right click on the sheet name tab and select "View Code" and paste in this:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Range("A1") = "Edit" Then End
If Target.Column = 5 Then Target.Offset(0, -1).Select

End Sub
End Sub

This will prevent any cells in Column "E" from being selected but only if the word "Edit" is NOT in cell A1.

_________________
Kind Regards
Dave Hawley
OzGrid Business Applications
Microsoft Excel/VBA Training

[ This Message was edited by: Dave Hawley on 2002-03-27 23:28 ]

srinivas14 · Mar 28th, 2002, 12:38 AM

Thanks Dave.
A clever trick, I should say....

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 27th, 2002, 11:53 PM	#1
srinivas14 Join Date: Mar 2002 Location: Chennai, India Posts: 99	I have a spreadsheet that contains the following data of the about 150 people: User Id Password Full Name E-Mail Telephone But I want to format the password column in the usual ( " ***** ") style. I tried using the custom formatting as [""](#####), which MS-Excel would not allow me. Any help??? _________________ Here is a follow-up: I tried putting "**" in the custom formating. This shows the password as *** in the cell but the formula bar betrays you. [ This Message was edited by: srinivas14 on 2002-03-27 22:59 ]

Mar 28th, 2002, 12:02 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi srinivas14 The only way you can get around this is to have these cells have their "Hidden" Property set (Format>cell-Protection) and then protect the sheet. You would then keep the Custom format you have and enter each password as a formula, eg ="MyPassword"

Mar 28th, 2002, 12:10 AM	#3
srinivas14 Join Date: Mar 2002 Location: Chennai, India Posts: 99	Thanks for the help, Boss. But that leads to another problem. When protected (for only contents, say), I will not be able to adjust column widths or format text (Bold, color, etc).

Mar 28th, 2002, 12:24 AM	#4
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	I thought that might be a problem. The only other option is some VBA. Right click on the sheet name tab and select "View Code" and paste in this: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Range("A1") = "Edit" Then End If Target.Column = 5 Then Target.Offset(0, -1).Select End Sub End Sub This will prevent any cells in Column "E" from being selected but only if the word "Edit" is NOT in cell A1. _________________ Kind Regards Dave Hawley OzGrid Business Applications Microsoft Excel/VBA Training [ This Message was edited by: Dave Hawley on 2002-03-27 23:28 ]

Mar 28th, 2002, 12:38 AM	#5
srinivas14 Join Date: Mar 2002 Location: Chennai, India Posts: 99	Thanks Dave. A clever trick, I should say....