How to remove an excel password without knowing it

This video shows how to remove an excel protected sheet without even having knowledge about the password.

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)
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

---
Good luck!

Category:

Education

Tags:

• excel
• password
• delete
• remove
• fun

[patanwalahussain]

Hi I got an excel file which has some vba code but i do not have password. I want to make small modifications in the code. I pressed alt + f11 but there is a vba password protection how do i remove it

[dualbreathe]

@patanwalahussain you can't.. once it's locked from that your excel would be locked. im sorry. i can't help you there.

[hpxz]

not clear

[dualbreathe]

@hpxz look at my other video for 2007

[73davie]

Hi there,doesnt show up in 'macro name' (though name is visible in the drop down box below...im using excel 2007) so unable to run it ...any suggestions

thanks in advance

[dualbreathe]

/watch?v=MGZjRwpSjUQ

Use that if your using excel 2007

[Conutant]

Thank you! I appreciate it!

[StarRock2012]

Thanx works

[kirkster515]

That code's overcomplicated, I did it in about 5 lines, and it was much simpler. Check out my vid. The point is, the excel sheet is locked against an algorithm to which certain combinations of random letters and numbers will eventually unlock it. My solution was to do exactly that, I tried different random numbers and letters combinations to find the fastest way as well. So I haven't seen a better way than in my vid.

[TheCrazykid1990]

Thanks man, you are a genius. God Bless You :D

[castratedcat]

For people like me who don't know what they're doing like me:

1. Go to mcgimpsey .co m / excel/ removepwords. html

2. Download "allinternalpasswords.xls" located on above page

3. Open workbook (it will be blank with no cells, this is ok). Go to add-in's tab and click"Remove passwords" (this wont work at first but this is ok)

4. Make sure all macros are enabled (google it)

5. Open protected workbook - go to "Add-Ins" tab on ribbon - click "Remove passwords"

6. Next etc

Hope this helps

[TheGpmd]

Thank You, Merci Beaucoup, 留言.Great Work, Finally I will be able to modify the workbook

[maudj007]

WOW, that's works!!! Thanks.

[jamiebull1]

@patanwalahussain Use a hex editor, search for DPB and replace with DPx. Save and reopen in Excel with no VBA project password.