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 xls file, so, if you have an Excel xlsm file you can simply save it in the previous format. Excel 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.
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. In some cases, this entry will be bytes, and in others it will be bytes. Save my name, email, and website in this browser for the next time I comment. Currently you have JavaScript disabled. Note 2 — In this method HxD — Freeware Hex Editor, a simple disk editor software application has been used to break-in into the password.
Note 2 — In this method XVI32 Hex Editor , a simple disk editor software application has been used for cracking the password. Undoubtedly, all the three above described free manual methods can be utilized to crack VBA project password in Excel worksheet. Therefore, to achieve cent percent outcome any external tool is indeed essential to be brought in use. Although several professional utilities are available, the one which can be relied upon is VBA Password Remover.
This tool is compatible with Excel and above on a Windows computer, as well as Excel and higher on a Mac. It takes only two actions to remove a macro password in Excel. Step 1. Step 2. This program will crack VBA passwords in Excel workbooks easily without any technical knowledge required.
Free Download. Step 3. Step 4. In order to reset or remove a password from an Excel workbook using Hex Editor, we first need to back up the file that has been protected by VBA password. After you have backed up the file, follow these steps:. Now save and close your file on the hex editor. Overwrite the old VBAProject. Step 6: Revert the file extension to. From the pop-up warning window, select "Yes" and ignore the other options. Step 8: Right-click on the name of your VBA project then choose properties.
Choose the "Protection" tab and get rid of the existing passwords. Also, disable the "Lock Project for viewing" box and enable it again. Enter a suitable password and confirm it.
Click "OK" to effect the changes. Hex Editor provides you with a good platform to edit hexadecimal goods and finally crack an Excel VBA password. In this method, you will create a dummy xls file, set a password, and use it to access the protected Excel. Step 1: Use the Hex editor to create a new Excel file xls. Just a simple file can do. Step 2: Create a password for this file under the VBA section. Step 4: Open this newly created file, but this time round, open it via the hex editor.
Step 5: Now open the excel file that you wanted to decrypt the password using Hex editor. Paste the copied texts into respective fields and save the changes. Exit the file. Step 6: Normally open the Excel file and use the very same password you created for the dummy xls file to see the VBA code.
0コメント