How to unprotect an Excel sheet if password is unknown

If an Excel spreadsheet is password protected, we are unable to edit the data in the sheet. If you do not remember the password or if you don't know the password to unprotect the excel sheet then just follow this process for unlocking the excel sheet.

Step 1: 

Open the Excel sheet

Step 2:

Press Alt + F11 or click on view code on the developers tool

Then you would be seeing a sheet like this

Step 3:

In the above white space, just enter the code as shown below(Just Copy paste)

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

Step 4:

Now Click on F5 to run the code

and there youo get the unprotected excel sheet.
Now you get a message containing the password which can be ignored.

Do visit my blog for further updates.......

Back to MS Excel>>