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

  1. Thanks a lot

  2. Thank you so much, Its worked perfectly

  3. Great help!

  4. pakka, working

  5. want to protect the entire sheet and leave range of some cells editable

  6. Worked perfectly, thankyou so much. It would be helpful if we can identify the password. Because i have lot of work sheet with same password. Help me if there is possibilities.

  7. thank you very much you made my work very easy

  8. if you want to recover an excel password instantly without wasting time then try the best "eSoftTools Excel password recovery software".it has advanced techniques to recover the lost passwords.

  9. I was trying to unprotect a sheet in XLSX file, it did not work. However, I have saved the workbook in XLS (97-2003) format. Protection was removed (without any VBA code)

  10. When I run the comd to break the password it shows "Compile Error" "Can't find the project library"

  11. Hi everyone,

    This code works for me. Could anyone explain to me the vba code meaning and how such code works?

    Thank you very much.

    Michelle

  12. Thanks very much for you help. It works like a charm.

  13. Very good ....the command working good...

  14. Hello,

    it works fine for me, until i click Ok (message with the cracked password)
    But the file is not Unprotected...
    Any ideas/suggestions?

  15. Found it! using the name box to enter coordinates and press enter...beautiful!

  16. I'm trying to find is it's possible to have a protected worksheet being entirely copied and pasted or to have all its unprotected cells in different ranges copied and pasted elsewhere respecting the initial ranges, all in one click.

  17. Worked as dwscrib3d thanks

  18. Hi i tried to unprotect without password and have the latest version of Excel
    When I started and pressed Alt + F11 all I got was the Sound panel
    It is the latest Macair Excel that came with the Mac upgrade in the Spring of 2020
    What do I do?

    1. Please be note that mac keyboard is different.
      You need to press fn before the F11.

  19. Thank you Sir,
    Amazing! I really appreciate for your tips about unlock a password-protected sheet.
    I have try in excel 2010 and its work completely without any error.
    Once again thank you.
    Cheers

  20. Hello guys,
    I'm trying to unprotected the excel file (ver 2007) by Excel 2016.
    I recently have dealed with problem that I could not do the act of inserting --> modul. is there any other solutions?

  21. Thank you so much, dear. Highly appreciated.

  22. Worked perfectly.

  23. Followed everything as described. But at final run getting Compile error > For without Next
    And marking the End Sub in blue color.
    Can you please solve the issue?

  24. How to unlock/unprotect excel file with password? Please help

  25. How do you unlock an excel file that was password protected to open? If it's possible.

  26. Hi, its working

  27. Many methods are suggested and it worked perfectly for me. Much appreciated. Thank You.

  28. amazing! you are a wizard.

  29. Thanks a lot! You are a "Genius".
    Saved me lots of time.

  30. Oh my Goodness! I was working in a very old multi-page spreadsheet we have used for years and years. I have no idea who even created it. I ran into trouble on a certain cell which apparently was "protected" and password protected. Of course, I had no idea what the password was since it was so old. I messed around trying to figure out how to get around the password. This worked like a charm and you saved me a lot of time and frustration. Thank you very much!!!!

  31. Works like a charm! This has saved a lot of time.
    Thank you very much.
    If you are having difficulty with this--make sure you click at the end of the text in the module before pressing F5.

  32. Thanks, the informations helps me

  33. works for me !
    Thanks a bunch

  34. Thank you very much.Very helpful.

  35. It took me a few tries, but it worked. I was surprised that it worked ... but it did!

  36. Works perfectly! The tip on unlocking sheets in 2013 and 2016 excel works as well, just make sure you save to an .xls file, and ALSO close out of excel and reopen the file before trying it. This opens the file in compatibility mode. Took me 20 minutes to figure out why it wasn't working.

  37. This is the coolest VBA code. Works perfectly. For those of you having problems, make sure you are right-clicking on the sheet to add the module, not the workbook. Thank you so much for posting!! What a time saver.

  38. Hi Thanks a lot
    you really made my day smartie.....

  39. Thank you so much!!! This was an incredible help.

  40. Hello,
    I would like ot thank you for the script to break up the PSW. Great job. really great work!

    Thank you!

  41. it worked!

  42. I have to agree with Kurt. I've been trying for hours to "Remove" a password from a WORKBOOK

  43. Me thinks Pepe Mano is rude and Stupid

  44. I've been using the cracker for years, working perfect. now my problem is I have new computer with office 265 and when I try to use it excel goes to "not responding" I have to go to task manager and end task to restart excel. Can anybody help me?

  45. Amazing...!
    I like excel and I appreciate...

  46. guys please help i have locked the workbook and then forgot the password how can i crack that

  47. There is a more simple way . You can simply upload the protected excel sheet to your google drive. Then open it using google spread sheet. Then u will be able to edit any cells from your google spread sheet. If you want to save it in your computer,just copy and paste it to a new sheet in MS excel.

    1. Brilliant! my prob solved in 2 mins - ive been trying to crack the pwd for months but never thought of this! I adore you!

    2. OMG this saved the day!! The VBA method worked last year and earlier this year but does not anymore, at least for the spreadsheets we have. THANK YOU KANAN

      1. Yes, Google Sheets works!!!!
        Thanks!

  48. Hi,
    awesome tip, worked perfectly, thanks for sharing!!
    But it won't let me save it, have to enter the password to save.
    thanks heaps

  49. ALERT!!! DO NOT WASTE YOUR TIME ON THIS CRAP!!!!
    THIS MACRO AS POSTED ABOVE DOES NOT NOT NOT NOT NOT NOT NOT NOT WORK
    THIS ARTICLE SHOULD BE REMOVED FROM THE INTERNET
    CRAP WASTE OF TIME!!!!!!

    Sub PasswordBreaker()
    'Breaks worksheet password protection.

    Dim i As Integer, j As Integer, k As Integer
    Dim l As Integer, m As Integer, n As Integer
    Dim i1 As Integer, i2 As Integer, i3 As Integer
    Dim i4 As Integer, i5 As Integer, i6 As Integer

    On Error Resume Next

    For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
    For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
    For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
    For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126

    ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
    Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
    Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)

    If ActiveSheet.ProtectContents = False Then
    MsgBox "Password is " & Chr(i) & Chr(j) & _
    Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
    Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)

    Exit Sub

    End If

    Next: Next: Next: Next: Next: Next
    Next: Next: Next: Next: Next: Next
    End Sub

    1. I just used this method for the 1st time today and it worked like a charm.
      Your just not doing it right!!

  50. wait a couple of minutes (password crecker) mind you, a couple actually mean two. Been waiting for 15 minutes, still counting... Anybody experienced this??

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