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 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
