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.
Awesome it really works.
ReplyDeletewow excellent ,it give me realy fruited result.
Deletethanks to the author
Ismail khan
pakistan
Chance less...
DeleteUnbeatable...
Ultimate Solution...
Thanks thanks a lot :)
wow. it really does work. many thanks!
ReplyDeleteWorked like a charm.
ReplyDeleteThank you so much this saved me hours and hours of copying over to a new spreadsheet to modify.
Thanks More to Come... Keep Visiting
ReplyDeleteits really working......
ReplyDeleteHey Y2k yes it does, more to come, secrets n tricks in Excel.. Keep Visiting
ReplyDeleteThanks. This was great!
ReplyDeleteI 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?
Great post. This worked well! Thanks.
ReplyDeleteI 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.
Great post. This worked well! Thanks.
ReplyDeleteI 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.
Hi Sjarlez,
DeleteGo 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
Great post. This worked well! Thanks.
ReplyDeleteI 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.
Hi Syarlez..
ReplyDeletePlease 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
more speed............it really works....thanks alot
ReplyDeleteIts Super & Wonderfull, Great it worked for me
ReplyDeleteThanks More to Come... Keep Visiting
ReplyDeleteThanks a lot, It's Awesome
ReplyDeleteWOW WEE KA HOOTIE!!! WORKS AS ADVERTISED! YOU IS A GEE-NEE-US, ANT!
ReplyDeletethanks..it worked and saved me @ my office
ReplyDeleteWoorks..Thanks
ReplyDeleteAwesome! Thank you, saved me so much time!
ReplyDeleteThanks...! Good ...! would u please explain the logic.
ReplyDeleteregards...!
Thanks!!!!
ReplyDeleteThe Logic is simple.. First It Search's for the password and then changes the same to Blank
ReplyDeletegenius!!! thanks for sharing! :)
ReplyDeleteSpectaclar! Thank you a million times over and over!!!!
ReplyDeleteThis is amazing and worked as saviour! Hats off!
ReplyDelete/Shery
THANK YOU!!!
ReplyDeleteThanks so much !
ReplyDeleteperfect!!!
ReplyDeleteThanks, thanks, thanks! Saved my a$$.
ReplyDeleteFantastic Job thank you so much.
ReplyDeleteIncredible, thanks very much! just perfect!
ReplyDeleteCan someone please help.. this code is not working on my worksheet.
ReplyDeleteIts not working for me too!
ReplyDeleteRoking Buddy :D :D :D
ReplyDeleteHi Ken Can we know what error you are getting as this is working for everyone
ReplyDeleteThanks a million.. U r a life saver... Thanks for sharing it free of cost.. "Knowledge is worth sharing" U proved it...
ReplyDeleteits perfect,thank you
ReplyDeletekudos.. great work..
ReplyDeleteTHANKS THANK U VERY MUCH
ReplyDeletei love you dear its working like the hell
ReplyDeletethanks a ton, that was quick
ReplyDeleteWorked like a charm!! God bless.
ReplyDeleteTHANKS A LOT
ReplyDeleteSUPER LIKE!
ReplyDeleteit works
ReplyDeleteit works
ReplyDeleteSuperb, well done and thanks very much for sharing.
ReplyDeleteOh my gosh! This actually worked. So easy and so AMAZING... THANK YOU!!!!!
ReplyDeleteFantastic! You've saved the day!
ReplyDeleteThanks it works!!
ReplyDeleteDude, you are awesome! How do you come up with a code like this? I never understood that.
ReplyDeleteYou can search for excel sheet password without using macros
ReplyDeleteOho my GOD it works... GREAT. I want to know the logic behind it.. Can anyone explain me..
ReplyDeleteLogic is well explained here..
ReplyDeletehttp://mcgimpsey.com/excel/removepwords.html
Great.Its works 100%.
ReplyDeletesuperb work...
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteHELLO
ReplyDeleteMANY TAHNKS
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
ReplyDeleteTHANK YOU SOO MUCH!!!!!
ReplyDeleteits really works..
ReplyDeletethank u...
gourav
THANK YOU SOO MUCH!!!!!
ReplyDeleteGreat Awesome
ReplyDeleteThanls a tonne
it works.
ReplyDeletethank you, I'll keep this code in my safe-room. I'm sure that I'll need it in the future.
awesome, it works...
ReplyDeletethank you so much..
it works man.... you are so GREAT man.... thank you again....
ReplyDeleteawesome... thanks a lot...
ReplyDeleteBro this trick works like a charm! You are genious!
ReplyDeletethanks for sharing this...saves lots of hard work!!
ReplyDeleteThis is awesome. Works 100%. Thank you.
ReplyDeleteGreat work, thanks for the code!
ReplyDeleteThanks a lot
ReplyDeleteI 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!
ReplyDeleteWOW AWSOME IT REALLY WORK!!! THKS
ReplyDeleteHi excel-ant,
ReplyDeletethank 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!
THNKS DUDE ITE REALY WORK U SAVE MY WORLD
ReplyDeleteU ROCK!
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.
ReplyDeleteAwesom Good Work Keep it up
ReplyDeletePlease 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,
ReplyDeleteExcellent
ReplyDeleteWhen I open the workbook in HxD and do CTRL-F for the DPB string, it cannot find the string.
ReplyDeleteThank you very much for your nice solution on this regards.
ReplyDeleteThis is really effective tools for us.
THANK YOU VERY MUCH
ReplyDeleteTerrific! Nested FOR loops. Who'd a thunk?
ReplyDeleteThank you very much. You just promoted me
to "the magician" where I work.
Thank you so much!!!
ReplyDeleteit worked perfectly
Thank you sooo much for this! Very simple! Easy to follow! and best of all... IT WORKS!!!
ReplyDeleteAWESOME DUD...
ReplyDeleteWorked fine for me thanks
ReplyDeleteToo good
ReplyDeletei 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
ReplyDeleteThanks a lot
ReplyDeleteThanks worked like a champ easy as pie!!
ReplyDeleteWorks like charm, thank you.
ReplyDeleteThanks a lot !!!!
ReplyDeleteit 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 :(
ReplyDeletealright ...got it myself :) so thought of sharing it with whoever may find it useful
ReplyDeleteThe 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:"
Thanks Excel_Ant,
ReplyDeleteIts really work for me!
Regards from Indonesia :)
Thanks a lot! Works very well!!!
ReplyDeleteThanks!! Worked great on the first time!
ReplyDeleteAwesome! Spot on and worked perfect!
ReplyDeleteo lala I salute you Geneouse
ReplyDeleteThere'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.
ReplyDeleteHad my doubts about this but I cant argue with the results...one excel sheet unlocked! Thanks from a happy user :)
ReplyDeleteTHANK YOU!!!!
ReplyDeleteThanks, it was a pain in the #$@ trying to search google for a way to do this that worked.
ReplyDeleteA 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.
Thank you so much that was so helpful!!!!
ReplyDeleteI needed to unprotect my own file, THANK YOU VERY MUCH !!!
ReplyDeleteAHHH! Thank you!
ReplyDeleteGuys this is the most simplest way we have come across to unprotect an excel sheet.. Just Paste the formula and its Unlocked.
ReplyDeleteI 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.
Deleteany ideas??????
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!!!
DeleteFantastic, worked immediately, really useful Thanks very much!!
ReplyDeleteIt works perfectly. Thank you!
ReplyDeleteThanks a lot... Perfect...
ReplyDeleteReally awesome awesome n awesome thanks for the post
ReplyDeleteHi 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.
ReplyDeleteany ideas??????
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!!!
DeleteHow it works guyz? Actually I forgot d password for my excel file. Please help me out how to recover it
ReplyDeleteThanks very much..... worked first time!
ReplyDeleteAwesome!!! It works fine. I've another question, I've once excel file which is open protcted. How to break that password.
ReplyDeleteIt really works...
ReplyDeleteGreat work pal...
--Kranti
Excellent, many thanks!
ReplyDeleteVery Easily Unprotected my sheet :) Thanx...!!!!!!!!1
ReplyDeleteDHANYAWAD
ReplyDeletehi 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,
ReplyDeletewaiting for some one who can reply and help me in this regard.
Thanks
verizon.mobility@gmail.com
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?
ReplyDeleteSuper. It worked for me to unprotect the excel file perfectly. Thanks a lot.
ReplyDeleteEXCELENT SUPERB TQ VERY MUCH ITS WORK SUPERBLY
ReplyDeleteso now how to lock it decently so the guy who didn't want to give me the stupid pwd can't access it?
ReplyDeleteWooohooooo it works, man that solved a headache, guy that locked it left the company.
ReplyDeleteCongratulations.... It really works... Thanks a lot...
ReplyDeletebut in my case show link is also disabled :( how to do it pls help guys
ReplyDeletethis helped a ton... i am amazed at how it worked, thanks
ReplyDeleteomg thank you so much it really works .... i've been trying and trying for the last 2 weeks
ReplyDeleteThanks this got me out of a real bind.
ReplyDeleteI do not have a white space to paste in. Any recommendations?
ReplyDeleteNevermind. Got it thx!
ReplyDeleteSweet, this was awesome!
ReplyDeleteWow.... Excellent work
ReplyDeletenice code thanks..:)
ReplyDeletei do not understand what is the White Space to enter into?
ReplyDeletei am not able to unprotect through this format..pls help me
ReplyDeleteWorks :) Good one. Thanks much for the post!
ReplyDeleteI was so excited to try this out but it unfortunately doesnt work for me.
ReplyDeleteIt gives me an error saying that the macro's for this project is disabled. Any idea where or how I enable the macros
Boss Thank you so much bro.....Great Easy work...Saved my Days to work to hours...God bless you..
ReplyDeleteGod Bless !
ReplyDeleteThank you.
hey, does not work. I get a window asking me to chose a macro...
ReplyDeletethanks. works great
ReplyDeleteThanks it works 100%
ReplyDeleteIts working. gud one...
ReplyDeleteOh my god!!! It really works :)...
ReplyDeleteThank yuo!!!