Note: Before starting the password breaking process make sure to take a backup of your Excel workbook.
Break VBA Password in Excel using Hex Editor
- To break VBA project password, you need to download Hex Editor.
- If you have an XLSM file then first save it as XLS file.
- Now open your Excel workbook in Hex Editor. In Hex Editor workbook looks like this.
- In Hex Editor search for DPB text string.
- Something like this will appear on your screen.
- Now change the DPB text string with DPX to confuse Microsoft Excel.
- Save the changes and close the Hex Editor.
- Now open the workbook in Microsoft Excel, you will get the message (as shown in the image below) click on Yes to proceed further.
- After that you may get another error (Unexpected error 40230) message, and click on OK button.
- Now in Microsoft Excel, open Visual Basic Editor > select View > Project Explorer. Right click on VBAProject and select VBAProject Properties.
- In VBAProject – Project Properties window, click on Protection tab and uncheck Lock project for viewing and clear password.
- Save the changes and close Excel workbook. Now you can open VBA macro file without password.
Break VBA Macro Password using Automated Solution
VBA password bypasser is an outstanding solution to break VBA password in Excel 2007, 2003, 2000 and all the below versions. The software can recover password of any length and the password created with characters, numbers and synonyms is also recoverable with this software. The software first break VBA project password and then generate new password for use. The is compatible with all the latest version of Windows Operating System and can be installed on Windows 8, 7, XP and all the blow versions.
Follow the steps mentioned below to break VBA macro password:
- Download and Install VBA password breaker on your system. Click on Browse button to add password protected file to software.
- Software will remove the password and a pop up window will shows you successful message.
- After that you can see the new password in software’s recovery details section.
In this article I have showed you how to break VBA project password in Excel 2007, 2003 and all the below versions using Hex Editor and VBA password breaker tool. After performing the steps mentioned above you will be able to access VBA project without any kind of restriction.