Unlock Excel Sheet Without Password (No Software)


In case of a password protect Excel spreadsheet, you’re
unable to edit the data on the Excel Sheet. If you have ever
forgotten the password or don’t know the password, then how
will you unlock the Excel Sheet without having the password.
Don’t worry, In this article, we will show you how to unlock
excel sheet without password.

VBA Code to Unlock a Locked Excel Sheet :

1. Open your protected Excel Worksheet and hold down
the ALT+F11 keys or click on View Code in
Developers Tabs.

2. It opens the Microsoft Visual Basic for
Application Window

3. Click Inset > Module, and paste
the following code in the Module

Don’t change anything in the given code below. Just
copy and paste the code in the Module Window.

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

Dim i4 As Integer, i5 As Integer, i6 As

On Error Resume Next
For i = 65 To 66: For j = 65 To 66: For k = 65 To

For l = 65 To 66: For m = 65 To 66: For i1 = 65 To

For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To

For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To

ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k)
& _

Chr(l) & Chr(m) & Chr(i1) & Chr(i2) &
Chr(i3) & _

Chr(i4) & Chr(i5) & Chr(i6) &

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

Exit Sub
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
End Sub

4. Now Click on the Run Button or
press F5 key on the keyboard, a popup window
will appear and click OK to close it.

unlock password protected excel sheet without password

If there are multiple password protected excel sheet,
you need to apply this code for each sheet. This VBA code
works only in Excel 2010 or lower version.

Unlock Excel Sheet By Using Extension Method :

1. Copy and paste your password protected excel file
into a folder.

2. Open the folder and navigate to Organize
> Folder and Search option > View.

unlock password protected excel file

3. Now scroll down and uncheck the box “Hide
extensions for known file types
” and press

4. The extension of excel file is shown as

unlock excel sheet without software

5. Change the file extension from xlsx to

unlock excel sheet 1

6. Open the zip file and navigate xl folder
> Worksheet
and choose your sheet such as sheet
1, sheet 2 etc.

7. Now open the sheet with NotePad and go to
Format > Word Wrap.

8. Find the code of line like “SheetProtection
and delete the password
“C71F” in this case.

unprotect excel spreadsheet without password

9. Save the NotePad file and close it.

10. Now change the file extension from zip to
and open the excel file, go to Review and click
UnProtect Sheet.

If you’ve found this article “how to unlock excel
sheet without password” helpful, share with friends by using
any social network. Feel free to ask your doubt in the
comment box.

Leave a reply "Unlock Excel Sheet Without Password (No Software)"