Home > Resources > Office Password > Unprotect Excel Sheet without Password

How to Unprotect Excel Worksheet without Password

Forgot password to unprotect excel sheet? Now this article would introduce two effective methods to unprotect excel worksheet/sheet without password while excel file can be opened or have no open password.

  1. Way 1: Unprotect Excel Worksheet free with VBA code
  2. Way 2: Unprotect Excel Worksheet safely with iSunshare software

forgot password to unprotect excel sheet

Way 1: Unprotect Excel Worksheet free with VBA code

If you just want to unprotect excel worksheet after forgot sheet password, this freeway is worth trying.

Step 1: Open VBA.

1. Open the worksheet you forgot password to unprotect. Then enter Macro editor with Alt +F11.
2. In VBA project, double click the sheet you need to unprotect from the menu listing in the left or on the top. This will open the general declarations page for the sheet.

select excel sheet in VBA to unprotect

Step 2: Copy and paste following VBA code in general declarations page.

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 3: Run the Macro in VBA editor.

Once the code is added correctly, run the Macro by pressing F5 or selecting Run > Run Macro in the menu of VBA editor.

run Macro in VBA editor

make sure macro to run in VBA project

Step 4: Unprotect worksheet with generated code.

Then the Macro will return you to the worksheet you want to unprotect. And a box pops up with a usable code.

unprotect excel worksheet with generated code

Just click OK in the box and you can see your worksheet become unprotected. It means it is the usable code that has helped to unprotect your worksheet.

successfully unprotect excel sheet free with vba code

Tips: You can use this power way only to unprotect or unlock your own worksheets.

Way 2: Unprotect Excel Worksheet safely with iSunshare software

If you feel above way is a little difficult, or it is not so safe enough for your excel file, this way will suggest you another more effective and safe software. We usually use it to not only unprotect worksheet, but also unprotect workbook without password, because it can remove Excel protection password at once with only one click. And according to what it can do, we call it Workbook Unprotect Genius.

Step 1: Get Workbook Unprotect Genius to install and run on your PC.

Full version is recommended if you are sure to successfully unprotect your excel sheet in few seconds.

Step 2: Import excel file that includes the worksheet you need to unprotect.

The excel file you import should be saved in *.xlsx format and include the worksheet you want to unprotect. If it is *.xls file, convert it into *.xlsx at first. And then click Open button on iSunshare Workbook Unprotect Genius to browse and select it in your computer, then add it to iSunshare software with "Open" button.

import excel file including worksheet to unprotect

Step 3: Remove sheet password to unprotect Excel worksheet.

Tap on Remove Password button now and sheet password, workbook protection password and read-only password would be removed from excel file simultaneously, supposing your excel file is protected with all of these passwords.

remove sheet password to unprotect excel worksheet

successfully remove excel worksheet password

Click OK and you would get an unprotected excel file, which contains your unprotected worksheet.

successfully unprotect excel sheet safely without password

Congratulations on successfully unprotecting excel worksheet with above methods. If you still want to unprotect Word or PowerPoint document, just follow the articles below to do.

Hot Categories
Windows Password
iTunes Password
Office Password
More +
Hot Articles
Locked Out of Office Files - How to Open
3 Ways to Remove Word Password
Forgot Excel Workbook 2010/2013/2016 Password | How to Do
How to Unlock Password Protected PowerPoint Presentation
How to Remove Forgotten Password from Access Database
More +
Latest Articles
How to Unprotect Excel Workbook without Password
How to Recover Outlook 2016 PST File Forgotten Password
Office 2016 Password Recovery after Forgot or Lost
More +
Hot Products
Windows Password Genius
iTunes Password Genius
Product Key Finder
More +