How to Remove XLSM VBA Password in Multiple Ways?
Are you also looking for a solution to remove XLSM VBA password? Do you want to reset the password of the .xlsm file? If yes, then explore this blog, and find out the best solution to remove password from XLSM file. We will mention different techniques to fix this issue easily.
VBA (Visual Basic for Applications) is part of MS Office and is used by Microsoft programs such as Excel and Word. VBA password helps protect your important files from unauthorized access. However, users may face situations where the VBA password is inaccessible or lost and the user tries to crack or recover the password. So, in the next section, we will introduce his VBA password cleaners in different ways.
Table of Content
Automatic Way to Remove XLSM VBA Password
VBA Password Remover is one such program. It is designed to recover lost or forgotten VBA file passwords without data loss. It also supports MS Office file types such as .xls and .xlsx. The best feature of this XLSM password remover is that it can remove old passwords and replace them with new VBA project passwords. It has a user-friendly interface, its use does not require technical knowledge.
The program has amazing features that manual methods cannot provide, for example, the tool supports all MS Office Excel files (xls, .xlt, .xlsb, .xlsm, .xltm, .xlam, etc.). Users can easily disable VBA macro password at the same time. These amazing features are mentioned below:
- Allows users to remove passwords from both single and multiple VBA files.
- Users can reset passwords of any specified length.
- The tool supports resetting multilingual VBA project password.
- The software automatically deleted the old password and generates a new one.
- It is compatible with MS Office and Windows OS.
- Allows removing VBA passwords from .ppsm,.doc,.xla,.mdb,.potm,.dot, etc.
- Supports resetting a password from Macros formats like .dotm, .xltm, .xlsb, .docm, etc.
- The tool also generates a progress report.
These are some of the advanced features of the automated tool. You can easily use this tool to solve this Excel VBA password not working issue. But, if you want to try a manual method, then follow this blog. We will mention the manual solution in the next section.
Easy Guide to Remove Password from XLSM File
Go Through the Steps given below to Know the Solutions:-
- Download and run the software.
- Use the Add Files/Folder option to upload XLSM file.
- The software will list the password protected XLMS File.
- Now, click on the Reset button to Unlock XLSM file.
- The Reset Process Completed Click OK to finish.
Method 2:- Manual Solution to Remove XLSM VBA Password
We are going to discuss 3 different manual methods in this section. So, Before starting with the manual method, let’s take a look at the prerequisites of the manual approach.
Prerequisites of Manual Method
- You need to take a backup of all the VBA files
- XLSM and XLSX files are similar but you still need to enable the macros to make the .xlsm files as .xlsx
Unlock XLSM VBA Project Password using Hex Editor
- Open Hex Editor and create a new XLS file.
- You need to set a password in the VBA field by pressing the “Alt + F11” keys together.
- Save the file and click on exit.
- Now, open the file which you have created recently.
- Here, copy every line starting with:-
CMG=….
DPB=…
GC=… - After copying the lines, open password protected Access Database ACCDB/ MDB files to break the VBA password in Excel 2007 then paste these lines into that file.
- After doing the above steps, save the file and click on “Exit”
- At last, open the Excel file where you want to see the VBA code and enter the password which is used in the previous step.
You can jump to the next method if you don’t have Hex editor on your system.
Remove XLSM Password in Excel via Workbook
- Firstly, you need to open the Workbook all the password-protected sheets are saved.
- Tap on the “Alt + F11” keys together to verify all the sheets.
- Now, type Insert-Module and simply paste the code.
- After that, exit from the VB Editor and go to the workbook from which you want to remove the VBA password
- At last, just type the “Tools-Macro-Macros” and double-click on the password breaker.
These are the steps of the Workbook method to remove the XLSM VBA password. You can use this method to reset your VBA password. But, if in case, this method doesn’t work then you can use the next process.
Remove XLSM VBA Password using WinZip/WinRar
- The very first step is to change the file extension from .xlsm to .zip format.
- Open the .zip file using WinZip/WinRar, and choose the .xl folder.
- Now, from the .xl folder, extract the vbaProject.bin file and open it using Hex editor.
- You need to navigate the DPB file and then replace it with the DPX file
- After replacing the files, save that specific file.
- Now, replace the vbaProject.bin file with the recently saved file, under the .zip file.
- Here, change the file format from .zip to .xlsm file format.
- Open Visual Basic in MS Excel and click on the “Tools” option.
- You need to select the “VBA Project Properties” and click on the “Protection” option.
- After performing these steps, enter a new password and save the file in .xlsm file format.
- Finally, you just need to exit the file and re-open it by entering the new password.
These are the manual methods using which you can Remove the XLSM VBA password.
Summing Up
In the above blog, we have mentioned the different techniques to remove XLSM VBA password. You can use both professional as well as manual methods. But, if you are a non-technical user then this method will be a bit confusing, tricky, and time-consuming for you. So, we will suggest you use the above-mentioned Tool to remove the XLSM VBA project password.