How to unblock Excel worksheet password protection
Excel pops up "The cell or chart you are trying to change is protected and is therefore read-only." To modify a protected cell or chart, first use the Unprotect Sheet command (in the Change group on the Review tab) to unprotect. You may be prompted to enter a password.
What should be done to solve this problem? After research, two ways to solve the Excel worksheet protection code are found.
One, VBA macro code crack method:
First step: Open the file
The second step: Press ALT+F11, enter the VBA editing interface;
Step three: Insert a module;
Fourth step: On the right module's blank editing area, copy and paste all the following content;
Fifth step: Press F5 to run the VBA command;
Sub Password ()
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 = 66:for j = 66:for k = 66
For L = 66:for m = 66:for I1 = 66
For i2 = 66:for i3 = 66:for I4 = 66
For i5 = 66:for I6 = All to 66:for n = 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:Next:Next
Next:Next:Next:Next:Next:Next
End Sub
Sixth step: Toggle the Review tab, tap Unprotect Sheet, and then enter the password to unlock it.
Second, the software crack method
There are a lot of software specifically designed to break Excel's various passwords, Excel key and Advanced Office Password recovery are among the best. They are simple to use and are extremely fast to crack.
1. Excel Key
Download (: http://www.mydown.com/soft/183/183131.html) run the software after installation, click on the toolbar "Recovery" button to find the file to be cracked, the software will be able to solve the password immediately (Figure 5).
2. Advanced Office Password Recovery
Download (: http://www.mydown.com/soft/utilitie/security/268/410768.shtml) run the software after installation, click the toolbar "open File" button to open the Excel file to hack, You'll be able to see the code you solved right away (Figure 6).
As you can see, the passwords that you read in these ways are completely different, but they do all remove the password protection from the worksheet, which is an interesting question.
Search on the internet for a long time, and finally found a more satisfactory explanation of the answer:
When the Excel worksheet is password protected, a 16-bit (double-byte) long hash value is generated. When the password is entered for verification, the real comparison is the hash value. In fact, there are many different passwords that can generate the same hash value.
Everyone can try:
When you use "test" (without double quotation marks) as an Excel worksheet to protect your password, you can also use "Zzyw" (also without double quotes) to unlock the password. What's Up, magic?
Excel worksheet protection Password cracking method
