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

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

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

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

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

  5. Hi,

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

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

    pls Help!

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

    Compile error:
    Invalid outside procedure

    pls help

  8. Its Working..............

    Thank you very Much

  9. like a lot

  10. its working tx guys

  11. If the file is on a server that has a rights management system you can also select people from the address book to have read only access

  12. good job guys

  13. Hi there,

    thank you for your advice. if VBAProject has protected how can i remove password.

    Name is not XLSX. XLSM

    How to remove VBAProject password?

    Thank you.

  14. I have tried this several times with great luck. I now have an old workbook from last year. The code works on some sheets but not all of them.

    It also looks like there are some sheets I cannot see

    This is in windows 7 with Excel 2013.

    Any advice would be greatly appreciated

  15. I don't think the VBA script works to unlock a password protected workbook in Windows 10 with Excel 2010. Pressing Alt-F11 doesn't access a list of workbook files.

  16. Awesome!! It worked! Never knew we could unprotect excel sheets so easily.

  17. Thankx so much. i forget my password if you don't help me my data will be loss
    thankx again sir

  18. Thanks a lot its working

  19. Hi,
    i have set Excel file(.xlsm) Password protection from modifying (!!) and allowed to open the file as read-only. How i can use VBA macros to determine that passord protection from modifying is set or not before the file saving.
    And how i can write in VBA macros to unprotect and protect again exactly for modifying only ?

  20. Try the instructions above it works

  21. Dear sir,

    I have protected shared Excel doc. I do not know the password, how can I remove the protection?.

    Thanks

  22. VBA is also passoword protected so cannot insert module.

  23. hello,
    i have hyperlinks to different sheets in my excel workbook, but i want to password protect them i.e. people cannot click and go to that particular sheet...how do i do it? or alternatively a way of hiding sheet only if you have a password can you open the sheet...how do i do it ?

  24. Thanks very much! It worked for me!

  25. how can i un protect my 2007 excel sheet

  26. Amazing! Thank you! Though I dont have a password to a worksheet, I unlocked the worksheet.

  27. Looking for how to set a workbook to unProtected mode due to untrusted from a network site.

  28. Excel file password breaker tool is available to remove lost password from Excel file. This application enables to open locked Word and Access file password also without any obstruction.

  29. thanks for this it's really work properly. Fantastic

  30. hi,

    do you have a solution for 2016 please

    thanks

  31. Hi How to protect certain rows/columns only in excel (where my formula will not be editable).

    Thanks

  32. Thamks.
    I have Solve my problem to guide me.

  33. Thanks!!!!!

  34. I have not forgotten my password, but all unprotect sheet access is not highlighted therefore can not click on to enter my password.

    I have also tried entering your VBA code, but when right click a box appears stating "Project is unviewable"

    Please help

    1. I am having the same issue and would love to find resolution. I have several worksheets that are now greyed out from allowing me to highlight and release the protection. Help!

      1. Same thing happened to me... check if the workbook is shared, I think that is the problem, you have to un-share it. Go to the Review tab and under the Changes group, click Share Workbook. Clear the ‘Allow changes by more than one user at the same time’ option. Once you remove that option, it should allow you to enter the password. Hope it works for you ;)

  35. Doesn't work in excel 2016, despite them saying it does

  36. Awesome. It works perfectly!

  37. can you save the password as text in the VBA code so if you forget you can easily find without running your scipt above?

    1. yes, write it in the comments :)

      'Password goes here

  38. worked like charm,
    saved many hours of trouble.
    Very much appreciated.

  39. When I follow your instructions, which are very good, when i click on protect workbook, the drop down window opens but nothing is clickable? Any thoughts as to why these options won't work for me? Also, on the tools drop down, the only line that can be completed is the second line, the first line won't allow me to put in a password, after I go to "save as" and select the file.
    John

  40. How can prevent other from copying a protected worksheet

  41. hi
    one help please
    i have one excel sheet i want give that to one of my friend but i want set limit the for copying sheet
    such as if i set limit for one time copy then after pasting it no more copy can be made or it should ask for password please help as early as possible or is there any other way to solve my problem

  42. its awesome..... it worked perfectly well

  43. without any software can we have unprotected workbook

    thanks for cooperate with me

  44. how to unprotected the work book if password is forget.

      1. how to unprotected the work book which is in a format made by others.

  45. how to unprotected the work book without any password, if password is forget

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