Crack The Excel Sheet Password | Excel Hotshot

So what will you do if you lost the password to unprotect an excel worksheet, do you think there is any way to Crack The Excel Sheet Password?

In that case, a worksheet where you can't edit the information you can attempt the following tricks to unprotect your worksheet.

 

Step 1 Press ALT +  F11 or click View Code on the Developers Tab

 

Step 2 Double click on the worksheet that is password protected.

Step 3 Copy and paste the code below into the (Code) window. Do not change any of the code, just copy and paste it to Crack The Excel Sheet Password.

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)
Exit Sub
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
End Sub

Step 4 Click on the Run Button or press F5.

And there you have it.

 

If this method worked and was able to unprotect your worksheet you’ll a small pop-up window saying “One usable password is ***********”.