Hi Vikas, after formatting the cell as '****' it won't display the cell contents as **** Plz help
~ 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
