I want to know how to crack a password of VBA project in Excel. Who can help?
Before you even lookup for methods to crack the VBA password in Excel, you need to understand the meaning of VBA. VBA is an acronym for Visual Basic for Application. It is used by various MS applications, especially MS Excel, to add some functions and also to assist in automating routine tasks. Due to its nature and need for file security, most users encrypt VBA prohects with passwords. However, humans are not flawless, and VBA passwords can be forgotten. The obvious implication is that you cannot access your Excel VBA codes or edit them. To beat this mayhem, you need a way to crack an Excel VBA password. Fortunately, there are plenty of ways to perform this task. In this article, you shall receive a detailed guide on the top 4 methods to crack Excel VBA passwords.
Part 1: How to Crack Excel VBA Password Manually (3 Methods)
Part 2: Limitations of Manual Methods
Part 3: How to Crack Excel VBA Password Automatically (Easy Method)
Part 1: How to Crack Excel VBA Password Manually
Cracking Excel VBA password can be performed with the help of automatic VBA crack software or via manual means. Digging into how to crack the Excel VBA password manually, there are several good ways capable of doing the job. You can choose from these options and try with your protected Excel file. Eventually, one of these options could prove better, depending on the nature of your protected document and the need at hand. Before leveraging these manual methods, you must take a backup of your Excel files.
Method 1. Change File Extension to Crack Excel VBA Password
Method 2. Crack Excel VBA Project Password with Hex Editor
Method 3. Crack Excel Macro Password with Visual Basic Editor
Method 1. Change File Extension to Crack Excel VBA Password
This method involves changing the .xlsm file extension into another format then reverting it into. xlsm format afterward. Although the process is lengthy, you can follow it keenly to crack your excel VBA password eventually. The following steps illustrate how you can crack the Excel VBA project password by simply changing the file extension.
Step 1: Locate your target .xlsm file and change the file extension from. xlsm to .zip.
Step 2: Now open this file via any of the Archiver programs that you have. You can use WinRAR or 7-Zip. If you do so, you should be able to see the following structure of your file directory.
Step 3: Navigate into the XL directory option and extract the file labeled "VBAProject.bin".
Step 4: Open the VBAProject.bin file via any hex editor and query the "DPB=" text within the file in the hex editor.
Step 5: Once you locate this text, simply delete and replace it with "DPX=" instead. Now save and close your file on the hex editor. Overwrite the old VBAProject.bin with the new hex-edited VBAProject.bin.
Step 6: Revert the file extension to .xlsm then open it in Excel. From the pop-up warning window, select "Yes" and ignore the other options.
Step 7: Run the VBA editor and choose "OK" if the dialog box pops up.
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.
Method 2. Crack Excel VBA Project Password with Hex Editor
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. You can press Alt+F11 to access this option.
Step 3: After you have created a memorable password, save this new file and exit.
Step 4: Open this newly created file, but this time round, open it via the hex editor. Once opened, locate and copy the lines, which begin with the following keys: CMG=, DPB=, and GC=.
CMG="9C9E30D6507654765472587258"
DPB="383A94FBB1FBB1044FFCB11EE8D969D47E2836B34BEECE54EA9E1B3B01082DDB0BA7FB1D"
GC="D4D6781E88BB89BB89BB"
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.
Method 3. Crack Excel Macro Password with Visual Basic Editor
Unlike the Hex editor, Visual Basic Editor allows users to edit character codes as opposed to hexadecimal. The process is not so lengthy. However, you need to be keen because codes require attention to avoid mess-ups. The following steps clearly illustrate how you can crack an excel Macro password with Visual Basic Editor.
Step 1: Manually open the respective workbook housing the protected excel sheet.
Step 2: Now open the Visual Basic Editor via the Alt+F11 command. Go into the Insert-Module then paste the following code into the code window available on the right hand.
Sub PasswordBreaker()
'Breaks worksheet password protection.
Dim i As Integer, j As Integer, k As Integer
Dim l As Integer, m As Integer, n As Integer
Dim i1 As Integer, i2 As Integer, i3 As Integer
Dim i4 As Integer, i5 As Integer, i6 As Integer
On Error Resume Next
For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
If ActiveSheet.ProtectContents = False Then
MsgBox "One usable password is " & Chr(i) & Chr(j) & _
Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
Activeworkbook.Sheet(l).Select
Range("al).FormulaR1C1 = Chr(i) & Chr(j) & _
Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
Exit Sub
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
End Sub
Step 3: Exit the VBA Editor window and proceed to the protected worksheet.
Step 4: Go to Tools>Macro>Macros. From the displayed list, double-click on the "PasswordBreaker" option. You should now be able to access your password-protected Excel file.
Part 2: Limitations of Manual Methods
Although manual methods are useful in cracking Excel VBA passwords, they are not close to perfect. These methods are plagued by multiple problems that make them not fit when dealing with important and complicated Excel files. The following are some of the common limitations of manual methods.
Require technical knowledge: As you have seen, most options above involves a lot of codes. So if you have the poor technical knowledge, be certain to ride it rough with these manual options.
Time-consuming: Plenty of manual methods involves lengthy processes. The fact that it also involves codes and movement across multiple platforms makes it more tiresome, and thus, users will find it time-consuming and tiresome.
Success rate: What matters, in the end, is whether we can crack the Excel VBA password or not. Unfortunately, these manual options register the lowest success rates. Therefore, it is not wise to spend much time and energy then fail to get the result you needed.
With that said, if all the options fail or get fed up with their shortcomings, later try to use special applications like Passper for Excel to crack Excel VBA password automatically.
Part 3: How to Crack Excel VBA Password Automatically
Passper for Excel is an incredibly powerful password unlocker tool for Excel files. This program has the highest success rate in the market for cracking Excel VBA project passwords.. With the super-fast cracking speed and ease of use, there is no reason to doubt the ability of Passper for Excel. It is also important to note that Passper for Excel can be used to crack document opening password for Excel files.
Main features of Passper for Excel:
All editing and formatting restrictions on your VBA project, worksheet or workbook can be cracked instantly.
With Passper for Excel, 1 simple click will enable you to get rid of password protection on your VBA project.
Your data won't be affected or damaged after using the program.
The program has a very broad compatibility. All Excel file types including .xlsm, .xlsb, .xltx, .xltm are supported by it.
Passper for Excel has served millions of users all over the world. And it has received positive reviews from its users. Don't hesitate to try it now.
How to Crack Excel VBA Password with Passper for Excel
Step 1 Run Passper for Excel on your PC and click the "Remove Restrictions" option.
Step 2 On the new window, click on the "Select a File" button and follow the on-screen instructions to upload the Excel VBA password protected file into the program's interface.
Step 3 When the password-protected file is uploaded, hit the "Remove" option to get rid of the VBA project password on your Excel file.
The program will automatically get rid of restrictions in a matter of seconds. When it is complete, you should see the success notification on the screen background.
Conclusion
This guide has elaborated with clarity some of the plausible methods to crack Excel VBA passwords. However, some ways are more superior to others due to their ability to handle complex VBA passwords, ease of use, and success rates posted. From the wealth of information given above, no one can dispute Passper for Excel as the real solution to crack Excel VBA project password. All measurement parameters put it levels ahead of manual options. Choose Passper for Excel and fix your VBA password issues for good.
link: https://passper.imyfone.com/excel/crack-excel-vba-password/