hi
hidden your cell and put password 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 > -- 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! `•.¸.•´. -- ---------------------------------------------------------------------------------- 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
