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

  1. Initially the process froze Excel and was non responsive. I read further and followed the instruction to save the document as 97-2003 (*.xls). Closed and re-openned the document and then restarted the process. It worked instantly! thank you!

    1. Wow, it's works. Initially wasn't respond. After your comment. We need to close the file and re-open it again in order to work. A genius!

  2. The macro froze my excel for 20 minutes, at 8gig ram i5 CPU. I have terminated the application, because I cant sit and wait so long.

  3. Your unlock of excel sheet worked, thanks.

  4. You're a genius! Thank you for sharing. It is a great help.

  5. My excel workbook and sheets are protected and I can't unlock or unprotect what can I do? Please help

  6. VERY NICE
    GOOD JOB

  7. Hello,

    I want to limit who can modify my workbook to 2 people without using a password - can anybody help?

    1. Could be done if using active directory and having a routine to determine the user. Far easier to pw protect and give 2 people the password.

  8. My file is in .xlsm. I can unprotect without password, but I can't save the file to keep it unprotected. Each time when I open it is again protected. How to save the file to be unprotected forever.

    1. It seems you have a macros in your document which sets password back when they are removed. Try turning the macros in the document off and then opening it. If it will the unprotected macros are the reason and you need to change their code to solve your issue.

  9. Thanks a lot

    It works great for me.

    Actually helped me a lot.

    Thank you for sharing your Knowledge

  10. It didn't work for me. Is there other options ?

  11. Many thanks

  12. HUGE THANK YOU!!!!

  13. Thank you. This is amazing!!

  14. I am using Excel 2016, how to unprotect my workbook when it has been both encrypt and password protected? I knew my password. Thanks.

  15. I have an excel sheet, it was working very well on my company laptop and i can make changes on it but when i transferred it to another laptop or macbook the sheet didn’t work and i can’t make any changes.
    Please can you help me in this problem ? How can i make this sheet work again on the macbook or any other laptop?
    Thanks

    1. Please share your file. Thanks

      Muhammad

  16. Wow!
    This code is awesome. It kept my mouth open for like 2 minutes.
    I don't understand a thing about the codes but it works like charm.
    Thanks a lot for this help.

    1. Hello Sir,

      Could please unprotected an excel sheet for me

      1. Hey Dillip,
        First of all save as your file as "97-2003 Workbook" format. After saving open this file and do above steps and all will be done within seconds :)

        Muhammad

  17. it worked for me! Thanks for this. Will bookmark your page in case this happens again to me ^^

  18. Super, I had an old Excel sheet 97? with a lot of formulas and forgot the PW, now I can use it again; it Works yesssss!
    One run per tab, so several run ! (the full document was protected)

  19. it works perfectly, UL then DL tadah!, unlock!thanks..

  20. Thanks you. It worked perfectly

  21. Thanks a lot

  22. Thank you so much, Its worked perfectly

  23. Great help!

  24. pakka, working

  25. want to protect the entire sheet and leave range of some cells editable

  26. Worked perfectly, thankyou so much. It would be helpful if we can identify the password. Because i have lot of work sheet with same password. Help me if there is possibilities.

  27. thank you very much you made my work very easy

  28. if you want to recover an excel password instantly without wasting time then try the best "eSoftTools Excel password recovery software".it has advanced techniques to recover the lost passwords.

  29. I was trying to unprotect a sheet in XLSX file, it did not work. However, I have saved the workbook in XLS (97-2003) format. Protection was removed (without any VBA code)

  30. When I run the comd to break the password it shows "Compile Error" "Can't find the project library"

  31. Hi everyone,

    This code works for me. Could anyone explain to me the vba code meaning and how such code works?

    Thank you very much.

    Michelle

  32. Thanks very much for you help. It works like a charm.

  33. Very good ....the command working good...

  34. Hello,

    it works fine for me, until i click Ok (message with the cracked password)
    But the file is not Unprotected...
    Any ideas/suggestions?

  35. Found it! using the name box to enter coordinates and press enter...beautiful!

  36. I'm trying to find is it's possible to have a protected worksheet being entirely copied and pasted or to have all its unprotected cells in different ranges copied and pasted elsewhere respecting the initial ranges, all in one click.

  37. Worked as dwscrib3d thanks

  38. Hi i tried to unprotect without password and have the latest version of Excel
    When I started and pressed Alt + F11 all I got was the Sound panel
    It is the latest Macair Excel that came with the Mac upgrade in the Spring of 2020
    What do I do?

    1. Please be note that mac keyboard is different.
      You need to press fn before the F11.

  39. Thank you Sir,
    Amazing! I really appreciate for your tips about unlock a password-protected sheet.
    I have try in excel 2010 and its work completely without any error.
    Once again thank you.
    Cheers

  40. Hello guys,
    I'm trying to unprotected the excel file (ver 2007) by Excel 2016.
    I recently have dealed with problem that I could not do the act of inserting --> modul. is there any other solutions?

  41. Thank you so much, dear. Highly appreciated.

  42. Worked perfectly.

  43. Followed everything as described. But at final run getting Compile error > For without Next
    And marking the End Sub in blue color.
    Can you please solve the issue?

  44. How to unlock/unprotect excel file with password? Please help

  45. How do you unlock an excel file that was password protected to open? If it's possible.

  46. Hi, its working

  47. Many methods are suggested and it worked perfectly for me. Much appreciated. Thank You.

  48. amazing! you are a wizard.

  49. Thanks a lot! You are a "Genius".
    Saved me lots of time.

  50. Oh my Goodness! I was working in a very old multi-page spreadsheet we have used for years and years. I have no idea who even created it. I ran into trouble on a certain cell which apparently was "protected" and password protected. Of course, I had no idea what the password was since it was so old. I messed around trying to figure out how to get around the password. This worked like a charm and you saved me a lot of time and frustration. Thank you very 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 :)