Sunday, July 15, 2018

[SOLVED] HOW TO OPEN PASSWORD PROTECTED EXCEL FILES

A ZERO MINUTE TECHNIQUE TO OPEN PASSWORD PROTECTED MICROSOFT EXCEL AND WORD FILES WITHOUT THE PASSWORD.

Are you an office worker who receives a lot of business emails with some of them password protected? Have you ever wondered about opening a password-protected Microsoft Excel/ Word sheet without asking the password from the owner of the sheet? Is it only the subject of software engineers or people with outstanding knowledge of computer skills? Well, the answer to the above question is not a brainy anymore and it is going to be uncovered in the paragraphs.
Firstly, what do you mean by the protection of a sheet? Most of the people know what is the need of protecting a sheet with strong password especially when it comes to confidential matters such as tendering or proposal. Here, I am going to write about unprotecting the sheet without any password that too within half a second.

Step1: Open the password protected sheet.
Step2: Press ALT + F11.

Step3: Microsoft visual basic for application tab will be opened by now. From the left side select the sheet you want to unprotect. Double click on the project file and a new window will be open. In the newly opened window please copy then paste the following code.

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


Step4: Press F5.

Your page is now unprotected if it is not then a new password will be shown to you.

Thanks,
Josy.