Today's test is true and effective.
Today, I downloaded an Excel2003 document. I am very interested in some functions, but I am depressed that the document is encrypted and all functions are set to read-only attributes! Click "undo worksheet" in the Excel menu, prompting you to enter the password! In the past, I searched for a VBA macro Cracking Method on the Internet, and it was a success! There are really many cool people! I have to admire it. Let's talk about this method below.
1. Click "macro"> "macro". A window is displayed. In "macro name", define a name: PasswordBreaker, click "CREATE", close the pop-up window, and exit;
2. click "macro"> "macro", select "PasswordBreaker" under "macro name", and click "edit" to open the "Microsoft Visual Basic" editor, replace all the code in the right window with the following:
Sub PasswordBreaker ()
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. Sheets (1). Select
Range ("a1"). 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
End Sub
3. click "macro"> "macro", select "PasswordBreaker" under "macro name", and click "execute". The password is displayed. A dialog window is displayed, tell you a password that can be used. Haha, good guy.
I heard that the password protection is not required to be revoked when it is opened in Excel2007. You can just do it! There is no menu for "undo worksheet protection. I have never tried this ..
20130524. Today, an important task is to crack an excel Workbook shared on a LAN. I tried one by one using my previous learning methods. Anxious... I found an easy-to-use cracked file advancedofficepasswordrecovery_hhw2013ok.exe and used it as follows:
1. the excel Workbook shared on the LAN can be edited by multiple users at the same time. As soon as you edit the file, the pop-up box "the file is locked. Please try again later" appears ". I restarted the server where the file is located.
2. check whether a fault occurs when editing the file, causing the thread to shrink. Do not edit... However, considering that the phenomenon is not similar, the file prompt will be "to xx users to edit/describe. Therefore, this direction is denied.
3. This method is used to create a macro In the workbook and crack the password. However, when creating a macro, it is told that the new recording macro cannot be saved in the current workbook (because the workbook is shared ), to remove the workbook protection, you need a password. This conflict cannot be solved.
4. After consideration, the best policy is to remove the workbook protection and crack the password. Therefore, use AdvancedOfficePasswordRecovery to open the file and obtain the password. Then, the dialog box contains an "open" button (the file path is ready, so ignore it ). The key point is coming. If your tool-Protect-Undo the workbook protection, enter the password, and the tragedy, this will not work. Because the dialog box "the file is locked, please try again" is still displayed. At this time, you need to first save the opened file as a file named aa. Then, close all and open the aa file again. It is shared. You are in the tool-Protect-Undo the workbook protection, enter the password, OK, at this time, you will be delighted to find that the word "share" is gone. You have succeeded. If you want to protect your workbook, you can use the tool-Protect-to protect the shared workbook, check the Revision Method, and enter the password to protect your workbook.
The problem is solved here. Upload the cracked file, which is easy to use. Password for ms files.