thnx for ur reply @ Sandeep if we change the color to background color, it won't help as we can still copy the cell contents using Ctrl+C.
@ Vikas Yeah.. I did that, but it only work for numeric data :( If you have any other option plz let me know. keep posting . thnx ~ Rajesh On Jun 19, 10:12 pm, Vikas Chouhan <vikask...@gmail.com> wrote: > 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 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! > `•.¸.•´. -- ---------------------------------------------------------------------------------- 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
