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

  1. Dear sir,

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

    Thanks

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

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

  4. Thanks very much! It worked for me!

  5. how can i un protect my 2007 excel sheet

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

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

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

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

  10. hi,

    do you have a solution for 2016 please

    thanks

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

    Thanks

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

  13. Thanks!!!!!

  14. 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 ;)

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

  16. Awesome. It works perfectly!

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

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

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

  20. How can prevent other from copying a protected worksheet

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

  22. its awesome..... it worked perfectly well

  23. without any software can we have unprotected workbook

    thanks for cooperate with me

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

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