Hi Guys, Today I am Going to tell you How to Remove Password from Excel File without Knowing Password 2020. Over 99% of People are using Microsoft Products for their Works. Microsoft Excel and Word are the most used software. In that Microsoft Excel, most the people face a tedious problem which is nothing but Removing Password Protected Excel File are well known in sitemap generators but some of them are still in confusion to choose the right one. Now I am here to solve all your problems.
Also Read: How To Convert PDF to Word Online For Free?
How to Remove Password from Excel File without Knowing Password 2021
Step 1: First Of All Open Microsoft Excel ( I Prefer 2007 Will be better at cracking this ) and open the password-protected File.
Step 2: Now press ALT + F11 Keys Together and a new developer window Will Pop up.
Step 3: Right Click on the sheet which You want to Unprotect and Now Click View Code
Step 4: An empty Box will Appear
Step 5: Now Type the following Code In the box or just copy-paste it
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
Step 6: Now Press F5 Button And You Will See this message
Voila! You are done! Unlocked Your Sheet!
***