Comments on: How to protect and unprotect Excel sheet with or without password

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

  1. Nice article, just wanted to tell the Author great job on helping me crack this stupid workbook

  2. These tips really worked for me. I was able to unlock a spreadsheet just based on these steps. Thanks

  3. How do you open a workbook for which you forgot the password?

    1. Hi Don,

      Worksheet-level protection does not prevent you from opening a file, it only prevents you from editing a specific worksheet.

  4. You rock. Thanks so much for sharing this information!

  5. THANKU

  6. Awesome! Thank you.

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

    1. Double click on the worksheet so that i displays to enter the code. Just copy and paste the code there it works fine.

    2. 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

      1. CANNOT CONVERT THE LOCKED EXCEL TO LOWER VERSIONS

  8. How can you run the code if you cannot open the file?

    1. 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.

      1. If you have workbooks please try to share. I will retrieve the password and give you asap. Thank you.

        1. Hi

          Can you please support me on this

  9. Genius !!
    Thanks.

  10. Actually Very Nice information. I opened password Protected Excel file in just 5 min using your techniques.Thank You.

  11. Hi,

    Many thanks it works very easily and really use full

    Again Thanks

  12. wow it's amazing yaar very good thanks for sharing this information

  13. Nice information. Thank you

  14. when try to run this code excel workbook is not responding could you please help

    1. I'm having the same issue. I converted my file to .xls and it hasn't stopped running.

  15. Thank you very much madam

  16. 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.

    1. 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 :)

  17. Works like a charm for me. Thank you!

  18. I am trying to crack password but process is not completed .Not found any password or error. process is stuck.

  19. Very helpful blog.. Thank you so much Guys

  20. It works, thanks for this very useful and educative information.

  21. how setting protection of excel sheet

  22. how setting unprotected of excel sheet

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

    1. what was the answer.... were you able to get past that error? I have the same

    2. 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)

  24. 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.

    1. Go back to the open Excel workbook, and switch to the next sheet before running the next code. This worked for me.

  25. Great job!! Thumbsup

  26. super super..very useful one.

  27. Worked like a charm - thanks

  28. You rock man!

  29. Good

  30. 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

  31. Thanks for your guide in your site. It was fully helpful

  32. Thanks Sir .

  33. 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.

    1. 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

  34. I used the code for in protecting without password. Its working. Thanks..

  35. its awesome..... it worked perfectly well

  36. It works!!! thank you!

  37. Its worked for me.. thank you very much

  38. 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.

  39. dear sir

    please guide me for short cut formula for protected to unprotected under excel

  40. Hi,thanks for suporting

  41. I worked fine. Thanks. Much love from Namibia (y)

  42. Thanks much.. It helped.. Much appreciated.

  43. Thanks for this excellent write up. Thank you for sharing.

  44. Hi, insert module in greyed out.

  45. Thankxxx This is working...!!!!!

  46. This is Amazing. really help full, your are x-man. Once again Thank you very much.

  47. 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.

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

  48. Amazing! thank you so much

  49. Thanks a lot

  50. 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.

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)