Tej Pratap Shukla | Published: 2020-05-08T05:46:30+00:00 | Recovery|
VBA Macro Password Removal in Excel 2007 (XLSX & XLSM File) This section provides different methods that can be utilized by users who have lost or forgotten the Visual Basic Application password from.xlsx &.xlsm files. The methods as how to crack VBA macro password in Excel. Use this free Excel Password Remover Add-In or VBA code with any Excel sheet to unlock your Excel sheet data. This Add-In can remove password if any of the excel sheet is protected by password. This will simply remove password and let you edit the sheet in Excel 2010, 2013, 2007 and 2003. Now, you will save the Excel files and, then exit to break VBA password in Excel; Open the Excel file where you wish to see the VBA code and next, use the common password that you have already used for dummy VBA file in the previous step; Using WinZip / WinRar. Change the file extension of.xlsm into.zip. Remove Password from VBA Project. For XLSM files: Open the XLSM file with 7-Zip (right click - 7-Zip - Open archive). Copy the xl/vbaProject.bas file out of the file (you can drag and drop from 7-Zip), don't close 7-Zip; Open the vbaProject.bas file with HexEdit; Search for 'DPB=' and replace it with 'DPx=' Save the file.
VBA (Visual Basic for Application) is a component of MS Office and used by Microsoft application such as Excel, Word, etc. It is a filename extension for visual basic file and also contains the visual basic code. This file can be used to add functionality to Office suite and automate routine tasks in Microsoft Excel. But, sometimes the user may forget or lost VBA password and now users try to crack that password. Therefore, in the upcoming section, we are going to discuss all possible ways to let users understand how to break VBA password in Excel 2016 without any difficulty.
Prerequisites Before Executing Manual Approach
- Initially, you have to take a complete backup of VBA files
- XLSM files are similar to XLSX files but you must enable the macros to make .xlsm files as .xlsx.
Manual Methods to Break VBA Password in Excel 2016 2013, 2010, 2007 or 2003
Go through the following workarounds that will help to crack the VBA password manually. Let us have a look:
Swap Password with Hex Editor
- Create the new Excel file (XLS) using any kind of Hex editor
- Then, you need to set a specific password in VBA field (Alt + F11)
- After that, you can save that file and press Exit
- Next, open a file which you have lately created with the help of the hex editor
- Copy each line starting with the given below keys:
CMG=….
DPB=…
GC=…
DPB=…
GC=…
- Using Hex Editor, you can open a file in which you want to break the password and paste these copied lines from a dummy file
- Now, you will save the Excel files and, then exit to break VBA password in Excel
- Open the Excel file where you wish to see the VBA code and next, use the common password that you have already used for dummy VBA file in the previous step
Excel Vba Password Crack
Using WinZip / WinRar
- Change the file extension of .xlsm into .zip
- Through the WinZip / WinRar, start the ZIP file and then, select the .xl folder
- Now, you extract the vbaProject.bin file and, then open that file in Hex Editor
- Search and replace the DPB with DPx and save that particular file
- Under the Zip file, you can replace the previous vbaProject.bin file with this latest one
- Again, you have to change the file extension from ZIP to XLSM file
- Start the Visual Basic in MS Excel, choose Tools and VBAProject Properties. Then, select Protection Tab and now, you can add a new password and save .xlsm file
- Close and re-open the VBA file with a new password.
Using Workbook
- First of all, you can open the workbook in which all protected sheets are available
- Press Alt+F11 to verify or open the Visual Basic Editor. Next, type Insert-Module and paste the following code into the right corner of the window
- Now, close VB Editor screen and navigate to the worksheet that you wish to unprotect
- Type the Tools-Macro-Macros and then double-click on the password breaker in the given list.
Professional Way to Break / Open VBA Password in Excel 2016
If the above-described methods do not work well then, users can take help of an automated solution. Out of which, one such application is the VBA Excel file Password Recovery tool. It is specially programmed to recover lost or forgotten password of VBA files without any data loss. It also supports different MS Office files like .xls, .xla, .doc, .mdb, .dot file type. The best part of this tool is that it eliminates old password and generate a new VBA Project password. It has an easy-to-use interface even a technical knowledge is not mandatory while using this tool. Here the complete working steps of the tool are listed below:
- Download and install Excel VBA Password Remover on your system
- Then, choose MS Office VBA Project file like Excel, PowerPoint, Word, etc. Click the Browse button to choose the VBA Project file
- Now, you can select the VBA project files and press Open
- Finally, VBA Password Remover will automatically show the new password
Let’s Wrap Up
There are many people who have lost or forgotten their VBA password. Therefore, in this blog, we have mentioned some methods through which users can break VBA password in Excel 2016 2013, 2010, 2007 or 2003. In case if the manual ways do provide precise results. Thus, we have suggested a trustworthy and instant solution, i.e., VBA Excel Password Recovery software. With the help of this utility, users can restore lost password in a trouble-free manner.
Leave a Reply
You must be logged in to post a comment.
If you are one of those users who are bound to handle a lot of data everyday whether you are at your office, at your shop, at your house, or elsewhere, better organization of collective data from various sources decide the resultant output of your effort, and this is where Microsoft Excel is required. It is one of the popular spreadsheet softwares which come along with the Microsoft Office suite.
Securing Excel files are equally important if you need to keep your personal and official data safe and sound. But most often it has been seen, users who set passwords for their excel files, forget excel password if not used in while. Mostly they dumb the file as an useless part of their collection and face a lot of troubles for losing hold of their protected contents within the files. But don't worry you don't need to do that ever again, for this article below would guide you on how to bypass a protected excel file if you have forgotten the password.
Method #1. Bypass Excel Spreadsheet Password by VBA Code
The best way to protect a worksheet is to put a password, so that if anyone opens the file then they will have to enter the correct password in order to gain access. But the real nightmare starts when you forget the password yourself. Fortunately, there are myriad ways to recover excel password and by using VBA code is one of them. VBA code usually helps to recover lost worksheet passwords effortlessly.
Step 1: Open the Excel file that needs to be unlocked, then press Alt + F11 to open VBA window.
Step 2: Choose the option that says Insert followed by Module.
Step 3: When the general window pops up that’s where you enter the VBA code.
Step 4: Click on 'Run' button (or press F5 key) to run it.
Step 5: Within few moments, the code will crack the password of the worksheet and you should be able to see a small message window with the password of the worksheet. You may write this down on a piece of paper and use it to unlock your worksheet.
See, how easy it is to crack worksheets?
NOTE: Remember, this method only works with single sheets. If you have multiple worksheets that needs to be unlocked then you will have to run this code over and over again by opening each and every sheet manually.
Method #2: Crack Excel Password with iSeePassword Dr.Excel
Are you done with banging your head with pointless methods and utility methods? Then this method would be very useful to you in case immediacy. iSeePassword Excel Password Recovery Tool, which can easily bypass your excel password without losing or corrupting original data. The program will not directly crack, bypass a Excel edit/modify restriction password, instead, it uses a brute force recovery, mask attack and dictionary attack to crack your Excel password without touching anything in your internal data. It has served countless clients thus it clearly reflects the goodwill of the tool in terms of market value. In order to know the working of the tool, read the tool's specifications first to get a clearer idea of it.
Top Features of iSeePassword Excel Password Recovery
- Provides 4 types of attacks- Brute-Force Attack; Mass Attack; Dictionary Attack; Smart Attack.
- Batch remove the Worksheet/Workbook protection
- Multi-core CPU and GPU provisions are available to increase the recovery speed.
- Compatible with the latest version of MS Excel including 2016/2013/2010/2007/2003.
- No file content is lost. It runs with all the Windows OS, such as XP/ Vista/ 7/ 8/ 10.
You can directly download it here, only Windows version available!
Step 1 Install and Run Excel Password Remover Tool and Add File
First of all, download the program file and then install it accurately in any one of your working computer. From the tool's main window, choose the first option 'Recover Open Pasword from Excel'.
Step 2 Add Excel File
Click on 'Add File' button in the menu bar, and then browse to load the password protected Excel file into the program from the directory.
Step 3 Select the Right Attack Types and Set the Attack Parameter
This program comes with 3 powerful password recovery algorithms. Each algorithm corresponds to an attack type. There are Brute-Force Attack, Mask Attack, Dictionary Attack. It's more a personal choice to choose the attack type, which it's highly dependent on your existing memory of the password.
For example, if you can provide any part of password information like password length, range, lowercase and uppercase letters, numerals, and special characters, then the program will find your password very fast. So You should select the right one according to your own situation.
Step 4 Star Bypassing Password from Microsoft Excel File
Eventually click on 'Start' button to start the process of password recovery. The entire time is largely depend on how complex the password it is and which attack type you selected. After the process ends, the cracked or recovered password is displayed on the screen in a small dialogue box.
![How To Crack A Excel Vba Password Remover How To Crack A Excel Vba Password Remover](https://www.wikihow.com/images/thumb/a/a7/Set%2C-Reset%2C-Remove-and-Recover-the-Password-of-Excel-Files-Step-11.jpg/aid5058906-v4-728px-Set%2C-Reset%2C-Remove-and-Recover-the-Password-of-Excel-Files-Step-11.jpg)
Another Core Function in Dr.Excel You should Not Miss: Remove Worksheet/Workbook Protection
In every edition of Excel, you should notice that Microsoft give you ability to set a password protection for Workbook/Worksheet, the goal is to protect your sheet/book from unauthorized opening, modifying or changing. If the Excel sheet/workbook is protected, then you will find it is therefore read-only and cannot edit. If you forgot the worksheet or workbook password, you also can't change anything for it unless you unprotect Excel first. Luckily! Dr.PDF can do a great job for you to remove these protection without losing data.
Step 1. Download and install Dr.PDF on your computer, run it and select the second option and next.
Step 2. Now you need to click 'Add File' button and navigate to the target Excel worksheet/workbook files. If the file is protected by password, you can see it will be marked with a lock icon.
Then click Start button and you will see all the password was removed at once, including the sheet protection password, workbook protection password, and read-only password.
The aforementioned methods in the article are all effective in removing your excel password, but if you are looking for a guaranteed output, then you must rely on the third method iSeePassword Excel Password Recovery Tool for a better result. They are not that difficult to work with, in fact they are laid out in such a simpler manner than even a novice can pull it over at one go.
Method #3: Crack Excel Password with Excel Password Crack Tool
Excel password Remover is a freeware program that can be utilized to open any password protected files without the need of any password in real. The approach is very simple so even a beginner with computers can deal with it easily without any hardships. The steps for the method are exemplified below:
Step 1. Firstly download the program file from the internet and install it properly in your working computer.
Step 2. Now open the program with admin privileges. You will be asked either to disable or enable the macros configured with the add-ins. Simply choose to enable it to continue with the program.
Step 3. Click on 'Open' to load the protected excel file into the software.
Step 4. Once the file is loaded into the program, click on 'Remove Password' button to start the password removal process. It will take some time depending upon the complexity of the password. Once the procedure is finished, you can now easily open up your excel file without any password prompting.
Cons:
- Only compatible to bypass password for Excel 2010 or earlier workbook or sheets only.
- It wonly works on Excel (*.xls) file; cannot crack excel files with extension .xlsx.
Mar.09, 2018 18:54 pm / Posted by Vicky Tiffany to Office Topic