Home » Password Remover » How to Fix Excel VBA Password Not Working Error? [Solved]

How to Fix Excel VBA Password Not Working Error? [Solved]

Jaspreet Singh | Modified: July 14, 2023|Password Remover | 5 Minutes Reading

MS Excel is a popular platform for users. The end number of the organizations work on MS Excel for their business or personal use. MS Excel is having very large user database because this application provides very good security features to its users. But sometimes the problem occurs Excel VBA password not working.

Excel VBA Password Not Working

Hence, this problem generally occurs when the user sets a long password to protect an Excel file and forgot it. So, don’t worry! Here in this blog, you will get the best approaches to solve this problem in simple steps. Now, in the next section, we are going to mention the different solutions to solve this problem.

Let’s Understand the User Queries Related to the Issue —



Methods to Fix Excel VBA Password Not Working Issue

Now, first, find the best manual methods, and second, find an expert’s suggested solution to fix this problem. The following are mentioned below:

1# Remove Password Using Hex Editor

  • First, open a new Excel sheet using Hex Editor.
  • Second, apply the password in the VBA code on the new Excel file by pressing Alt + F11.
  • Then, save the excel file and exit it.
  • Now, open the Excel sheet you have created previously using Hex Editor.
  • The line beginning from CMG=…., DPB=…., GC=…. Copy all of them.
  • Then, with the help of Hex Editor open the Excel file from which you want to remove the password and simply paste the line mentioned above beginning from.
  • Exit before saving the Excel file.
  • Last, Open that Excel file from where you find that the Excel VBA project password not working to view the VBA password of it. And fill in the same password that you have used above in point 2.

2# Use Visual Basic Editor to Unlock Excel VBA Password

  • First, open the workbook file containing the password encrypted worksheet.
  • Then, to view the Visual Basic Editor in MS Excel press the Alt + F11 keys together.
  • Now, on the right side of windows paste the following code by typing Insert-Module:

Excel VBA Password Not Working

  • Exit the Visual Basic Editor screen and open the worksheet from which you want to remove the password.
  • Last, simply enter VBA password and click on the password breaker twice.

Now, all the above manual methods are too risky. And the chance of data loss. And for non-technical users, it is not an easy task to perform. So, in the next paragraph, we are going to mention the easiest approach to fix this problem.

Expert Solution to Fix Excel VBA Password Not Working Issue

Here is the perfect solution to remove the VBA password with the help of the Best VBA Password Remover Tool. This tool is completely tried and tested by the experts. And while using this tool there is no fear of data loss. And also a user-friendly tool it is for non-technical users.

Download Now Purchase Now

The Software is the best solution to quickly recover lost or forgotten passwords. It has advanced technology to easily disable VBA macro password and recover VBA project passwords of any length. Also, it supports MS Office versions like 2007, 2003, and 2000 to unlock VBA password project files. This powerful utility will help eliminate errors such as removing VBA passwords in Excel, Access, or Word VBA files.

4 Steps to Remove Password from VBA Protected Files

Step 1: Download and Run Software.
Step 2: Add VBA file to Recover Lost VBA Password.
Step 3: Select the Reset button to preview VBA Password.
Step 4: Preview report along with the File Path, Password, and Status.

Read Also: How to Remove XLSM VBA Password?

How to Use this Automatic Solution to Solve this Problem?

  • Start installing the expert Suggested Solution on your machine.

VBA Password Remover Tool

  • Click the “Add Files” button to add MS Office VBA project files (Excel, Word, Access, PowerPoint, etc.) from your system.

Add VBA File

  • Navigate to where you saved the VBA file and select it. Click the “Openbutton.

Select the VBA File

  • After adding the VBA file, the software loads it and displays the added VBA file in the program. It also displays the selected file path and file size (KB).

displays the added VBA file

  • You can also remove the added VBA files from the software panel. Just select the file and click the “Remove” button. Choose Remove All to remove all added VBA files from the software.

Remove all

  • After completing all the steps, then click the Reset button to open and restore the password protected VBA file.

Click on Reset Bouton


  • Now the process starts. Once the recover process is complete, the “Restart Process Completed Successfully” screen will appear. Click OK.

recover process is complete

  • Finally, the software will show a complete report with file path, password and status.

view Status Report


In the all above article, we have mentioned every solution to fix this problem “Excel VBA Password Not Working”. We have mentioned the manual methods with their proper working steps. Also, for the non-technical users, we have mentioned the perfect automated solution which is very reliable and secure.