Wednesday

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.
 

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

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.



1000's of paid documents can now be unprotected in fractions of second.

154 comments:

  1. Awesome it really works.

    ReplyDelete
    Replies
    1. wow excellent ,it give me realy fruited result.

      thanks to the author


      Ismail khan
      pakistan

      Delete
    2. Chance less...
      Unbeatable...
      Ultimate Solution...
      Thanks thanks a lot :)

      Delete
  2. wow. it really does work. many thanks!

    ReplyDelete
  3. Worked like a charm.
    Thank you so much this saved me hours and hours of copying over to a new spreadsheet to modify.

    ReplyDelete
  4. Thanks More to Come... Keep Visiting

    ReplyDelete
  5. its really working......

    ReplyDelete
  6. Hey Y2k yes it does, more to come, secrets n tricks in Excel.. Keep Visiting

    ReplyDelete
  7. Thanks. This was great!

    I have a follow up question. It worked well and I could access the main worksheet. Now, I would like to access a hidden sheet. I know it's there but when I try to unhide, that option is greyed out. When entering VBA (alt+F11) and select this hidden sheet, I see under properties that under "Visible" it says "0 - xlSheetHidden". From the dropdown menu, I have tried to select "-1 xlSheetVisible" instead but I get the following error message: "Unable to set the Visible property of the Worksheet class".

    Can you assist?

    ReplyDelete
  8. Great post. This worked well! Thanks.

    I have a related question. With this I managed to unlock the main worksheet. I see now however that there are references to a hidden worksheet that I need to review also. When I try to unhide the document, this option is however greyed out. When I go into VBA (alt+F11) and the select the hidden worksheet, under properties, under "Visible", it says "0 - xlSheetHidden". I tried via the dropdown menu to select "-1 - xlSheetVisible" but i got the following error message: Unable to set the Visible property of the Worksheet class".

    Can you help?

    Thanks a lot in advance.

    ReplyDelete
  9. Great post. This worked well! Thanks.

    I have a related question. With this I managed to unlock the main worksheet. I see now however that there are references to a hidden worksheet that I need to review also. When I try to unhide the document, this option is however greyed out. When I go into VBA (alt+F11) and the select the hidden worksheet, under properties, under "Visible", it says "0 - xlSheetHidden". I tried via the dropdown menu to select "-1 - xlSheetVisible" but i got the following error message: Unable to set the Visible property of the Worksheet class".

    Can you help?

    Thanks a lot in advance.

    ReplyDelete
    Replies
    1. Hi Sjarlez,

      Go to Review tab -> Click Protect Workbook -> Remove the tick from "Protect Structure and Windows. It will ask for the password give the same password obtained from the above macro (i.e. AAABBB....)

      You are done!!!

      Now right click any sheet and click Unhide...

      Hope this helps.

      - Sohil Ravjani

      Delete
  10. Great post. This worked well! Thanks.

    I have a related question. With this I managed to unlock the main worksheet. I see now however that there are references to a hidden worksheet that I need to review also. When I try to unhide the sheet, this option is however greyed out. When I go into VBA (alt+F11) and the select the hidden worksheet, under properties, under "Visible", it says "0 - xlSheetHidden". I tried via the dropdown menu to select "-1 - xlSheetVisible" but i got the following error message: Unable to set the Visible property of the Worksheet class".

    Can you help?

    Thanks a lot in advance.

    ReplyDelete
  11. Hi Syarlez..

    Please check this post

    http://excel-formula.blogspot.com/2011/12/removing-excel-workbook-vba-password.html

    this helps to remove passwords of the excel sheets which are locked in VBA

    Thanks for visiting our blog. Keep Visiting for more details

    ReplyDelete
  12. more speed............it really works....thanks alot

    ReplyDelete
  13. Its Super & Wonderfull, Great it worked for me

    ReplyDelete
  14. Thanks More to Come... Keep Visiting

    ReplyDelete
  15. Thanks a lot, It's Awesome

    ReplyDelete
  16. WOW WEE KA HOOTIE!!! WORKS AS ADVERTISED! YOU IS A GEE-NEE-US, ANT!

    ReplyDelete
  17. thanks..it worked and saved me @ my office

    ReplyDelete
  18. Awesome! Thank you, saved me so much time!

    ReplyDelete
  19. Thanks...! Good ...! would u please explain the logic.

    regards...!

    ReplyDelete
  20. The Logic is simple.. First It Search's for the password and then changes the same to Blank

    ReplyDelete
  21. genius!!! thanks for sharing! :)

    ReplyDelete
  22. Spectaclar! Thank you a million times over and over!!!!

    ReplyDelete
  23. This is amazing and worked as saviour! Hats off!

    /Shery

    ReplyDelete
  24. Thanks, thanks, thanks! Saved my a$$.

    ReplyDelete
  25. Fantastic Job thank you so much.

    ReplyDelete
  26. Incredible, thanks very much! just perfect!

    ReplyDelete
  27. Can someone please help.. this code is not working on my worksheet.

    ReplyDelete
  28. Hi Ken Can we know what error you are getting as this is working for everyone

    ReplyDelete
  29. Thanks a million.. U r a life saver... Thanks for sharing it free of cost.. "Knowledge is worth sharing" U proved it...

    ReplyDelete
  30. i love you dear its working like the hell

    ReplyDelete
  31. thanks a ton, that was quick

    ReplyDelete
  32. Worked like a charm!! God bless.

    ReplyDelete
  33. Superb, well done and thanks very much for sharing.

    ReplyDelete
  34. Oh my gosh! This actually worked. So easy and so AMAZING... THANK YOU!!!!!

    ReplyDelete
  35. Fantastic! You've saved the day!

    ReplyDelete
  36. Thanks it works!!

    ReplyDelete
  37. Dude, you are awesome! How do you come up with a code like this? I never understood that.

    ReplyDelete
  38. You can search for excel sheet password without using macros

    ReplyDelete
  39. Oho my GOD it works... GREAT. I want to know the logic behind it.. Can anyone explain me..

    ReplyDelete
  40. Logic is well explained here..

    http://mcgimpsey.com/excel/removepwords.html

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

    ReplyDelete
  42. Can you advise how long it takes for the code to unlock the sheet? On my side, nothing is happening at the moment and the code is already running for a couple of minutes... Thanks

    ReplyDelete
  43. THANK YOU SOO MUCH!!!!!

    ReplyDelete
  44. its really works..
    thank u...

    gourav

    ReplyDelete
  45. THANK YOU SOO MUCH!!!!!

    ReplyDelete
  46. Great Awesome
    Thanls a tonne

    ReplyDelete
  47. it works.

    thank you, I'll keep this code in my safe-room. I'm sure that I'll need it in the future.

    ReplyDelete
  48. awesome, it works...
    thank you so much..

    ReplyDelete
  49. it works man.... you are so GREAT man.... thank you again....

    ReplyDelete
  50. awesome... thanks a lot...

    ReplyDelete
  51. Bro this trick works like a charm! You are genious!

    ReplyDelete
  52. thanks for sharing this...saves lots of hard work!!

    ReplyDelete
  53. This is awesome. Works 100%. Thank you.

    ReplyDelete
  54. Great work, thanks for the code!

    ReplyDelete
  55. I have Excel Non-Commercial Use a the top of my screen, all of the icons are greyed out and cannot select Show Link. Any suggestions to get my workbook open? thanks in advance!

    ReplyDelete
  56. WOW AWSOME IT REALLY WORK!!! THKS

    ReplyDelete
  57. Hi excel-ant,

    thank you for taking the time to share this very usefull post with us.
    It helped me a lot and saved me so much time.
    Keep up the good work!

    ReplyDelete
  58. THNKS DUDE ITE REALY WORK U SAVE MY WORLD
    U ROCK!

    ReplyDelete
  59. Tried this one, but it won't help if your file is encrypted. I found no free ways to unlock a document which requires a password after opening and had to pay to an online service called www.password-find.com to decrypt my file. They did help me for a small fee, so I recommend it to everyone who can't open a password protected speadsheet.

    ReplyDelete
  60. Awesom Good Work Keep it up

    ReplyDelete
  61. Please help me with this i already done the step nut there is another Sub password.. please give me the password with this document please i need this for the school http://www.4shared.com/office/PEIRD1eN/2G1_English.html or just comment with the link or email me the passwords of this file here zandor_jeff@yahoo.com thank you.. hope you can help me,

    ReplyDelete
  62. When I open the workbook in HxD and do CTRL-F for the DPB string, it cannot find the string.

    ReplyDelete
  63. Thank you very much for your nice solution on this regards.
    This is really effective tools for us.

    ReplyDelete
  64. THANK YOU VERY MUCH

    ReplyDelete
  65. Terrific! Nested FOR loops. Who'd a thunk?
    Thank you very much. You just promoted me
    to "the magician" where I work.

    ReplyDelete
  66. Thank you so much!!!
    it worked perfectly

    ReplyDelete
  67. Thank you sooo much for this! Very simple! Easy to follow! and best of all... IT WORKS!!!

    ReplyDelete
  68. Worked fine for me thanks

    ReplyDelete
  69. i can't do that.. how it can work plx tell me,, i have excel protected sheet,, first can i open simple excel sheet or what,, plz tell me in detail at aas.shah@hotmail.com

    ReplyDelete
  70. Thanks worked like a champ easy as pie!!

    ReplyDelete
  71. Works like charm, thank you.

    ReplyDelete
  72. it doesnt run at all for me...returns me the error on first occurance of "Chr" saying "Compile error: Can't find project or library" ...can u please help :(

    ReplyDelete
  73. alright ...got it myself :) so thought of sharing it with whoever may find it useful

    The problem may be resolved as follows:

    1. Open the database or application.
    2. Open a module in Design view or press ALT+F11 to switch to the Visual Basic Editor.
    3. On the Tools menu, click References.
    4. Clear the check box for the type library or object library marked as "Missing:"

    ReplyDelete
  74. Thanks Excel_Ant,

    Its really work for me!

    Regards from Indonesia :)

    ReplyDelete
  75. Thanks a lot! Works very well!!!

    ReplyDelete
  76. Thanks!! Worked great on the first time!

    ReplyDelete
  77. Awesome! Spot on and worked perfect!

    ReplyDelete
  78. There's some online services that specialize in unlocking Excel spreadsheets if you don't want to bother with it yourself. It's easy: you upload a protected spreadsheet to the server and get it back in several seconds with all passwords removed. Used the service named www.Password-find.com and had no trouble with it.

    ReplyDelete
  79. Had my doubts about this but I cant argue with the results...one excel sheet unlocked! Thanks from a happy user :)

    ReplyDelete
  80. Thanks, it was a pain in the #$@ trying to search google for a way to do this that worked.

    A note to Excel 2013 users- if the Developer tab isn't in your toolbar/ribbon, go to File - Options - Customize Ribbon, then check the 'Developers' tab in the Main tabs box.

    ReplyDelete
  81. Thank you so much that was so helpful!!!!

    ReplyDelete
  82. I needed to unprotect my own file, THANK YOU VERY MUCH !!!

    ReplyDelete
  83. AHHH! Thank you!

    ReplyDelete
  84. Guys this is the most simplest way we have come across to unprotect an excel sheet.. Just Paste the formula and its Unlocked.

    ReplyDelete
    Replies
    1. I have tried this and can't seem to get it to work, the area where it says to copy & past the code into mine is grey and wont let you paste it.

      any ideas??????

      Delete
    2. Mine was the same way. I had to double click the spreadsheet I was trying to unlock ("this workbook"). Look to the left side of the page under "Project - VBAProject" section. Mine went through a period of saying (running) (not responding) at the top of my screen. I just let it sit for a few minutes and then my password window popped up. Worked great!!!

      Delete
  85. Fantastic, worked immediately, really useful Thanks very much!!

    ReplyDelete
  86. It works perfectly. Thank you!

    ReplyDelete
  87. Thanks a lot... Perfect...

    ReplyDelete
  88. Really awesome awesome n awesome thanks for the post

    ReplyDelete
  89. Hi All, I have tried this and can't seem to get it to work, the area where it says to copy & past the code into mine is grey and wont let you paste it.

    any ideas??????

    ReplyDelete
    Replies
    1. Mine was the same way. I had to double click the spreadsheet I was trying to unlock ("this workbook"). Look to the left side of the page under "Project - VBAProject" section. Mine went through a period of saying (running) (not responding) at the top of my screen. I just let it sit for a few minutes and then my password window popped up. Worked great!!!

      Delete
  90. How it works guyz? Actually I forgot d password for my excel file. Please help me out how to recover it

    ReplyDelete
  91. Thanks very much..... worked first time!

    ReplyDelete
  92. Awesome!!! It works fine. I've another question, I've once excel file which is open protcted. How to break that password.

    ReplyDelete
  93. It really works...
    Great work pal...


    --Kranti

    ReplyDelete
  94. Excellent, many thanks!

    ReplyDelete
  95. Very Easily Unprotected my sheet :) Thanx...!!!!!!!!1

    ReplyDelete
  96. hi there, i have been facing difficulty while unlocked my excel sheet could anyone let me know about the process and how to unlock it would be highly appreciated,
    waiting for some one who can reply and help me in this regard.


    Thanks
    verizon.mobility@gmail.com

    ReplyDelete
  97. I heard that there is another Excel password recovery tool called SmartKey Excel Password Recovery and it can also unlock a password protected Excel document, what do you think of it?

    ReplyDelete
  98. Super. It worked for me to unprotect the excel file perfectly. Thanks a lot.

    ReplyDelete
  99. EXCELENT SUPERB TQ VERY MUCH ITS WORK SUPERBLY

    ReplyDelete
  100. so now how to lock it decently so the guy who didn't want to give me the stupid pwd can't access it?

    ReplyDelete
  101. Wooohooooo it works, man that solved a headache, guy that locked it left the company.

    ReplyDelete
  102. Congratulations.... It really works... Thanks a lot...

    ReplyDelete
  103. but in my case show link is also disabled :( how to do it pls help guys

    ReplyDelete
  104. this helped a ton... i am amazed at how it worked, thanks

    ReplyDelete
  105. omg thank you so much it really works .... i've been trying and trying for the last 2 weeks

    ReplyDelete
  106. Thanks this got me out of a real bind.

    ReplyDelete
  107. I do not have a white space to paste in. Any recommendations?

    ReplyDelete
  108. Nevermind. Got it thx!

    ReplyDelete
  109. Sweet, this was awesome!

    ReplyDelete
  110. Wow.... Excellent work

    ReplyDelete
  111. nice code thanks..:)

    ReplyDelete
  112. i do not understand what is the White Space to enter into?

    ReplyDelete
  113. i am not able to unprotect through this format..pls help me

    ReplyDelete
  114. Works :) Good one. Thanks much for the post!

    ReplyDelete
  115. I was so excited to try this out but it unfortunately doesnt work for me.
    It gives me an error saying that the macro's for this project is disabled. Any idea where or how I enable the macros

    ReplyDelete
  116. Boss Thank you so much bro.....Great Easy work...Saved my Days to work to hours...God bless you..

    ReplyDelete
  117. God Bless !
    Thank you.

    ReplyDelete
  118. hey, does not work. I get a window asking me to chose a macro...

    ReplyDelete
  119. thanks. works great

    ReplyDelete
  120. Its working. gud one...

    ReplyDelete
  121. Oh my god!!! It really works :)...
    Thank yuo!!!

    ReplyDelete