Home » Blog » How To » How to Remove VBA Password from Excel File? Complete Guide

How to Remove VBA Password from Excel File? Complete Guide

  author
Published By Karen Chard 
Rollins Duke
Approved By Rollins Duke
Published On April 19th, 2024
Reading Time 5 Min Read

There is nothing more frustrating than finding the password of an Excel file which is protected with a VBA password, that you have forgotten. Or maybe you want to delete the password from Excel file, which has been protected by your ex-employee and you’re stuffed now. Don’t worry, I have some ideas to remove VBA password in Excel workbook 2021, 2019, 2016, 2013, 2010, 2007, and previous versions.

What You Will Find Here? Hide
  1. How to Remove VBA Password in Excel File Automatically?
  2. Quick Steps to Remove VBA Password in Excel
  3. Why Advanced Solution Over Manual Method?
  4. How to Break VBA Password from Excel Workbook Manually?
  5. Drawbacks of Manual Methods
  6. Time to Say Goodbye

We all know VBA stands for Visual Basic for Application, which is used by Microsoft apps like Excel, Word, Access, PowerPoint, etc. MS Excel from 2007 to 2021 saves macro-enabled workbook files as XLSM, while older versions use XLM.

Only XLSM or XLM file formats for visual basic files and store the visual basic code. This file helps make Office Suite better and automate tasks in Microsoft Excel.

But sometimes happened, when users forget their passwords due to multiple reasons and scenarios. So here we are going to explain the method ways to remove VBA passcodes in Excel workbook with complete information.

How to Remove VBA Password in Excel File Automatically?

Download the RecoveryTools VBA Recovery Tool to break VBA password in Excel file easily with preserved complete data. This software is ideal for unlocking password from any type of Excel file including doc,.docm,.dot,.dotm,.xls,.xlsm,.xlsb,.xlam,.xltm,.xlt,.xla,. it comes with amazing and advanced features, which makes it first choice of experts to remove VBA password in Excel.

Also, it comes with the free demo version, so that all types of users can analyze the software’s performance and features. Some of the advanced capabilities and complete steps are given below:

Quick Steps to Remove VBA Password in Excel

  • Step 1: Download and start the tool.
  • Step 2: Add your protected files/folders.
  • Step 3: Select the required data file from panel.
  • Step 4: Browse the saving location.
  • Step 5: Click on the Remove button.
  • Step 6: Your file will be unlocked.

Why Advanced Solution Over Manual Method?

  • Users can easily remove VBA password in Excel workbook in bulk at once without having any file size limitations, also it can easily work with large size of locked files.
  • The manual method can only break VBA password from Excel file, while the expert solution can break VBA passcodes from Word /PowerPoint/ Access/ AutoCAD/ ArcGIS/ CATIA/ CorelDraw and SolidWorks.
  • Our developers have created this tool with highly advanced algorithms, so it provides virus and risk-free results. And also, it maintains the all-important details of your data.
  • The dual option allows users to upload single or multiple VBA-protected Excel files and folders at once using Select Files and Select Folders options to remove VBA passwords in Excel.
  • The Browse (Folder) option gives freedom to users to select the desired location to save results. Also, it chooses the desktop path by default.

How to Remove VBA Password from Excel Workbook Manually?

Here we will mention 3 manual methods to break VBA password in Excel files. All the methods are given below one by one in detail:

# 1: By Changing File Extension

  1. Firstly, change the extension from .xlsm to *.zip of VBA.
  2. Now open this zip file with WinZip/ WinRar.
  3. Hit on the .xl folder.
  4. Extract VBAProject.bin from here and open It in Hex Editor.
  5. Now look for the DPB replace it with DPx and save the file.
  6. After that, replace your old VBAProject.bin with the new VBAProject.biv.
  7. And now change the extension from *zip to *.xlsm.
  8. Open Visual Basic in MS Excel >> Tools >> VBAProject Properties.
  9. Select the Protection, put the new password, and save the *.xlsm file.
  10. Lastly, you can open your Excel file with a new password.

#2: Remove VBA Password in Excel without Hex Editor

  1. Create a new Microsoft Excel XLS/ XLSX with Hex Editor.
  2. Now you have set a password in the VBA field (Alt + F11).
  3. After that, save the created file at any path and exit.
  4. Open the newly created file using Hex Editor.
  5. And copy all file which starts with CMG=…, DPB=…, and GC=….
  6. After that, open the VBA-protected file in Hex Editor.
  7. And paste it here.
  8. Save this file to remove VBA password in Excel.
  9. Finally, you can open your protected VBA Excel file with the common password.

#3: VBA Remove Password from Excel with Workbook

  1. Open your password-protected Excel workbook.
  2. Click on the Alt + F11 to open Visual Basic editor.
  3. After that, copy and paste the given VBA module from Insert Module.

    code

  4. Click on the F5 and start the code.
  5. And finally, you can open your protected Excel without putting in the password.

Drawbacks of Manual Methods

  • These methods will not work with bulk files to remove VBA password from Excel file.
  • Also, it will take a long time to accomplish this task.
  • Users should have good technical knowledge to start this process.
  • And there is no 100% guarantee that this method will work.

Time to Say Goodbye

Here we have explained the best and complete methods to remove VBA password in Excel workbook 2021, 2019, 2016, 2013, 2010, 2007, and previous versions. We have used both manual and expert solutions with all the information and step-by-step guide. Expert solutions are better than manual method because manual ways have lots of drawbacks. So it is better to use professional tools. We have tried to provide complete information; hope you find the article helpful.