Hi Dharti, There are softwares available which can crack your VBA password easily but if you make a complex password using combination of numeric, alphabets and special characters then I think it is difficult to break.
I hope it answers your question. Feel free to write back in case of further queries. Thanks and Best Regards, Ayush Jain Microsoft MVP On Mon, Dec 13, 2010 at 2:37 PM, Dhartikumar Sahu <dhartiku...@gmail.com>wrote: > 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 > -- Best regards, Ayush Jain -- ---------------------------------------------------------------------------------- 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
