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

  1. You are genius!!! Thank you so very much!!!!!

  2. Thanks for your help

  3. It works all from the first strike of the keyboard. You're good.

  4. all works!
    awesome

  5. Wasted 1.5 hours..nothing works as described

    1. It works perfect! I tried

    2. Working Prefectly

    3. If you are trying to unprotect a workbook, it doesn't work as described. You have to unprotect from the 'file' tab. Once there just erase the password and save. Attempting to do it the way described in this article will appear to work, but won't actually remove the password protection (which you will clearly still see when you go to the 'file' tab).

      1. did you save as xls first? I tried it wouldn't work if the file is xlsx

    4. you must try again... its working perfectly..

    5. I think you can't understand. This tips is actually Perfect.
      Try again.
      I tried it Excell 2010.

  6. I am impressed too much with the explanation. It's quite explicit and simple to understand.
    I am a DATA ANALYST, but I never knew that, one can unlock a PASSWORD SHEET without a PASSWORD...

    thanks pretty much....

    Do you have TUTORIALS ON YOUTUBE?

  7. You are the best!
    It worked.

  8. Many thanks! It works!
    I'm using the MS Office 2013. I converted the file to lower version of excel and copied the code and resolved the issue.

  9. Hello Sir..
    It was Amazing.. Thank you so much for your support.. It really made my work easy..

  10. Dear Sir ,
    my excel sheet password to forgot .
    please how to unprotected excel sheet

  11. please tell me if the insert command is not activating what to do.

  12. Amazing.
    It works after converting the excel to 97 format.

  13. Great job, but I need to know excel sheet open password breaker. Please help me dear.
    Thanks

  14. very good. it works fine!

  15. thanks for the info, it worked

  16. Thank you so much! Such a great help. You're the best

  17. That's been a lifesaver thank you so much.

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

  19. Very useful and effective article. Solve my problem of unlocking sheet without password

  20. Hi.
    Doesn't work!!
    Any ideas?

  21. i have an excell that has many hiddensheets; in the VBA i am able to see the tree, but it would let me change to visible to unhide the sheet... its blocked...

    i tried the pass word cracker...that is not working. still can see the sheets... any ideas?

  22. Worked like a charm! Thank you!!!!

  23. Thanks

  24. Thank you very much!

  25. How long should it take after you run the macro? I continue to get the blue circle of thought and a 'not responding' message in my header bar.

    1. Getting same. This used to work very quickly, but now it appears to hang... Going to let it run overnight and see what happens.

  26. I was given a protected Excel file, that I needed to use the logic in, for my project at work. But I wasn't given the password! (I don't think anyone else knew it either.)

    Thanks so much for the section on getting in a protected sheet. Now I can get on with my task. :)

  27. if in the inset option the module option is disabled what to do on that case .

  28. my macro interface is also protected...

  29. You sir are a genious!

    The script worked, and I unlocked my managers excel and modified it and locked it back :-D

  30. This is BS it says AAAAAAA... at all files and of course it doesn't work

  31. Fantastic article and saved me from a massive headache.
    Thank you!!

  32. Thanks a lot! :)

  33. Huge help. Thanks.

  34. thank you so much

  35. How to unlock a cell with data validation?

  36. When I do this I get a "Not responding" error.

  37. SO AMAZING!!!

  38. Thank you so much ... It really works like a charm.

  39. hello,
    how to remove the protect sheet and protect workbook.
    i don't want to protect my workbook or my sheet at all anymore.
    i have the password. i tried what i know but still requesting password to unprotect my sheet or my workbook.
    thank you a lot in advance

  40. Hallo Sir/Mem
    I'M Pawan
    Mujhe ye janna hai ki hum jese excel me sheet ko protect kar ke rakhe hai aur uska password forget ho chuke hai to use dubra open kese kru please reply me

  41. i m forget the password Excel-10 version and can't change the content what are the protected. how can i unprotect this file without password.pls help to advise on this.

  42. i m forget the password Excel-10 version and can't change the content what are the protected. how can i unprotect this file without password.

  43. Hey i got all the steps correctly & got the password also but when i press "okay" it goes back to the VBA page & doesn't open - please help.

  44. very good its help and i re generate the password

  45. Just to say, this tip was a life saver today, thanks so much!

  46. Thanks a lot, so very helpful

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

  48. now i have my meal, paid work for 1 minute work, thanks very helpful article.

  49. I have an excel file but i forget the password and i am unable to open this file. can anyone help me?????

  50. It works! Thanks!

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