H Yogesh, To crack the password of an VBA Macro / coding first download an HEX Editor.
It is available from the site http://www.chmaas.handshake.de/delphi/freeware/xvi32/xvi32.htm (its a very small file of 0.5 MB capacity). Close the workbook and open the workbook file in the hex editor. Find the string "DPB" and change it to "DPx" (x is in small letter). Save the file. Open the workbook and click OK until the workbook is open (one or more dialogs are displayed describing various problems with the VBA project). Press ALT+F11, choose the menu command Tools- >VBAProject Properties, navigate to the Protection tab, and change the password but do not remove it (note the new password). Save, close, and re-open the workbook. Press ALT+F11 and enter the new password. Choose Tools->VBAProject Properties, navigate to the Protection tab, and remove the password. Save the workbook. Now open the same workbook, You can use the password that you already given. Regards, Yogesh Kudva On Mar 15, 10:04 pm, Yogesh sundaram <ysunda...@yahoo.com> wrote: > Guys, > > I need your help to crack the password for the VBA code in this spreadsheet, > the file is attached for your review. > > Thanks, > Yogesh > > RAPM.xls > 189KViewDownload -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 6,800 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
