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 12. Total comments: 391

  1. how setting protection of excel sheet

  2. how setting unprotected of excel sheet

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

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

  5. Great job!! Thumbsup

  6. super super..very useful one.

  7. Worked like a charm - thanks

  8. You rock man!

  9. Good

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

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

  12. Thanks Sir .

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

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

  15. its awesome..... it worked perfectly well

  16. It works!!! thank you!

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

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

  19. dear sir

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

  20. Hi,thanks for suporting

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

  22. Thanks much.. It helped.. Much appreciated.

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

  24. Hi, insert module in greyed out.

  25. Thankxxx This is working...!!!!!

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

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

  28. Amazing! thank you so much

  29. Thanks a lot

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

  31. THANKS SOOOOOOOOOOOOOO MUCH....

  32. Svetlana,

    Thank you very much for the VB editor instruction, I was able to follow and remove the PW. I will bookmark this site for future use.

  33. Is there a way to unlock a file which is protect with password? (I mean when the entire file is protected). I tried using the VBA code and it only worked when part of the workbook is protected.
    Thank you!

  34. Thank you! Just saved me from a very awkward conversation!

  35. What a thoroughly fantastic piece of coding!

  36. To unprotect sheet in Excel 2013 file (.xlsx) just save the file as excel 200-2003 (.xls). Then you can brake the sheet with VBA code. Works great! :)

  37. Thanks for the guide, easy to understand and do, works perfectly.

  38. Thanks.
    It worked just as expected.

  39. Its awesome.

    but i have protected 1 file. to open that file i need to give password.
    Readonly option is not there, at that time what i need to do.
    how to open that excell file ???????

  40. your information is realy helpfull..I faced problem with my own excell..as i am inserting data, excel stoped working and restart.. suddenly it become protected sheet and cannot do anything to edit it..i am at my end because what to do, I do not protect the sheet and even have the password to start with!!!!
    Luckily I found out ways to unprotect sheet even without password..Now can smile happily!!!

    Thank you Author.

  41. good and better imformation
    i proud to use it software
    very very nice

  42. THANKS A LOT

    IT WORKS IT SAVE MY LOTS OF TIME

    THANKS AGAIN

    PREMAL JOSHI

  43. We use Excel 2010 at work for schedules. The worksheets containing work schedules are protected from changes by employees with only managers having password access. Our issue is that occasionally when employees go in to view the spreadsheet the file becomes "locked for editing" by the employee. Managers can't get in to make changes. Even if the employee signs in again, they often get the same message (that the file is locked for editing by THEMSELF). We are interested in preventing employees from being able to place the file in read only status at all, and secondly how do we get around the read only status when an employee (who doesn't have the password) some how locks the file for editing. Thank you

  44. Awesome. worked like a treat.Thanks

  45. i forget password of my excel sheet reply as soon as posible

  46. Frickin lifesaver! Thank you!

  47. I have attendance sheet which is not allowing me to edit may be password protected and don't have the password please help

  48. Really It is Great . You are really awesome. Thank you soo much.

  49. THAAAANKKKKKKKKKK YOUUUUUUUUUUUUU SOOOOOOOO MUUUUUUCHHHHHHHHHH I'M REALLY THANKFUL THAT THERE ARE PEOPLE LIKE WHOEVER WROTE THIS INFORMATION, WILLIN TO HELP OTHER SHARING THEIR KNOWLEDGE!!!

  50. Wow!VB is working , You made my work easy, God bless you.

    Thank you so much.

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