1.4 Crack Password Protected Excel File with VBA Code. This method involves the use of Visual Basic scripting language to bypass the Excel password checking mechanisms and crack the Excel password. Ideally, we are fooling the program via a VBA code to allow us to edit it. Unviewable password protected vba project Unviewable password protected VBA projects are less secure than the equivalent locked projects, as recovery information has to be maintained within the file. Unviewable password protected projects can be made visible and re-locked, if required. I recently needed to unlock an Access VBA Project for which my client had lost the password. I was surprised to find that there was an incredibly simple hack that can unlock any Access password protected VBA project and I figured I’d share in case it could help others. Make a copy of the database in question and only work with the copy.
In every company there is someone that creates Excel files with VBA macros and that wants to protect his work. There is no documentation and none knows the password. What we can do? We can crack the password! On the web we can find a lot of software for free which do that but they have limitations and you have to pay to crack longer passwords, but we can crack a VBA password editing the file using an hex editor. This method can be applied to an Excel 2003 (xls) file, so, if you have an Excel 2007 (xlsm) file you can simply save it in the previous format. Excel 2003 manage the VBA password simply comparing strings, so one method is simply to swap out the password entry in the file using a hex editor (In the following example I used HxD – Freeware Hex Editor and Disk Editor).
Backup you file making a copy
Create a new simple Excel file
In the VBA part (ALT + F11), set a simple password (for example 123).
Save the file and exit
Open the file you just created with the hex editor.
Copy the lines starting with the following keys: CMG=…. DPB=… GC=…
Open the file you want to crack with your hex editor and paste the above copied lines from the dummy file
Save the excel file and exit
Now, open the excel file you need to see the VBA code in. The password for the VBA code will simply be 123.
Password Protected Vba Project
The described method worked well for me a lot of time, but, if you try to paste the wrong number of bytes into the file, you will lose your VBA project when you try to open the file with Excel. Unfortunately there are instances (I haven’t figured out the cause yet) where the total length of the “CMG=……..GC=….” entry in the file is different from one excel file to the next. In some cases, this entry will be 137 bytes, and in others it will be 143 bytes. The 137 byte length is the odd one, and if this happens when you create your file with the ‘123’ password, just create another file, and it should jump to the 143 byte length.
List of Key Features in SysTools VBA Password Recovery
Comprehensive tool to recover lost or forgotton VBA Project Password From Word, Excel, Access
Removal of Forgotten VBA Password
Using the VBA password recovery software users can successfully remove lost password of the VBA files and projects. If you have forgotten your VBA Excel password or if you want to access any other password protected VBA file (like doc, xls, dot, xla, msb) then, this VBA word password breaker is one of the best tool.
Automatic New Password Generation
Removal of the lost VBA file password automatically generates a new password under the software. Thus, VBA Password Remover tool not only allows you to remove the password from VBA file but also generates a new password. This tool works like VBA password generator after removing VBA macro password.
Password of Any Length Recovered
The SysTools VBA password unlocker tool designed with advanced techniques to generate code or crack VBA Project password of any length in an eased manner. Any password that is composed of multiple combinations and is very long is effortlessly recoverable.
Any VBA File Password Recovery
Be it MS Word or MS Excel file, VBA Password Remover software can reset the password from the source code of any file. These files used by the VBA application to create projects may include; .doc, .xls, .xla etc. The program will help to remove errors such as : how to remove VBA password in Excel, Access or Word VBA file.
Multilingual VBA Password Recovery
Users can even recover multilingual source code passwords of VBA project i.e. the passwords made up of alphabets and symbols as well. If you have composed a password with the combination of numbers, alphabets, and special characters and is quite lengthy, then also password removal is possible.
Remove VBA macro Password
VBA password unlocker software removes password protection from visual basic macros. This tool is capable to remove VBA macros password from Excel, Word & Access file (doc, dot, xla, xls, mbd). It will perform recovery of old forgotten password & apply a new password. After removing the old password by using the tool you can execute & edit the VBA code. This is the best tool to recover access, excel, word VBA macro password.
Show Complete Recovery Details
Crack Vba Project Password
Once you browse a VBA file and recover the password then, the VBA word password generator software will show complete recovery details of the same. This detail includes complete procedure followed by the tool to reset VBA Project password and set a new password.