Home » Blog » How To » How to Crack VBA Password in Excel? Complete Guide

How to Crack VBA Password in Excel? Complete Guide

author  Admin ~ Modified: June 19th, 2023 ~ 6 Minutes Reading

Are you also looking for methods to crack VBA password in Excel workbook? If yes, then you are on the right page. here we are going to solve your all problems, that you are facing while breaking VBA project password in Excel using manual and expert solutions.

We all know that VBA is a programming language used to design any simple files in Microsoft applications such as Excel, Word, PowerPoint, etc. and many times happened when users forget their passwords to the VBA project Excel workbook.

And this is one of the worst and most frustrating situations. So, to solve these types of queries here we are going to mention the complete information with step by step guide.

But before starting the process, let’s have a look at the user queries that we are receiving over the past few days to crack VBA password in Excel.

“Hello there, I am a manager in an IT company, where around 10 to 15 employees left their jobs in the past few days. But now the problem is that they have some important data of the company in an Excel sheet and they have used VBA code in the Excel workbook which they had protected with passwords. Now some of the employees forget the password and some lost. And those files are so important to us, please suggest to me some methods how to can I unlock VBA password from Excel workbooks in bulk.”
“Hey, I have created Excel with an amazing and advanced design using VBA code. Now I want those codes to present my work. But I forget the password and that code is very important to me. Could anyone suggest to me the right solution how can I crack VBA password in Excel book?”

How to Remove Password from VBA Code in Excel Workbook?

Here we are going to mention manual methods with drawbacks and advanced solutions with amazing features. First, we will explain all the manual methods to crack VBA password in Excel workbook. And then we will mention the tool.

Crack VBA Password in Excel By Changing File Extension

  1. Change the VBA project extension from .xlsm to .zip.
  2. Now open the change zip file with the WinRar application.
  3. Choose the .xl folder.
  4. Now export the vbaProject.bin file and open that file in the Hex editor.
  5. Find and replace DPB with DPx and save the file locally.
  6. Now again change the extension from zip to XLSM.
  7. Begin the Visual Basic in MS Excel.
  8. Click on the Tools >> VBAProject Properties >> Protection options.
  9. Add the new password and save the .xlsm file.
  10. Lastly, shut down the file and reopen the file with a new password.

Break VBA Project Password in Excel using Hex Editor

  1. Firstly, make a new XLS file using Hex Editor.
  2. Set a password in the VBA field using Alt + F11 keys.
  3. Save the file and click on the Exit button.
  4. Open the previously created file using Hex Editor.
  5. And copy the all lines starting from keys: CMG=…. DPB=… GC=…
  6. Open the file that you want to break VBA code with Hex Editor.
  7. And paste the lines that you have copied from the previous file.
  8. Save this file and then exit to crack VBA password in Excel workbook.
  9. Open that file which VBA code you want to see and click on the Next button, and use the common password that you have created in the sample file first.

Using Workbook

  1. Firstly, open VBA code password-protected file.
  2. Hit the Alt + F11 keys to open a visual basic editor.
  3. Choose the “Inset Module option” and paste the given code into the VBA module.

    Inset Module option

  4. Click on the F5 key and start the code to crack VBA password in Excel workbook.
  5. Now you can easily open the file without Excel VBA project without asking password.

Why Users Don’t Use Manual Methods?

  • If you have a single VBA password-protected file, then this method is good for you. But if you have a large number of files to crack VBA password in Excel then this task will make tedious for you.
  • These methods required high technical knowledge, so please use these methods if you are technical savvy.
  • Also, there is no 100% guarantee that these methods will work surely. Also, there is a high risk of data loss.

How to Crack VBA Password in Excel? Professional Solution

Always use a professional solution whenever you want to unlock or break any kind of password. To remove password from VBA code in Excel here we are going to use the VBA Password Remover tool. The software comes with amazing and advanced features, and also there is no risk of data loss or corruption while cracking VBA Password in the Excel workbook. Not only Excel, but it can also remove VBA password from PowerPoint.

The software is compatible with all Excel versions including Excel 2021, 2019, 2016, 2013, 2010, 2007, 2003, etc. Also, it has an end number of features that are mentioned below with step by step working guide.

Steps to Break VBA Project Password in Excel

  1. Download and install the software on your machine.

    software on your machine

  2. Add the VBA project password Excel file using the Select Files and Select Folders option and click on the Next button.

    Add the VBA project password Excel

  3. All the files will appear and check /the boxes that you want to unlock.

    All the files will be appeared

  4. Select the location to save the resultant file.

    Select the location

  5. Lastly, click on the Remove button to crack VBA password in Excel workbook.

    crack VBA password in Excel workbook

Benefits of Using Professional Methods

  • Dual options to add single or multiple password-protected Excel files using Select Files and Select Folders options.
  • The software can unlock and crack the passwords of Excel files without losing any data and information.
  • Users can remove password from VBA code in Excel from selected files and folders to save users time and energy.
  • Not only in Excel, but the software will remove passwords in Word / PowerPoint / Access / AutoCAD / ArcGIS / CATIA / CorelDraw and SolidWorks.
  • Users can download the software in any Windows OS including Windows 11, 10, 8, 7, and all previous versions.

Time to Say Goodbye

Here we have added all possible methods and information to crack VBA password in Excel workbook. We have used the manual methods first, if you are technically savvy and have limited files to unlock then go for these methods. but if you are a non-technical person with unlimited files to crack passwords. Then you should use the expert tool, which comes with advanced features and filters. also, if you have any doubts about the software, then you can download the free version of this tool. I hope you find the article beneficial for you.