• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Forget Worksheet Password

M

Mehmud Khan

Member
hello there,

Actually I forget the password of attached worksheet, can anyone un-protect this sheet if it is possible ?

Thanks & Regards!
Mehmud Khan
 

Attachments

  • Data.xls
    49.5 KB · Views: 19
Hello,
You need to download hex editor to break the password for workbook.
& follow below steps:
1. Backup the xls file
2. Using a HEX editor, locate the DPB=... part
3. Change the DPB=... string to DPx=...
4. Open the xls file in Excel
5. Open the VBA editor (ALT+F11)
6. the magic: Excel discovers an invalid key (DPx) and asks whether you want to continue loading the project (basically ignoring the protection)
7. You will be able to overwrite the password, so change it.
8. Save the xls file
9. Close and reopen the document and work.

To unlock for Worksheet use below code to break it:
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
    ThisWorkbook.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 ThisWorkbook.ProtectStructure = 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
 
Actually its little bit confusing!

Is there any option, wherein I would upload the protected file and after processing, when I download than the portal automatically download the unprotected file?

Thanks for your reply sir... :)
 
Yes! That file contains same data which you have mentioned.

Actually, right now I have an only single file, but if you tell me the way to unprotect then, that would be useful for future reference as well.

And one more thing, I can't install any application because it's not allowing me on companies PC.

Thanks for your interest in this.

Thanks & Regards!
Mehmud Khan
 
You can just google it for "free online password removal" & you can see many options but they are comes with some amount you need to pay to download your unprotected file.

If you follow this will be a free of cost but you need administrative permission to install Hex editor:
1. Backup the xls file
2. Using a HEX editor, locate the DPB=... part
3. Change the DPB=... string to DPx=...
4. Open the xls file in Excel
5. Open the VBA editor (ALT+F11)
6. the magic: Excel discovers an invalid key (DPx) and asks whether you want to continue loading the project (basically ignoring the protection)
7. You will be able to overwrite the password, so change it.
8. Save the xls file
9. Close and reopen the document and work.
 
Yup! I need administration permission to install any application, which is not possible.
And you told that Hex editor, I just google it...
Is it possible to unprotect the same by online Hex editor?

The below are the links, which provides online hex editing;

https://hexed.it/
https://www.onlinehexeditor.com/
https://hex-works.com/eng

But I am unable to understand how it works, could you please help me in this?

Thanks for the response in this...


Thanks & Best Regards!
Mehmud Khan
 
You must log in or register to reply here.
Back
Top