How to unlock Protected Excel VBA Project and Macro codes without password

Author: Amarindaz
13614 View
6m 27s Lenght
42 Rating

Title:How to unlock Protected Excel VBA Project Macro codes without password or using any paid software Blog: http://www.amarindaz.com/ Facebook Page:http://facebook.com/amarindaz Recommended Excel VBA books =================================================== http://www.amarindaz.com/go/excel-vba-24-hour-trainer/ http://www.amarindaz.com/go/excel-2016-power-programming-vba/ http://www.amarindaz.com/go/excel-2013-power-programming-vba/ ==================================================== If you have ever forgotten a password for the VBA Projects then you know how frustrating that can be. No needs to worry any more and in this video, you'll learn how to unlock VBA Project and codes which get stored in it. In this method, you no need to use any paid software to unlock VBA Macro Code. You can download the free Hex Editor tool from http://www.chmaas.handshake.de/delphi/freeware/xvi32/xvi32.htm Follow the below simple steps to unlock the Protected Excel VBA project Step 1 Make a copy of your Macro enabled xlsm workbook. Step 2 Change the file format of the Macro-enabled workbook from xlsm to zip Step 3 Unzip the zip file. Go to xl folder and inside that you'll find a binary file called "vbaproject.bin" Step 4 Open the VBA Project binary file using Hex editor. Find the word "DPB" and replace that with "DPx". Save the VBA Project binary file and close it Step 5 Come back and zip it again with any naming convention but with extension .xls Step 6 Go to VBA Project- Tools- VBA Project properties. Unchecked the option Lock project for viewing in the Protection tab. Save and close the workbook Step 7 Open the same workbook and now you can able to see the Modules and code reside in that. Congratulations You've successfully unlocked the VBA project code without using the password Please let me know if you have any doubts. Please subscribe!!!

Comments

  1. how come this does not work on a locked project with an xlam for add-ins? I created one that I forgot the password on it.
  2. Hi,Xl folder is missing when i zipped the file.Could you help me out?
  3. It's was amazing... thanks... Amar :)
  4. Its works. Thanks for help
  5. When I try to open the .xls file, XL tells me that it can't because the file is corrupt.
  6. its works bro thanks u very much apprisated
  7. Thank you very much for your help
  8. Daaaaam Worked like a charm. Thank you very much!
  9. can you help me uncock 1 file *.xla ?
  10. Didn't work for me, but thanks for the video