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

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

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

  3. Thanks

  4. Thank you very much!

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

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

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

  8. my macro interface is also protected...

  9. You sir are a genious!

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

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

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

  12. Thanks a lot! :)

  13. Huge help. Thanks.

  14. thank you so much

  15. How to unlock a cell with data validation?

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

  17. SO AMAZING!!!

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

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

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

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

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

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

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

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

  26. Thanks a lot, so very helpful

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

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

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

  30. It works! Thanks!

  31. Very helpfull guide
    Thanks

  32. So simple and easy to break the password work college put on sheets to be clever, clever and play Mr Important over us. Except he left the company without giving us the passwords. Now that IS clever, clever!

  33. thanks, I have a question. If I forgot password which any sheet hidden, What should I do ?

  34. thanks a lot, so helpful

  35. I forgot the pw and my Excel in Version Microsoft 2013

  36. I have forgot my excel sheet password so how to remove the same?

  37. Hi
    Excellent Information, :)
    Thanks a ton !

  38. Ablebits, Thank you so much for this article. Extremely helpful.

  39. Thank you! worked like a charm!!!

  40. I am trying to unlock a password protected workbook. I saved in 97-2003 excel, then went to view code. A pop-up saying, VBAProject Password. I clicked cancel, received a system error, clicked ok. Module is greyed out. I tried to copy the code referenced and paste but it will not allow me to paste. Please help

  41. Its not extra-ordinary. Its average. Its OK

    1. I'm looking forward to seeing you post a better article on this topic...

  42. My excel workfile (2013) is password protected for open.
    No problems with this.
    However in some unknown way my workbook structure has become protected (meaning I can't add a new worksheet etc.) When I try to add a new worksheet by clicking on the + symbol at the end of all the worksheet tabs - the + symbol is greyed out.
    Any solution to this would be appreciated.
    I'm hoping to avoid the slow solution of copying all the worksheets individually to a new workfile.
    I am very hesitant to download any non Microsoft software to unprotect my workfile and MS don't provide any support in this area.

    1. (just replying to my own post).
      I have now given up on this and taken the slow solution by copying all my worksheets to a new workfile.

  43. Does this work for Excel 2013 and 2016? If not, is there tutorial available for these versions?

    1. Hi Mark,

      To unlock Excel 2013 and Excel 2016 worksheets, you can save the file as Excel 97-2003 workbook (*.xls), run the macro to unprotect it, and then save it back as an .xlsx file.

      1. Thank you so much Svetlana Cheusheva...
        it's working..

  44. thank you it was very easy and perfect

  45. Hi

    it is very worth for me

    thanks

  46. This is helpful, thanks for the post!

  47. How to unlock workbook password if I forgot the password

  48. i forgot my pass what should i do?

  49. Thanks a lot...

  50. Hi, I wanted to in-protect workbook, I tried all the options but not worked, file saved in Excel 2013

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