[TUT]How to Remove Protected Excel Sheet Password

[sruxan]

for sharing sir.. for future use..

 

[chanay]

Kung repost na po to paki delete na lang po.

Follow this Step Carefully.

Note: Applicable to any version of MS Office. What I am using in this demonstration is MS Office 2010.

1. Open the Password Protected Excel Sheet.
2. Press Alt+F11. A MS Visual Basic Interface will popup.
3. Do as what the image shows

View attachment 388291​

4. Paste this code:

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

and will look like this

View attachment 388292​

5. Close the MS Visual Basic Interface and return to the protected excel sheet.

6. Go to view>macros (it may differ with other version of MS Office).Follow the steps in the image as shown.

View attachment 388293​

7. Then a window will popup and will look like this.

View attachment 388294​

8. After running the code please wait until it finishes its routine. It may take a minute or two depending on the speed of your system.

9. If you see the messagebox as shown below then you're successful.

View attachment 388295​

10. Then "Save As" it in a different filename.

I hope you'll find this tutorial helpful.

maraming salamat dito t.s tagal ko na tong hanap eh

 

[drake01]

working.salamat nang marami.

 

[automenu]

pa bookmark nito.,, salamat ts, for future use

 

[quatre76]

Maraming Salamat sir.

 

[Unknown Post]

wow salamat po at pa subscribe narin

 

[turbojackhammer]

ang husay mo TS galing bravoooo

 

[Craven16]

tnx po dito, keep sharing . .

 

[ziuretnad]

PA BM AKO ts salamat po

 

[zechsmerquise]

BM muna baka mapakinabangan later

 

[kurapikot]

help po. Someone open my excel password protected sheet. Inalis po password tpos ginulo yung file. pano nmn po isecure pagganun. Thanks..

 

[kadz_amr]

- - - Updated - - -

help po. Someone open my excel password protected sheet. Inalis po password tpos ginulo yung file. pano nmn po isecure pagganun. Thanks..

iPassword protect nyo na po yung excel file mismo. Kasi itong tute na to para lang sa protected sheets and I don't know any way of breaking a protected excel file.
But you can still do protect a sheet that would take a very very long time to crack by making the password more than 30 characters mixed with special characters.
it would take them ages for the code to break the password.

Good luck!

 

[kriz_0021]

idol maraming salamat!!!

 

[Gelougee]

Thanks for this.. big help!

 

[nickiera]

Big thanks bro. Galing nito.

 

[maxxzzz]

thank youTs
For the Future Use if Ever!

 

[rmnice18]

pa bookmarked for future reference.

 

[freemantle]

TS ayaw gumana ung alt+f11 sa ms office 2010 pg nka open na excel workbook na may pass

 

[richarddeo_fondevilla]

Thanks po....

 

[kadz_amr]

TS ayaw gumana ung alt+f11 sa ms office 2010 pg nka open na excel workbook na may pass

With that i don't know what's the problem. Basta kailangan mo yung interface para makagawa ka nang macro. Better check the setting of your office allowing macros or baka may problema ang installation nang office mo. So far hindi pa ako nakaranas nang problemang gaya nyan unless otherwise naka password protect na ang file na wala katalagang maaccess kundi password box lang.

Good luck and i hope you'll find a solution for that.