The tutorial shows the detailed steps to protect Excel sheet with or without passwords. It also explains how to unlock Excel spreadsheet without password if you forgot or misplaced it. Continue reading
by Svetlana Cheusheva, updated on
The tutorial shows the detailed steps to protect Excel sheet with or without passwords. It also explains how to unlock Excel spreadsheet without password if you forgot or misplaced it. Continue reading
Comments page 11. Total comments: 391
Nice article, just wanted to tell the Author great job on helping me crack this stupid workbook
These tips really worked for me. I was able to unlock a spreadsheet just based on these steps. Thanks
How do you open a workbook for which you forgot the password?
Hi Don,
Worksheet-level protection does not prevent you from opening a file, it only prevents you from editing a specific worksheet.
You rock. Thanks so much for sharing this information!
THANKU
Awesome! Thank you.
your direction to open VBAProject(*.xls) Password protected sheet didn't work. I have attempted open a Password protected sheet which used excel 2007. After you right click on the VBAProject I was able to see Insert option but Module part is grayed out not available to insert the code mentioned. :(
When you have a chance please reply.
Thanks
Double click on the worksheet so that i displays to enter the code. Just copy and paste the code there it works fine.
save your file as 97-2003 version, follow the process as mentioned in: Unlock Excel spreadsheet with VBA code (for Excel 2010 and lower)
Then the password should be removed.
simply save the file back to 2007 or higher version.
done
CANNOT CONVERT THE LOCKED EXCEL TO LOWER VERSIONS
How can you run the code if you cannot open the file?
Hi!
The code published in this article is intended for unprotecting worksheets, not workbooks. Worksheet level protection does not prevent you from opening a file and running the macro. As for removing the workbook encryption or workbook password protection, sorry we don't know a way to do this with VBA.
If you have workbooks please try to share. I will retrieve the password and give you asap. Thank you.
Hi
Can you please support me on this
Genius !!
Thanks.
Actually Very Nice information. I opened password Protected Excel file in just 5 min using your techniques.Thank You.
Hi,
Many thanks it works very easily and really use full
Again Thanks
wow it's amazing yaar very good thanks for sharing this information
Nice information. Thank you
when try to run this code excel workbook is not responding could you please help
I'm having the same issue. I converted my file to .xls and it hasn't stopped running.
Thank you very much madam
Great article! if you have a version that is newer than 2010 you can try "save as" as a 2003-2007 workbook, then run the macro to unlock and then "save as" back to version you want. Worked for me.
This worked perfectly! I had a 2016 workbook, so saved as "2003-2007 Workbook", ran the macro on all the sheets, then saved as the original version, overwriting it. I then made sure that I noted the password that I used for the sheets, before re-protecting it!
Thank you very much, Reddcliffe :)
Works like a charm for me. Thank you!
I am trying to crack password but process is not completed .Not found any password or error. process is stuck.
Very helpful blog.. Thank you so much Guys
It works, thanks for this very useful and educative information.
how setting protection of excel sheet
how setting unprotected of excel sheet
Hi, I am trying to unprotect an excel document without knowing the password. It has been saved in excel 2010 and I have tried copying and pasting your password breaker code but I get an compile error - sub or function not defined.
Any ideas why this is happening?
what was the answer.... were you able to get past that error? I have the same
i already try, and no need to type the password. after run (password was remove too, but only one sheet. so we need to do same thing many time for all sheet)
I have run the above code for unlocking excel sheet, its work for 1 file but its not working for another file. Please help to unblock the same.
Go back to the open Excel workbook, and switch to the next sheet before running the next code. This worked for me.
Great job!! Thumbsup
super super..very useful one.
Worked like a charm - thanks
You rock man!
Good
Even if "select locked cells" is not allowed , you can still copy and paste the sheet contents by selecting all desired columns and holding down SHIFT while you right click and select COPY from the context menu
Thanks for your guide in your site. It was fully helpful
Thanks Sir .
Hi,
In my workbook there are some sheets which are protected and hidden.I forgot the password just want to know how to retrieve those sheets.
View the copy and paste solution in the main article. Then read this:
Even if "select locked cells" is not allowed , you can still copy and paste the sheet contents by selecting all desired columns and holding down SHIFT while you right click and select COPY from the context menu
I used the code for in protecting without password. Its working. Thanks..
its awesome..... it worked perfectly well
It works!!! thank you!
Its worked for me.. thank you very much
Is there a way for one to unprotect a workbook if the entire workbook has been password protected/disabled, including the ability to insert VBA modules? I'm only interested in being able to view the macros being used, and not *necessarily* the ability to modify the coding, itself.
dear sir
please guide me for short cut formula for protected to unprotected under excel
Hi,thanks for suporting
I worked fine. Thanks. Much love from Namibia (y)
Thanks much.. It helped.. Much appreciated.
Thanks for this excellent write up. Thank you for sharing.
Hi, insert module in greyed out.
Thankxxx This is working...!!!!!
This is Amazing. really help full, your are x-man. Once again Thank you very much.
This is simply amazing... I am awestruck with the vba code that it unprotected the sheet. I want to master vba but need a perfect training program and how can I write complex codes to make my work more simpler... Please advise. Once again Thank you very much.
Hello, Saurabh,
Thanks for your feedback!
I can advise you to check out MrExcel forum, where you can ask (or even find right away) everything you want to know about VBA codes.
Hope their forum helps!
Amazing! thank you so much
Thanks a lot
Hi, I tried the code on excel 2013.
Everything seemed ok but when I press "f5" it starts working and within seconds it says not responding and I can't do anything on excel.
Please help.