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 →

Table of contents

Comments page 6. Total comments: 391

  1. it works than you

  2. Excellent script! Thanks so much for publishing this!

  3. Hi,

    I need a macro to open a separate sheet from protected excel and disable all the formulas

  4. if it's not working on XlSX files - try to save the file first as macro-enabled file - XLSM - then try this hack it works perfectly - have a good day

  5. When I run the code, I get no response from Excel or the VBA editor and have to force close it. I waited as long as an hour to try and see if it would work.

  6. LIFESAVER! THANK YOU! Fixed my problem in 3 minutes.

  7. Thank You

    You are really Great

  8. Extremely useful info, managed to unlock very important docs so that our team could introduce needed changes

  9. Super, its works 100% :-)

  10. Hi,
    I protected a Sheet. I used a Password. We need to unlock and relock to add information. When I went back in to 'unprotect' its greyed out and I cant select unprotect. Now it seems its locked up. There is no option in the 'Info or Right click the sheet, nor on the review tool bar' any ideas to ungrey so we can lock and unlock everyday?

    FYI
    This is a shared workbook. Others will be updating the other tabs.

    thanks

  11. i have a XLS file but SHARED and protected
    vba is unusable, most of options are greyed out including insert-module
    can;t save it as xlsx and unzip it

    any solutions? can't find nothing on the internet

    1. Save the sheet as an xls file and then follow the steps. once completed save again as an xlxs sheet

  12. I'm using this on xlxs file but its not working only loading, no output since half hour.
    pls help....

  13. Hi,
    I am having an xlsx password protected sheet. e forgot the password the sheet and now we need the data from sheet on urgent basis.

    I tried ot follow your blog steps but unfortunately VBA editor for this sheet is coming as all options disabled.

    Can You please suggest what could be the issue.
    Thanks,
    Nida

  14. Excellent! The password cracker saved me days of work. My IT guys moved all my files to a new laptop, but some glitch in the MS Excel program on the new computer locked/protected all versions (online and my desktop) of a particular file. Thanks for being the smartest person around!

  15. Your password cracker worked perfectly. Thank you for this.

  16. WOW ITS WORKING

  17. Hi how to open the excel file with out password,

  18. Thank you very much for the code, it works perfectly. You saved me one day of work because after 4 years I had forgotten my password... I also unedrstand that security is relative :)

  19. Hello.
    Please could you help me solve small problem.
    I would like to know if is possible to modify Protect sheet /which is set up like preset. To add in the list one more option- allow /merge and center/

    thx

  20. Unprotect excel sheet formula doesn't works

    1. It does work. If you are working with a spreadsheet that is later than 2010, you must save as .xls format first then run the macro.

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

  22. Thanks for your help

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

  24. all works!
    awesome

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

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

  27. You are the best!
    It worked.

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

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

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

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

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

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

  34. very good. it works fine!

  35. thanks for the info, it worked

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

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

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

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

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

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

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

  43. Thanks

  44. Thank you very much!

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

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

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

  48. my macro interface is also protected...

  49. You sir are a genious!

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

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

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