Doesn’t work? Try this tool –
If this solution doesn’t work, try removing password from VBA project online

Title: How to unlock Protected Excel VBA Project Macro codes without password or using any paid software

If you need my assistance to unlock the Excel VBA, I’m offering this as paid service. I’m charging $5/Workbook. Kindly get in touch with me

Blog:
Facebook Page:

Recommended Excel VBA books
===================================================

====================================================
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

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!!!

Nguồn: https://thefirstworldwar.net/

Xem thêm bài viết: https://thefirstworldwar.net/category/cong-nghe

37 thoughts on “How to unlock Protected Excel VBA Project and Macro codes without password

  1. Tuve que hacerlo 3 veces, en lugar de usar x, usar "X" en mayúscula, teniendo así DPX en lugar de DPx, y funciono! un éxito gracias! probado en excel 2016 y usando HxD como editor hex.

  2. You can also just use Notepad++ if you do not already have a hex editor installed. It works the same but might be easier for most people. I have a tutorial on my channel if you want to check out that method also.

  3. Hello,

    I want to password protect and unprotect an excel workbook using VBA. And want the macro to pull the password from another file. Please help me with the code.

  4. Hello Amarindaz, Thanks for your beautiful video. However, I am having problems with searching for DPP using the XV132 Hex Editor (like yours on the video). When I do a search for DPP string, it does not find it. I tried many times but with no success. Kindly help with advice on what to do to resolve this, please. Again thank you.

  5. I m stuck at one point where pop up appears that 'project file contains an invalid key "DPx" continue loading project. when i press YES button then an error appears "UNEXPECTED ERROR 40230" what would i do now to resolve this error?

  6. I have project containing more folders then the normal like drawing and printer setting folders. Can you please say me how to unlock that ?
    This video of you was really very useful for many thing thank you!!

Leave a Reply

Your email address will not be published. Required fields are marked *