Microsoft Excel - Can anyone remove vba password from this file ?

Asked By Virendra on 25-Aug-11 05:14 AM
Anoop S replied to Virendra on 25-Aug-11 05:39 AM
Sample Macro.zip here it is, password removed

how to remove password
download hex editor from here
http://www.hhdsoftware.com/Downloads/hex-editor


Close the workbook and open the workbook file in the hex editor. Find the string "DPB" and change it to "DPx". 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.
Virendra replied to Anoop S on 25-Aug-11 09:01 AM
Hi Anoop,

thanks for help but still i can't see the code in module this is giveing unexpected error (40230).

please help.
John D replied to Virendra on 25-Aug-11 08:56 PM
Hi Virenda
Try this one, it should work fine. No password
Sample Macro.zip
HTH
John
Anoop S replied to Virendra on 25-Aug-11 11:52 PM
I didn't added new password, thats why you can't see it, Press ALT+F11, Choose Tools->VBAProject Properties, navigate to the Protection tab, add new password and then confirm it again(if you want new password),
otherwise simply put blank textbox, remove click from lock project for viewing, then save excel and close and reopen it

Sample Macro.zip
Virendra replied to John D on 26-Aug-11 12:15 AM
Hi John,

Thank you very much it works perfect fine. ;)
Virendra replied to Anoop S on 26-Aug-11 12:16 AM
Thank you very much for your help . i am glad that you have given your time for me.