How Can We Unlock VBA Project Password Without Hex Editor?

VBA (Visual Basic for Applications) is an integral component of MS Office, utilized by applications such as Excel, Word, and more. The VBA password serves to protect your critical files from unauthorized access. However, there may be instances where you are unable to access these files or have misplaced the VBA password, prompting the need to recover or crack the password.

In the following section, we will explore various methods of VBA password removal. Let’s delve into the procedures involved.

Methods to Recover VBA Passwords

There are two primary strategies for recovering a VBA password.

1. Systematic method (Manual).
2. Proficient method.

Systematic method (Manual)

Interchange passwords with Hex Editor

1. Create a new Excel file using a Hex Editor.
2. Now, need to create a password in the VBA field.
3. Then, save the file and exit.
4. Now, open the file which you have created by Hex Editor.
5. After, copy each line starting with CMG=…., DPB=…, GC=…  these keys.
6. By using Hex Editor, you can open the file in which you want to break the password and paste the line which was copied.
7. Then, you can save the file and exit.
8. Finally, open the Excel file where you wanted to see the VBA code and password are common as that file passwords which you make earlier.

By using WinRar/WinRar

1. Change the file format .xlsm to .zip.
2. Now, by the WinZip/ WinRar and start the Zip file and then, choose the .xl folder.
3. Then, extract the vbaproject.bin file then open it in Hex Editor.
4. After, search and replace the DPB with DPx and save the file.
5. Now, need to replace it with the latest one under the Zip file.
6. Again, you have to change the file format extension from ZIP to XLSM.
7. Then, start Visual Basic in MS Excel and select Tools and then VBA Project Properties.
8. In the following tab, choose the protection tab and continue with the new password and save it as a .xlsm file.
9. Finally, restart the VBA file with the new password.

Unlock VBA project password without Hex Editor(By Workbook)

1. First, open the Workbook where all protected sheets are available.
2. Then, press Alt+F11 and verify or open Visual Basic Editor.
3. Next, type Insert-Module then paste the code into the right-hand corner of the window.
4. After, close the Visual Basic and move to the worksheet which wants to unprotected.
5. Then, type Too-Macro-Macros and then double click on the password breaker in the given list and create the password.

Proficient Method to Unlock VBA project password without Hex Editor

If the above-described methods do not work well then, users can take the help of an automated solution. Out of which, one such application is the VBA Password Recovery. It is specially programmed to recover lost or forgotten password of VBA files without any data loss.

Conclusion

This post is about How to unlock VBA project password without hex editor? I hope your issue got solved. If you have any issues regarding any step, then feel free to contact us.

This article was updated in 2025 to reflect modern developments.