Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format Cell as Password
Hello,
Is there any way to format a cell so that it displays what is typed in as a password (ie. as *****) rather than showing what has been typed in? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format Cell as Password
No, that can not be done by cell formatting, sorry.
Best wishes Harald "Richard_123" wrote in message ... Hello, Is there any way to format a cell so that it displays what is typed in as a password (ie. as *****) rather than showing what has been typed in? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format Cell as Password
Is there any other way of doing it? such as writing a macro?
Thank you. "Harald Staff" wrote: No, that can not be done by cell formatting, sorry. Best wishes Harald "Richard_123" wrote in message ... Hello, Is there any way to format a cell so that it displays what is typed in as a password (ie. as *****) rather than showing what has been typed in? Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format Cell as Password
No. Problem is; no macros runs while writing stuff into a cell. Can you
enter your password into something else? A userform textbox would be perfect. What is this for? Best wishes Harald "Richard_123" wrote in message ... Is there any other way of doing it? such as writing a macro? Thank you. "Harald Staff" wrote: No, that can not be done by cell formatting, sorry. Best wishes Harald "Richard_123" wrote in message ... Hello, Is there any way to format a cell so that it displays what is typed in as a password (ie. as *****) rather than showing what has been typed in? Thanks |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format Cell as Password
Event code OK?
Private Sub Worksheet_Change(ByVal Target As Range) Dim v As Variant, i As Integer If Intersect(Target, Me.Range("A1")) Is Nothing Then Exit Sub If IsNumeric(Target) Then MsgBox "all numbers not allowed" Else On Error GoTo CleanUp Application.EnableEvents = False v = Target(1, 1).Value Application.EnableEvents = False For i = 1 To Len(v) Target(1, 1).Characters(Start:=i, _ Length:=1).Text = "*" Next i End If CleanUp: Application.EnableEvents = True End Sub Note: the text will be seen while entering but change to ***** when enter key is hit. To have text appear as ****** while typing is beyond my skills. I don't think you can do that in a cell. Gord Dibben MS Excel MVP On Mon, 8 Dec 2008 13:02:01 -0800, Richard_123 wrote: Is there any other way of doing it? such as writing a macro? Thank you. "Harald Staff" wrote: No, that can not be done by cell formatting, sorry. Best wishes Harald "Richard_123" wrote in message ... Hello, Is there any way to format a cell so that it displays what is typed in as a password (ie. as *****) rather than showing what has been typed in? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Password Protection - paste to unprotected cell locks the cell | Excel Discussion (Misc queries) | |||
Password Protecting One Cell | Excel Discussion (Misc queries) | |||
How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) | |||
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 | |||
bypass password when update linking of password protected file | Excel Discussion (Misc queries) |