Hi Ayush thanx for reply. but can i protect my vba password. ( no one can break the password).
Thanks & Regards Dhartikumar On Sat, Dec 11, 2010 at 2:39 PM, Ayush <jainayus...@gmail.com> wrote: > Hi Dharti, > > Good Question! > > I just did a quick check of the VBproject object model and don't find > anything that indicates it is possible to protect or unprotect a VBproject > from within VBA. VBA can only test (read-only) whether a VBproject is > protected or not. It would have very interesting implications if a > VBproject's protection could be changed from VBA, because it would mean that > a VBproject could set or remove its own protection. > > You might try using SendKeys to actually send the necessary keystrokes to > the VBE user interface. Also, you may refer to cpearson website which has > wealth of information on VBProject object model. > http://www.cpearson.com/excel/vbe.aspx > > I hope it helps. Please let me know if you are able to find solution from > any other source. > > Good Luck! > > Keep Posting. > > Best Regards, > Ayush Jain > Group Manager > Microsoft MVP 2010 > > P.S. Please use appropriate subject title for quick response. > > > -- > > ---------------------------------------------------------------------------------- > 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- ---------------------------------------------------------------------------------- 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
