Provider

Tuesday, July 17, 2012

How to Unprotect an excel sheet without password


How to Unprotect an excel sheet without password
Unprotect Password Protected Sheet in Seconds

In case of a password protect worksheet you are unable to Edit the data on the Excel Sheet. If you do not Remember the Password or do not know the password to unprotect the sheet just follow the below simple steps.
 

1. Open MS Excel that have protect by Password.
 

2. Press ALT +  F11 or click on View Code in Developers Tabs

In the Above White Space Enter the below Code. Do not change the code just copy paste:

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 "One usable 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

3. Now Click on the Run Button or press F5:



And there you go the sheet is unprotected for you now. Also you would be getting a message in the pop up window.

This Message is contains the password which can be used to unprotect the other sheets in the same workbook.

120 comments:

  1. You can try this site www.unprotect-excel-sheet.com to find excel sheet password

    ReplyDelete
    Replies
    1. This was amazing - PERFECT

      Delete
    2. Unable to select editors tab as that is also protected

      Delete
    3. thanks it work

      Delete
    4. Thank you very much. It works beautifully!

      Delete
    5. WORKED GREAT .. THANK YOU VERY MUCH

      Delete
    6. Thank you very much

      Delete
    7. thanks it work

      Delete
    8. Works, thank you very much

      Delete
    9. there's a way to do it easier without programming - http://www.squidoo.com/recoverexcel

      Delete
    10. Simply Awesome ...Thank you..

      Madawa

      Delete
    11. THANKS BRO

      REALLY THANKS FROM THE BOTTOM OF MY HEART

      FOR ME YOU ARE GENIUS

      I HAD BEEN CONFUSED FOR SO MANY WEEKS

      Delete
    12. Learn72: How To Unprotect An Excel Sheet Without Password >>>>> Download Now

      >>>>> Download Full

      Learn72: How To Unprotect An Excel Sheet Without Password >>>>> Download LINK

      >>>>> Download Now

      Learn72: How To Unprotect An Excel Sheet Without Password >>>>> Download Full

      >>>>> Download LINK 8G

      Delete
  2. Great use of VB coding, really it works.

    thanks for sharing thi

    ReplyDelete
    Replies
    1. Hi Vinod, I could not able to unlock the unprotected sheet, Can u guide me on this, thanks

      Delete
  3. Amazing buddy ... thanks a lot, it really work and helped alot

    ReplyDelete
  4. Works, Thanks. Sometimes I like to figure it out/how it works, and sometimes it's just nice to copy and paste and done!

    ReplyDelete
  5. Good job, man!! :)

    ReplyDelete
  6. Amazing .. A million thanks

    ReplyDelete
  7. THANX WORKS AS ICE CREAM SANDWITCH

    ReplyDelete
  8. Definetively really works, thanks

    ReplyDelete
  9. This is cool stuff... thanks a lot mate...

    ReplyDelete
  10. This worked well for the sheets but is there a way to unprotect VBA? I need to see some code from the VBA but the same password doesn't function for the VBA on my workbook.

    ReplyDelete
  11. Works in Mac too.... saved my butt. thank you!

    ReplyDelete
    Replies
    1. How iti work on Mac for you. I just can make it work

      Delete
  12. Awesome - thanks :0) Got me out of jail with the boss!

    ReplyDelete
  13. Its working.... Thanks.

    ReplyDelete
  14. Very good job, thanks

    ReplyDelete
  15. Good job, it helps me lot.

    ReplyDelete
  16. Thanks man, my biggest problem solved, thanks a lot

    ReplyDelete
  17. Hi, Can any one help on this, thanks, if you provide email id, so that i can send you the spreadsheet. thanks

    ReplyDelete
  18. amazing, good piece of codem,

    thanks

    ReplyDelete
  19. thank u so much...

    really helpful...

    ReplyDelete
  20. Awesome! Thanks so much. This helped and works!

    ReplyDelete
  21. Many thanxs. You are the men!

    ReplyDelete
  22. Wow !! This works like hot knife through butter. Simply fantastic

    ReplyDelete
  23. Damn it won't work if you want to remove a password required to OPEN spreadsheet!! tried everything but could not do it on my own. had to pay $19 to remove it with online service called www.Password-find.com - it helped fortunately

    ReplyDelete
  24. Great suggestion. It works.

    ReplyDelete
  25. AMazing.... Works great

    ReplyDelete
  26. I think i'm in love. It worked perfectly. It's brilliant to see that it's free too.

    ReplyDelete
  27. so pove = so awesome. That totally worked.

    ReplyDelete
  28. This code only works if the password was set by Microsoft Excel (the person protecting it left the password space blank), if you want to break other passwords, you should change the 66 to 67 (from "A" to "B") to the appropriate values, but the code would take A LOT more time, so try this code first.

    ReplyDelete
  29. just love this man

    ReplyDelete
  30. It doesn't work on me. Not as explained above. Any other alternatives?

    ReplyDelete
  31. Simple. Done in seconds. Works perfectly.

    ReplyDelete
  32. This was freakin' GREAT! I work for a place that is ridiculous with "protecting" files. Every department has to protect their work and it makes my job much more difficult. Instead of being able to copy the information over from a file I have to re-type it. Talk about a waste of time. I can't begin to tell you how many countless hours I spend re-typing. For the file I wanted this to work on, it did. Thank you a BUNCH!

    ReplyDelete
  33. Thannnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnks alot

    ReplyDelete
  34. I posted back on August 1, but I had to post again to say "THANK YOU" and to say how great this works. I have been using almost every week since I found this and I will continue to use it to unprotect an excel sheet without a password. So frustrating when I continually received password protected worksheets, but this makes my job much easier.

    ReplyDelete
  35. After pressing Alt+F11, the csreen found was black where, Paste / Ctrl+V are inactive.

    ReplyDelete
  36. protection on my sheet has blocked scripting :(
    excel 2010

    ReplyDelete
  37. thank u Stacey it works work made simple cheers

    ReplyDelete
  38. hi
    if you want to recover excel password then you can use Excel password cracker tool. .....

    http://www.excelunlocker.com

    ReplyDelete
    Replies
    1. It is very fastly unlock Excel file

      Thanks you

      Delete
  39. Download Excel file password recovery Software is best tool for recovering Excel file password and unlock Excel file password after the full protection Microsoft Excel sheet database. Use this program quickly Remove Excel spreadsheet password brilliantly. It fastly works on all Microsoft Excel file versions.
    read more-: http://www.recoveryexcelpassword.com

    ReplyDelete
    Replies
    1. I used this software instantly recover my Excel file password without damaging my Excel file data......

      Thanks u.....

      Delete
  40. This comment has been removed by the author.

    ReplyDelete
  41. Absolutely BRILLIANT. Thank you!

    ReplyDelete
  42. This comment has been removed by the author.

    ReplyDelete
  43. This comment has been removed by the author.

    ReplyDelete
  44. This will not work for me. The previous employee locked to even open the workbook. Its a simple sheet to for new hires paperwork. Not sure why its so protected but I need help to get into this to hire new employees :) Any ideas if the workbook is password to open?

    ReplyDelete
  45. Thanks very much for your help. amazing.......

    ReplyDelete
  46. Is it possible to apply this to workbooks that will not open up ("this project is unreadable") when clicked in Excel developer mode?

    ReplyDelete
  47. Thank you for nice posting in which a user can easily unprotected an excel sheet without password. To recover lost MS Excel password you can apply office password recoverytool which gives instant recovery of your Excel file.

    ReplyDelete
  48. Its not working. Bcoz when i enabled Macro and pressed (Alt+F11), the Visual Basic Window opened, but that was also protected by Visual Basic Password. So No program shown so how can i copy that program given by you and paste in the white space board while its not showing rather demanding for a VBA password

    ReplyDelete
  49. To unprotect Excel sheet without password, I use SmartKey Excel Password Recovery software and it is the best Excel password recovery tool for me.

    ReplyDelete
  50. Doesn't work for Excel 2013 :(

    ReplyDelete
  51. This comment has been removed by the author.

    ReplyDelete
  52. With the help of MS Excel password cracker to crack Excel file password with all Excel versions and able to open password from xls, xlsx, xlsm, xltm, xla, xlam, xlsb files.
    CLick here: http://www.microsoft.excelunlockertool.com/

    ReplyDelete
  53. Download Excel password remover for removing Excel password with all versions Excel file including xlsx, xls, xlsb, xla, xlam, xltm and xlsm

    read more
    http://www.excelpasswordrecoverysoftware.excelpasswordremover.com/

    ReplyDelete
  54. Its not working for me. When I run it I get an error that says, compile error, expected end of statement.

    ReplyDelete
  55. do you want to earn money using your phone????you can use this best earn money app

    ReplyDelete
  56. Thank you for discussing this great post.

    You have finding more information about Microsoft excel not responding related problems.

    ReplyDelete
  57. Get your Password-protected Excel file decrypted by using the Excel Password Recovery Software by eSoftTools which helps in removing and recovering your Excel File Password as well As Excel sheet password in very less time. It can effectively work on all the MS Excel File formats(.xlsx, .xlsm, .xls, .xlsb, .xla, .xlam, .xltm) and as well as on all the Windows OS versions. The first 3 letters of the password can be retrieved without any cost with its DEMO VERSION available.

    Read more: Excel Unlocker Tool

    ReplyDelete
  58. To Unlock Excel file Password quickly, try the eSoftTools Excel Password Recovery Software which can remove all sets of password combination through various recovery attacks such as Brute Force attack, Dictionary attack and, Mask attack. This application breaks the Excel Workbook Password along with Excel Worksheet Password without affecting the original content in the Excel file. It effectively works with all MS Excel workbook versions and Windows versions. A DEMO VERSION is available to all the clients.

    EXCEL UNLOCKER TOOL

    ReplyDelete
  59. By utilizing eSoftTools Excel Password Recovery Software, anyone can recover the Strong Excel password in easy manner. It allows to remove and recover the Excel Password with the support of 3 superb recovery attack methods, like, Brute Force attack, Dictionary attack and, Mask attack. It can supports all excel file versions including 97, 2000, 2002, 2003, 2007, 2010, 2013 and 2016. Knowledge in computer science is not required to use this software, since it is very user-friendly. A trial version can be used by anyone to get back the first 3 letters of the password without any charges.

    ReplyDelete
  60. manycam pro khokharpc Such a nice and helpful piece of information. I’m so happy that you shared this helpful information with us. Please keep us up to date like this. Thanks for sharing.

    ReplyDelete
  61. avid pro tools farooqpc I really enjoy reading your post about this Posting. This sort of clever work and coverage! Keep up the wonderful works guys, thanks for sharing

    ReplyDelete
  62. Your refreshing take on accomplishing our team goal makes it an absolute pleaser to work with you! Keep the imagination flowing.

    39. I think I have nev

    k7 total security crack
    cudatext crack
    dropbox crack

    ReplyDelete
  63. I like your all posts. You have done really good work. Thank you for the information you provide. Keep it up

    Phasmophobia Crack
    winzip driver updater crack
    FIFA 22 Crack

    ReplyDelete
  64. Learn72: How To Unprotect An Excel Sheet Without Password >>>>> Download Now

    >>>>> Download Full

    Learn72: How To Unprotect An Excel Sheet Without Password >>>>> Download LINK

    >>>>> Download Now

    Learn72: How To Unprotect An Excel Sheet Without Password >>>>> Download Full

    >>>>> Download LINK

    ReplyDelete
  65. — Democratic challenger Marcus Flowers outraised U.S. Rep. Marjorie Taylor Greene in Georgia's 14th Congressional District. He raised $2.4 million ...


    webstorm crack
    typing master pro crack
    vso convertxtodvd crack
    mackeeper crack
    teamviewer crack with torrent

    ReplyDelete
  66. Unprotecting an Excel sheet without the password requires specialized software or code. Best Game Emulators it's important to remember the importance of legal and ethical standards.

    ReplyDelete