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 multiple ways to remove VBA macro passwords? If yes, then follow this write-up. Here in this blog, we are going to discuss 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
This VBA Password Remover Tool 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 tool 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 Tool
- The tool supports to remove XLSM VBA password from both single and multiple VBA files
- Allows to disable VBA macro passwords from Word, PowerPoint, Excel, and Access files
- Supports recovering passwords of any length
- Recovers passwords from different file extensions like .xlt, .accdb, .pptm, .doc, .xls, .docm, .potm, .xla etc.
- Software auto deletes 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 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 a 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 the .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 the password in the VBA field by tapping on the “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 break the VBA password in Excel.
- At last, Type “Tools-Macro-Macros” 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 the .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 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 use the professional tool mentioned above.