Hi, You can use an alternate way to over come this. change the text color of cell to same as background then lock and hide it. After this protect the sheet.
Thanks and Regards Sandeep. On Tue, Jun 15, 2010 at 10:45 AM, Rajesh Bedse <rajeshbe...@gmail.com> wrote: > thx Vikas. > > The issue with this formatting is that it shows **** only when the > cell data is number. > I want the cell should always show the data as **** no matters what > the actual data is in the cell i.e. for number as well as for > character data. > > Please suggest. > > ~ Rajesh > > On Jun 11, 9:49 pm, Vikas Chouhan <vikask...@gmail.com> wrote: >> Chk this >> >> >> >> On Fri, Jun 11, 2010 at 7:19 PM, Rajesh Bedse <rajeshbe...@gmail.com> wrote: >> > hey Paul, >> >> > Plz let me know how can I atleast display the data like '***' >> > See teh below message sent my Saurabh... using this we can hike the >> > contents from formula bar. >> >> > Just go to format Cell --> Protection Tab --> Check the hidden box and >> > uncheck the locked box. Then protect the work sheet. >> >> > @ Saurabh >> > thnx a lot >> >> > ~ Rajesh >> >> > On Jun 11, 10:11 am, Rajesh Bedse <rajeshbe...@gmail.com> wrote: >> > > Thnx Paul, >> >> > > Yeah.. it will display data in formula bar. I don't want to display >> > > that. >> > > Plz help. >> >> > > ~ Rajesh >> >> > > On Jun 10, 10:58 pm, Paul Schreiner <schreiner_p...@att.net> wrote: >> >> > > > the problem is that you can change the cell formatting to make it LOOK >> > like "***" >> > > > but you'll see the actual value in the toolbar at the top, which isn't >> > good!!! >> >> > > > P >> >> > > > ________________________________ >> > > > From: Rajesh Bedse <rajeshbe...@gmail.com> >> > > > To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> >> > > > Sent: Thu, June 10, 2010 6:35:28 AM >> > > > Subject: $$Excel-Macros$$ How to display cell contects as password >> > ***** >> >> > > > Hi friends, >> >> > > > I want to display a cell content as password (i.e. like ****) >> > > > but the data should exist there.. so that I can use the same data in >> > > > macro for login purpose. >> >> > > > ~ Rajesh >> >> > > > -- >> >> > ---------------------------------------------------------------------------------- >> > > > Some important links for excel users: >> > > > 1. Follow us on TWITTER for tips tricks and links : >> >http://twitter.com/exceldailytip >> > > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 >> > > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com >> > > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com >> > > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com >> >> > > > To post to this group, send email to excel-macros@googlegroups.com >> >> > > > <><><><><><><><><><><><><><><><><><><><><><> >> > > > HELP US GROW !! >> >> > > > We reach over 7000 subscribers worldwide and receive many nice notes >> > about the learning and support from the group.Let friends and co-workers >> > know they can subscribe to group athttp:// >> > groups.google.com/group/excel-macros/subscribe >> >> > -- >> >> > ---------------------------------------------------------------------------------- >> > Some important links for excel users: >> > 1. Follow us on TWITTER for tips tricks and links : >> >http://twitter.com/exceldailytip >> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 >> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com >> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com >> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com >> >> > To post to this group, send email to excel-macros@googlegroups.com >> >> > <><><><><><><><><><><><><><><><><><><><><><> >> > HELP US GROW !! >> >> > We reach over 7000 subscribers worldwide and receive many nice notes about >> > the learning and support from the group.Let friends and co-workers know >> > they >> > can subscribe to group at >> >http://groups.google.com/group/excel-macros/subscribe >> >> -- >> One Team One Dream One Goal >> >> Warm Regards, >> Vikas Chauhan >> E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com, >> 9911868518, >> "We can't Spell S_ccess without U" >> >> Life is Very beautiful !!! >> ¨`•.•´¨) Always >> `•.¸(¨`•.•´¨) Keep >> (¨`•.•´¨)¸.•´ Smiling! >> `•.¸.•´. >> >> Passwords.JPG >> 54KViewDownload > > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
