Guruuuuuuuuuuuuuuuuu!!!!!!!!!! Thanks guru, thank u very much...
i am really happy. i want another help. do u know any animation and multimedia group. like excel googlegroup.com? i want immediate reply. refer me. On Wed, Jun 15, 2011 at 5:12 PM, <hariharan.thara...@wipro.com> wrote: > Hi Kannan V > > > > Module – Tools – VBA Project Properties – Protection – Check (Lock Project > for viewing) and give password to it. > > > > *Thanks,* > > *Hariharan Tharagan* > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI > *Sent:* Wednesday, June 15, 2011 7:30 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ how to put password in vba coding.?? > > > > Dim x As Worksheet > Sub Protectsheet() > > For Each ws In Worksheets > x.Protect Password:="abc" > Next > End Sub > > > > On Wed, Jun 15, 2011 at 2:09 PM, kannan excel <kannan.ex...@gmail.com> > wrote: > > Hi Guru... > > > > how to put password in vba coding.?? > > > > how to protect that? > > > > regards > > > > Kannan V > > 9941077703 > > onechennaiproperty.com > > > > -- > > ---------------------------------------------------------------------------------- > 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 > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > > > > -- > > Thanks & regards, > > Noorain Ansari > > > > -- > > ---------------------------------------------------------------------------------- > 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 > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > *Please do not print this email unless it is absolutely necessary. * > > The information contained in this electronic message and any attachments to > this message are intended for the exclusive use of the addressee(s) and may > contain proprietary, confidential or privileged information. If you are not > the intended recipient, you should not disseminate, distribute or copy this > e-mail. Please notify the sender immediately and destroy all copies of this > message and any attachments. > > WARNING: Computer viruses can be transmitted via email. The recipient > should check this email and any attachments for the presence of viruses. The > company accepts no liability for any damage caused by any virus transmitted > by this email. > > www.wipro.com > -- ---------------------------------------------------------------------------------- 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel