How to Break VBA Password in Excel 2003 to 2021?

  author
Written By Tej Pratap Shukla
Anuraag Singh
Approved By Anuraag Singh  
Published On October 10th, 2023
Reading Time 7 Minutes Reading

Are you looking for a solution to break VBA password in Excel 2021, 2019, 2016, 2013, 2010, 2007, and previous versions? Then you’ve come to the right page. In this blog, you will find the most valuable ways to break Excel VBA project password without knowing the password. So, keep following this blog till the end.

VBA (Visual Basic for Application) is a component of MS Office and is used by Microsoft Applications such as Excel, Word, Access, etc. MS Excel 2007 to 2021 editions store macro enables workbook files in XLSM extension. While old Excel versions use the XLM extension.

XLSM or XLM are the file extensions for the visual basic file and contain the visual basic code. This file can be used to add functionality to the Office suite and automate routine tasks in Microsoft Excel.

But sometimes the user may forget or lose the VBA password, and now users try to crack VBA password in Excel XLSM and XLM files. Therefore, in the upcoming section, we are going to discuss all possible ways to let users understand how to break VBA project password in Excel, without any difficulty.

Table of ContentsHide

Quick Steps to Break VBA Password in Excel

  1. Run the Excel VBA password breaker tool.
  2. Add protected Excel VBA project in GUI.
  3. Select MS Excel VBA and click Remove.
  4. Break Excel VBA password process completed.
  5. Access macro enabled VBA without password.

Manual Ways to Crack Excel VBA Password XLSM

There are multiple tried and tested manual methods available to break Excel VBA passwords. Go through the following workarounds that will help to crack VBA password in Excel manually. Let us have a look:

#1 Method: Crack Excel VBA Password Hex Editor

  1. Create the new Excel file (XLS) using any kind of Hex editor.
  2. Then, you need to set a specific password in the VBA field (Alt + F11).
  3. After that, you can save that file and press Exit.
  4. Next, open a file that you have recently created with the help of the hex editor.
  5. Copy each line starting CMG=…, DPB=…, and GC=…
  6. Using Hex Editor, you can open a file in which you want to break the password and paste these copied lines from a dummy file.
  7. Now, you will save the Excel files and, then exit to crack VBA password in Excel workbook.
  8. Open the Excel file where you wish to see the VBA code and Next, use the common password that you have already used for the dummy VBA file in the previous step.

#2 Method: Break Excel VBA Password Using WinZip or WinRAR

  1. Change the file extension of .xlsm into .zip.
  2. Through the WinZip / WinRAR, start the ZIP file and then, select the .xl folder.
  3. Now, you extract the vbaProject.bin file and, then open that file in Hex Editor.
  4. Search and replace the DPB with DPx and save that particular file.
  5. Under the Zip file, you can replace the previous vbaProject.bin file with this latest one.
  6. Again, you have to change the file extension from ZIP to XLSM file.
  7. Start Visual Basic in MS Excel, choose Tools and VBAProject Properties. Then, select the Protection Tab, and now, you can add a new password and save the .xlsm file.
  8. Close and re-open the VBA file with a new password.

#3 Method: Crack Excel Macro Password with Visual Basic Editor

  1. First, you can open the workbook in which all protected sheets are available.
  2. Press Alt + F11 to verify or open the Visual Basic Editor.
  3. Next, type Insert-Module and paste the following code into the right corner of the window.
    VBA code to crack excel workbook password
  4. Click the F5 button to run the above VBA code script to break VBA password in Excel Sheet.
  5. After that, you can open and edit Excel VBA projects without typing a password.

Some Manual Method Drawbacks

The above-mentioned manual techniques allow you to crack Excel VBA password in XLSM files one by one. Hence, these methods seem time-consuming, so these methods are not recommended for business users.

If you crack Excel macro password with visual basic editor, hex editor, and WinZip or WinRAR methods. Then there is no guarantee of data loss and manipulation. Even the manual ways require technical knowledge.

Recommended: Expert Guide to Unlock Access VBA Project

Automated Way to Break Excel VBA Project Password

If the above-described methods do not work well, then users can take advantage of an automated solution. One such application is the SysTools VBA Password Remover Tool. The tool comes with a simple graphical user interface hence, all technical and non-technical users can easily use this software without having technical expertise.

Download Now Purchase Now

It is specially programmed to unprotect VBA projects in Excel files without any data loss. It also supports different MS Office files like .xls, .xla, .doc, .mdb, and .dot file types. The best part of this tool is that it eliminates old passwords and generates a new VBA Project password. It has an easy-to-use interface even though technical knowledge is not mandatory while using this tool. The complete working steps of the tool are listed below:

How to Crack VBA Password in Excel 2003 to 2021?

  1. Launch the Excel VBA password breaker on your machine.
    Run Excel VBA password breaker
  2. Choose the Add File(s) or Add Folder button to add protected Excel VBA projects.
    Add protected Excel VBA projects
  3. Select Excel XLSM macro-enabled files and click Open to load them into the software.
    Select Excel VBA projects
  4. After that, enable the Remove option from the Reset or Remove dual choices.
    Reset and Remove options
  5. Choose the required Excel VBA projects and click the Remove button.
    Click Remove to break VBA password in Excel
  6. Break VBA password in Excel XLSM process completed, click OK.
    Crack Excel VBA password
  7. See Excel VBA password cracked successfully in bulk.
    Completed

Excel VBA password Breaker Prime Features

  • Break VBA password in Excel 2021, 2019, 2016, 2013, 2010, 2007, 2003, and all.
  • No need to type script code to break Excel VBA password in easiest way.
  • Batch crack Excel VBA password XLSM (Macro enabled workbook with code).
  • Offers dual options to crack password VBA project Excel i.e., Reset & Remove.

Let’s Wrap Up

There are many people who have lost or forgotten their VBA password. Therefore, in this blog, we have mentioned the 4 best methods through which users can break VBA password in Excel 2021, 2019, 2016, 2013, 2010, 2007, and 2003. In case the manual ways do provide precise results. Thus, we have suggested a trustworthy and instant solution, i.e., automatic software. With the help of this utility, users can restore lost passwords in a trouble-free manner.

Frequently Asked Questions

Q) Will the tool break multilingual passwords from Excel VBA projects?

Yes, this tool will remove any type or size of password from the selected file.

Q) Can I use your software to break VBA password in Excel XLM file?

Yes, this software is suitable to break Excel VBA passwords in XLM and XLSM projects.

Q) Can I use Macro code script again after breaking password?

Yes, first break VBA project password in Excel, after that, you can reuse VBA Macro code.

  author

By Tej Pratap Shukla

A versatile technocrat, always in the search for new and interesting areas related to technology. Works on multiple technical problems faced by users frequently. Provides the user-friendly solutions to deal with numerous technical issues.