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

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

  2. Thanks much.. It helped.. Much appreciated.

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

  4. Hi, insert module in greyed out.

  5. Thankxxx This is working...!!!!!

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

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

  8. Amazing! thank you so much

  9. Thanks a lot

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

  11. THANKS SOOOOOOOOOOOOOO MUCH....

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

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

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

  15. What a thoroughly fantastic piece of coding!

  16. 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! :)

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

  18. Thanks.
    It worked just as expected.

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

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

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

  22. THANKS A LOT

    IT WORKS IT SAVE MY LOTS OF TIME

    THANKS AGAIN

    PREMAL JOSHI

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

  24. Awesome. worked like a treat.Thanks

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

  26. Frickin lifesaver! Thank you!

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

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

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

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

    Thank you so much.

  31. I tried the above steps but the excel is not responding even after waiting for 30 mins.

  32. It worked, Awesome , Thanks a lot.

  33. I have to say, this is totally awesome! I RARELY leave comments like this, but I would recommend this to anyone wanting to protect or unprotect excel sheets! Thank you guys so much! :)

  34. HI,

    I am working on a template that is workbook protected. I can't recall the password and i need to change the name of a sheet. Please assist. Excel 2016

    Thanks.

  35. It worked like a charm. Thanks a lot.

  36. Thanks for the info. It helped me a lot.

  37. Thanks for this information.

  38. How to permanently protect an excel sheet so that others cant look at the VBA functions? Is there a way? I would like the hours of work put into my sheet to be protect from others forever!

    Seems the password protection can be easily broken. Please let me know.
    Help!!

  39. I have a protected worksheet and for got the password. The VB script is not responding when i run the script on my excel 2010. it hangs and i have to go into window task manager to end the run. Help

  40. I've been working on a workbook with several tabs with worksheets. I was trying to protect columns and cells on on the various worksheets. The protection did not seem to be working on a couple of the worksheets and I was experimenting trying to get it to work. Now I have several functions(Protect & unprotect worksheet, protect & unprotect workbook, allow users to edit ranges) highlighted in red and not functioning a all. How do I correct this?

  41. OMG, you saved me hours and hours of work. This VBI script worked like a charm ....thanks so much.

  42. This link really helps! Thank you so much..

  43. Very good articles. It works very well. Thank you very much.

  44. man, i like your PasswordBreaker. very great! thanks a lot.

  45. Hi,

    It's really helpful on this regards!
    Thank you so much!

  46. it didnt work... when I clicked run, it shows
    "Compile error:"
    Expected: New or type name

    pls Help!

  47. Dear friend,
    while iam trying RUN...getting the error message of

    Compile error:
    Invalid outside procedure

    pls help

  48. Its Working..............

    Thank you very Much

  49. like a lot

  50. its working tx guys

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