Provider

Tuesday, July 17, 2012

How to Unprotect an excel sheet without password


How to Unprotect an excel sheet without password
Unprotect Password Protected Sheet in Seconds

In case of a password protect worksheet you are unable to Edit the data on the Excel Sheet. If you do not Remember the Password or do not know the password to unprotect the sheet just follow the below simple steps.
 

1. Open MS Excel that have protect by Password.
 

2. Press ALT +  F11 or click on View Code in Developers Tabs

In the Above White Space Enter the below Code. Do not change the code 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

3. Now Click on the Run Button or press F5:



And there you go the sheet is unprotected for you now. Also you would be getting a message in the pop up window.

This Message is contains the password which can be used to unprotect the other sheets in the same workbook.

69 comments:

  1. You can try this site www.unprotect-excel-sheet.com to find excel sheet password

    ReplyDelete
    Replies
    1. This was amazing - PERFECT

      Delete
    2. Unable to select editors tab as that is also protected

      Delete
    3. thanks it work

      Delete
    4. Thank you very much. It works beautifully!

      Delete
    5. WORKED GREAT .. THANK YOU VERY MUCH

      Delete
    6. Thank you very much

      Delete
    7. thanks it work

      Delete
    8. Works, thank you very much

      Delete
    9. there's a way to do it easier without programming - http://www.squidoo.com/recoverexcel

      Delete
  2. Great use of VB coding, really it works.

    thanks for sharing thi

    ReplyDelete
    Replies
    1. Hi Vinod, I could not able to unlock the unprotected sheet, Can u guide me on this, thanks

      Delete
  3. Amazing buddy ... thanks a lot, it really work and helped alot

    ReplyDelete
  4. Works, Thanks. Sometimes I like to figure it out/how it works, and sometimes it's just nice to copy and paste and done!

    ReplyDelete
  5. Good job, man!! :)

    ReplyDelete
  6. Amazing .. A million thanks

    ReplyDelete
  7. THANX WORKS AS ICE CREAM SANDWITCH

    ReplyDelete
  8. Thanks a lot!! It helped me out!!!

    ReplyDelete
  9. This is cool stuff... thanks a lot mate...

    ReplyDelete
  10. This worked well for the sheets but is there a way to unprotect VBA? I need to see some code from the VBA but the same password doesn't function for the VBA on my workbook.

    ReplyDelete
  11. Works in Mac too.... saved my butt. thank you!

    ReplyDelete
  12. Awesome - thanks :0) Got me out of jail with the boss!

    ReplyDelete
  13. Its working.... Thanks.

    ReplyDelete
  14. Very good job, thanks

    ReplyDelete
  15. Good job, it helps me lot.

    ReplyDelete
  16. Thanks man, my biggest problem solved, thanks a lot

    ReplyDelete
  17. Hi, Can any one help on this, thanks, if you provide email id, so that i can send you the spreadsheet. thanks

    ReplyDelete
  18. thank u so much...

    really helpful...

    ReplyDelete
  19. Awesome! Thanks so much. This helped and works!

    ReplyDelete
  20. Many thanxs. You are the men!

    ReplyDelete
  21. Wow !! This works like hot knife through butter. Simply fantastic

    ReplyDelete
  22. Damn it won't work if you want to remove a password required to OPEN spreadsheet!! tried everything but could not do it on my own. had to pay $19 to remove it with online service called www.Password-find.com - it helped fortunately

    ReplyDelete
  23. Great suggestion. It works.

    ReplyDelete
  24. AMazing.... Works great

    ReplyDelete
  25. I think i'm in love. It worked perfectly. It's brilliant to see that it's free too.

    ReplyDelete
  26. so pove = so awesome. That totally worked.

    ReplyDelete
  27. This code only works if the password was set by Microsoft Excel (the person protecting it left the password space blank), if you want to break other passwords, you should change the 66 to 67 (from "A" to "B") to the appropriate values, but the code would take A LOT more time, so try this code first.

    ReplyDelete
  28. just love this man

    ReplyDelete
  29. It doesn't work on me. Not as explained above. Any other alternatives?

    ReplyDelete
  30. Simple. Done in seconds. Works perfectly.

    ReplyDelete
  31. This was freakin' GREAT! I work for a place that is ridiculous with "protecting" files. Every department has to protect their work and it makes my job much more difficult. Instead of being able to copy the information over from a file I have to re-type it. Talk about a waste of time. I can't begin to tell you how many countless hours I spend re-typing. For the file I wanted this to work on, it did. Thank you a BUNCH!

    ReplyDelete
  32. Just great nice

    thank you.

    ReplyDelete
  33. Thannnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnks alot

    ReplyDelete
  34. I posted back on August 1, but I had to post again to say "THANK YOU" and to say how great this works. I have been using almost every week since I found this and I will continue to use it to unprotect an excel sheet without a password. So frustrating when I continually received password protected worksheets, but this makes my job much easier.

    ReplyDelete
  35. After pressing Alt+F11, the csreen found was black where, Paste / Ctrl+V are inactive.

    ReplyDelete
  36. protection on my sheet has blocked scripting :(
    excel 2010

    ReplyDelete
  37. thank u Stacey it works work made simple cheers

    ReplyDelete
  38. hi
    if you want to recover excel password then you can use Excel password cracker tool. .....

    http://www.excelunlocker.com

    ReplyDelete
    Replies
    1. It is very fastly unlock Excel file

      Thanks you

      Delete
  39. Download Excel file password recovery Software is best tool for recovering Excel file password and unlock Excel file password after the full protection Microsoft Excel sheet database. Use this program quickly Remove Excel spreadsheet password brilliantly. It fastly works on all Microsoft Excel file versions.
    read more-: http://www.recoveryexcelpassword.com

    ReplyDelete
    Replies
    1. I used this software instantly recover my Excel file password without damaging my Excel file data......

      Thanks u.....

      Delete
  40. This comment has been removed by the author.

    ReplyDelete
  41. Absolutely BRILLIANT. Thank you!

    ReplyDelete
  42. This comment has been removed by the author.

    ReplyDelete
  43. This comment has been removed by the author.

    ReplyDelete