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.

187 comments:

Anonymous said...

Awesome it really works.

Anonymous said...

wow. it really does work. many thanks!

John said...

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

Excel_Ant said...

Thanks More to Come... Keep Visiting

y2k said...

its really working......

Excel_Ant said...

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

Sjarlez said...

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?

Sjarlez said...

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.

Sjarlez said...

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.

Sjarlez said...

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.

Excel_Ant said...

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

Anonymous said...

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

Anonymous said...

Its Super & Wonderfull, Great it worked for me

Excel_Ant said...

Thanks More to Come... Keep Visiting

CK said...

Thanks a lot, It's Awesome

Anonymous said...

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

Anonymous said...

thanks..it worked and saved me @ my office

Anonymous said...

Woorks..Thanks

Anonymous said...

Awesome! Thank you, saved me so much time!

sanvenyad said...

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

regards...!

Semaj Rashad said...

Thanks!!!!

Excel Blog said...

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

baby said...

genius!!! thanks for sharing! :)

Anonymous said...

Spectaclar! Thank you a million times over and over!!!!

Anonymous said...

This is amazing and worked as saviour! Hats off!

/Shery

Anonymous said...

THANK YOU!!!

Mike Potts said...

Thanks so much !

Anonymous said...

perfect!!!

Anonymous said...

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

Jelly-Jey said...

Fantastic Job thank you so much.

Anonymous said...

Incredible, thanks very much! just perfect!

Ken Hanson said...

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

vincycal said...

Its not working for me too!

Sayied said...

Roking Buddy :D :D :D

Excel Blog said...

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

gobal said...

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

RUCHI said...

its perfect,thank you

చక్రవర్తి said...

kudos.. great work..

Sanjeev S Jahagirdar said...

THANKS THANK U VERY MUCH

akhilesh said...

i love you dear its working like the hell

Anonymous said...

thanks a ton, that was quick

Anonymous said...

Worked like a charm!! God bless.

dvijaycoleblog said...

THANKS A LOT

richvinz said...

SUPER LIKE!

bhandari krishanamurthy yogesh said...

it works

Anonymous said...

it works

Anonymous said...

Superb, well done and thanks very much for sharing.

Anonymous said...

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

Anonymous said...

Fantastic! You've saved the day!

Anonymous said...

Thanks it works!!

Anonymous said...

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

unprotect-excel-sheet.com said...

You can search for excel sheet password without using macros

Anonymous said...

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

Anonymous said...

Logic is well explained here..

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

g4googlem4money said...

Great.Its works 100%.

Anonymous said...

superb work...

Phil Reid said...
This comment has been removed by the author.
NikiforosUranos said...

HELLO
MANY TAHNKS

Anonymous said...

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

Anonymous said...

THANK YOU SOO MUCH!!!!!

Anonymous said...

its really works..
thank u...

gourav

Anonymous said...

THANK YOU SOO MUCH!!!!!

Anonymous said...

Great Awesome
Thanls a tonne

Anonymous said...

it works.

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

Helvi Risna said...

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

vivek anand said...

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

Anonymous said...

awesome... thanks a lot...

Excel Tutor said...

Bro this trick works like a charm! You are genious!

Anonymous said...

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

Anonymous said...

This is awesome. Works 100%. Thank you.

Anonymous said...

Great work, thanks for the code!

Anonymous said...

Thanks a lot

jenniferm said...

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!

Anonymous said...

WOW AWSOME IT REALLY WORK!!! THKS

Christoph said...

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!

abhinav mishra said...

THNKS DUDE ITE REALY WORK U SAVE MY WORLD
U ROCK!

Anonymous said...

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.

Anonymous said...

Awesom Good Work Keep it up

JEFFERSON ACUT said...

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,

Anonymous said...

Excellent

Jeff Krouse said...

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

নাসের said...

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

Anonymous said...

THANK YOU VERY MUCH

Anonymous said...

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

Anonymous said...

Thank you so much!!!
it worked perfectly

Lilian Uele said...

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

Anonymous said...

AWESOME DUD...

Anonymous said...

Worked fine for me thanks

Anonymous said...

Too good

Anonymous said...

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

Anonymous said...

Thanks a lot

Anonymous said...

Thanks worked like a champ easy as pie!!

Dave Stott said...

Works like charm, thank you.

Hashim Aliyev said...

Thanks a lot !!!!

Shweta said...

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 :(

Shweta said...

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:"

Levi Cointreau said...

Thanks Excel_Ant,

Its really work for me!

Regards from Indonesia :)

Anonymous said...

Thanks a lot! Works very well!!!

Anonymous said...

Thanks!! Worked great on the first time!

Anonymous said...

Awesome! Spot on and worked perfect!

abhay singh said...

o lala I salute you Geneouse

Anonymous said...

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.

Anonymous said...

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

Anonymous said...

THANK YOU!!!!

Anonymous said...

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.

Anonymous said...

Thank you so much that was so helpful!!!!

Anonymous said...

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

Anonymous said...

AHHH! Thank you!

Excel_Ant said...

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

Anonymous said...

Fantastic, worked immediately, really useful Thanks very much!!

Anonymous said...

It works perfectly. Thank you!

Anonymous said...

Thanks a lot... Perfect...

Gajendra Kumar said...

Really awesome awesome n awesome thanks for the post

Anonymous said...

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

Anonymous said...

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

royalrishi07 said...

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

Anonymous said...

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

Anonymous said...

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

Anonymous said...

It really works...
Great work pal...


--Kranti

Anonymous said...

Excellent, many thanks!

Anonymous said...

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

Anonymous said...

DHANYAWAD

FRANK said...

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

Tonny Black said...

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?

JAMAL said...

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

Anonymous said...

EXCELENT SUPERB TQ VERY MUCH ITS WORK SUPERBLY

Anonymous said...

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

Anonymous said...

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

Anonymous said...

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

Anonymous said...

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

Anonymous said...

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

Anonymous said...

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

Anonymous said...

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

Anonymous said...

Thanks this got me out of a real bind.

Anonymous said...

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

Anonymous said...

Nevermind. Got it thx!

Anonymous said...

Sweet, this was awesome!

Hashif said...

Wow.... Excellent work

Anonymous said...

nice code thanks..:)

Leonie Dawson said...

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

Parmendra Singh said...

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

Anonymous said...

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

Anonymous said...

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

Anonymous said...

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

Anonymous said...

God Bless !
Thank you.

Michał Skrodzki said...

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

Ismail khan said...

wow excellent ,it give me realy fruited result.

thanks to the author


Ismail khan
pakistan

Anonymous said...

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

Anonymous said...

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

Anonymous said...

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

Anonymous said...

thanks. works great

Dharmendra Chavda said...

Thanks it works 100%

Anonymous said...

Its working. gud one...

x3mytiz said...

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

april rhea dajang said...

very well done.. Thank you so much! :) God bless..

Anonymous said...

God bless you!

MAHESH kempepatil said...

simply awesome. Thanks a lot

ravindra saxena said...

Thanks, it was very helpful

Anonymous said...

This is great, thank you

Anonymous said...

Fantastic, really helpful when your boss protects a sheet and forgets the password....! Thanks

Anonymous said...

Thanks a lot.

Anonymous said...

Tried so many, this is the ONLY one that worked for me. Thanks a million!!

jitendra kumar said...

thanks you so much......................... its really work.........thankful to you...................

Anonymous said...

Thank you!

anicon said...
This comment has been removed by the author.
anicon said...

Doesn't work. There is no white space to enter the code into. Also the "show link" button is not highlighted. The "VBAProject" on the left is locked and won't drop down. Any suggestions?

Anonymous said...

thnaks a lot!!!

Anonymous said...

!!man, you are a legend.!!!!
Thanks

Anonymous said...

Thanks it works

Anonymous said...

Excel_Ant,

Thanks writing and posting this. I think the comments show how many people appreciate.

From the VBA code, I see that for the first 11 characters it uses either A or B and then expands to what I'm guessing the printable range for the 12th character. If someone said write to do what you did, I can write this. But never in a million years would I have thought such code would work for removing a password.

How did you know this? I'm guessing in mind at many possibilities like this was a hole left open by MSFT like some kind of Easter Egg for lack of better term.

I think you know the nature of my question. If there's any chance you could elaborate, I'd sure appreciate.

- Bill

Adriano Jorge said...

It's Working perfectly thanks...

Anonymous said...

working good.. Thanks.

Anonymous said...

hi,

i tried doing those steps, but the VB project itself is secured, and it doesn't let me type anything in the VB project unless i put in the password. the white space in VB where i should put the code is greyed space, when i try to expand the vbaproject, it asks for the password, when i try to select vba project properties it asks for a password, is there anyway to help me?

Anonymous said...

Thank you soo much for your help, for sharing this tricks with us!

Anonymous said...

If you have an encrypted file you can always try cheap online services like www.password-online.com or www.remove-password.com. They are very cheap and provide proof of decryption/unlocking before any payment. So no risk involved.

Skumar said...

GREAT WORK BROTHER...

ab said...

Thank you so much! Pages like this one make Internet a better place.

Unknown said...

Unbelievable, had been struggling for quite some time typing of an 12 sheet workbook. This code worked like magic. Kudos to you. Thanks a ton. Your are a genius.

Mary Kelly said...

Thanks! You saved the day.

Manny Sebold said...

Thanks, I wish I found it earlier. A while back, I used an online service www.password-find.com to unlock my Excel spreadsheet. It successfully removed the password, but was not free.

Anonymous said...

Sir, You are the MAN!!!

Thanks!!!

Anonymous said...

You are a fucking genius! A GENIUS!! I LOVE YOU!!!!!

emodeza said...

awesome!

Anonymous said...

it doesn't work for excel 2010

Anonymous said...

what if teh VBA has a password on it too?

Anonymous said...

As always, really great (and clear) article! This VBA doesn't work in Excel 2013 protected files as Microsoft strengthened their protection methods. I stumbled across a really well put together add-in that does the same thing but has a bunch more capabilities for recovering passwords. It works with 2010 and 2007 protection and is super cheap (compared to what I've seen others sell addins for). I found it here: http://www.thespreadsheetguru.com/passwordrecovery2010

Anonymous said...

Sorry, here's a clickable link!

http://www.thespreadsheetguru.com/passwordrecovery2010