How to Disable VBA Macro Password? Best Solutions
Do you have multiple VBA files from which you want to disable VBA macro password? Are you seeking for multiple ways to remove VBA macro passwords? If yes, then follow this write-up. Here in this blog, we are going to discuss about different methods to disable VBA project passwords safely and securely.
Table of Contents
- Disable VBA Macro Password using Automated Tool
- Key-Features of Professional Tool
- Manual Method to remove VBA password
- Last Words
Disable VBA Macro Password Using Professional Tool
Download Tool Purchase Now
This VBA Password Remover Software is one of the best tools to remove VBA macro passwords. It has a simple user interface so that non-technical users can easily use this tool. Let’s begin with the working of this software.
- Download and run the VBA Password Remover Software on your system
- Click on the “Add Files or Add Folder” option to add the VBA macro files
- Select the files from which you want to disable VBA macro password and click on the “Open” button
- After adding the files, hit the “Remove or Remove All” option to delete the wrongly added files from the software panel
- Now, click on the “Reset” button to remove VBA macro password
- Once the procedure gets completed, the software will display “Reset Process Completed Successfully”
Prominent Features of VBA Password Remover Tool
- The tool supports to recover VBA passwords from both single and multiple VBA files
- Allows to disable VBA macro passwords from Word, PowerPoint, Excel, and Access files
- Supports to recover passwords of any length
- Recovers passwords from different file extensions like .xlt, .accdb, .pptm, .doc, .xls, .docm, .potm, .xla etc.
- Software auto delete the old password and generates a new one
- Tool always generates a progress report
- Compatible with Windows OS and Microsoft Office
These are some of the best features of this VBA Password Remover Tool. You can use this software to remove VBA macro password. But, if want to try the manual methods then stay connected with this blog.
Manually Disable VBA Macro Password
We are going to discuss few manual methods to remove VBA macro passwords. But before starting with that, we will share some perquisites of the manual approach.
- Take a backup of all the VBA files because manual methods are not safe.
- We know that, .xlsm and .xlsx files are similar. But you still need to enable the macros to change the .xlsm file extension to .xlsx file format.
Let’s start with the process of manual methods.
Disable VBA Macro Password Using Hex Editor
Go through the steps given below to use Hex editor:-
- Firstly, install Hex Editor and create a new XLS document.
- Set password in the VBA field by tapping on “Alt + F11” keys together.
- Now, save the document and click on the “Exit” button.
- After this, re-open the new file and copy all the lines which are starting from CMG=…. / DPB=… / GC=…
- Here, paste all the copied lines into the VBA password-protected file from where you want to remove VBA macro password.
- Hit the “Exit” button and open any excel file in which you want to see the VBA code and enter the password you used in the previous step.
If this method doesn’t suit you, then you can jump to the next method.
Disable VBA Project Password using Workbook Method
- Open Workbook which contains all the password-protected files.
- Press the “F11+ Alt” keys to authenticate the protected sheets.
- Now, add “Insert-Module” and paste the code.
- Open the workbook from which you want to remove VBA password.
- At last, Type “Tools-Macro-Macros” and search for “Password breaker” and double click on it.
You can use this method to remove VBA macro password. But, If this method does not supports removing the VBA passwords. Then, you can opt for the next manual approach.
Disable VBA Project Password using WinZip/WinRar
- The first step is to change the .xlsm file format to .zip.
- Using WinZip/ WinRar, open the .zip file and choose the .xl folder.
- From the .xl folder, you need to extract the vbaproject.bin file.
Now, open the extracted file with the Hex Editor.
- Here, replace all the “DPB” files with the “DPX” files and then click on the “Save” button.
- After these, you need to replace the vbaproject.bin file with the recently saved file, under the .zip file.
- Now, again change the .zip format to .xlsm file extension.
- In MS Excel, open the VBA and click on the “Tools” option and choose “VBA Project Properties”.
- Click on the “Protection” button.
- At last, enter the new password and save the file in the .xlsm file extension.
- Finally, just re-open the file by using the new password.
These were the manual methods to disable VBA macro passwords.
In the above blog, we have discussed about the multiple techniques to disable VBA macro passwords. Users can use the manual as well as professional methods to remove VBA macro passwords. But if you want to go for the manual methods then you should be more careful because manual methods are not that safe and secure. So, we suggest users to use the professional VBA password remover tool.