iSumsoft » Resources » Office » 2 Ways to Unprotect Sheet in Excel without Password

2 Ways to Unprotect Sheet in Excel 2007-2016 without Password

If an Excel sheet is protected, it is read-only, and you won’t make changes to it, such as editing cells, or making format changes. To modify a protected sheet, you have to first remove protection using the Unprotect Sheet command under the Review tab in Excel.

Unprotect Sheet command

If the Excel sheet is protected with a password, you will be prompted for a password to unprotect it. Now the problem is, if you don’t know the password or if you have forgotten it, how can you unprotect the Excel sheet without the password?

type password to unprotect sheet

Don’t worry. Actually, Excel sheet protection password can be easily removed by some special way. Here in this page, we will show two ways you can unprotect Excel sheet without password.

2 ways to unprotect Excel sheet without password

Way 1: Unprotect Excel sheet with Workbook Protection Refixer

Workbook Protection Refixer is a powerful tool that can instantly remove any password that prevents you from making changes to an Excel sheet & workbook, and thus unprotect the Excel sheet & workbook without any data loss. Steps are as follows.

Step 1: Install and run Workbook Protection Refixer on your computer.

free download

Step 2: Make sure your Excel file is closed, and make sure it is an Excel 2007-2016 (.xlsx) file. If it is an .xls file, open it and then save it as an .xlsx file.

Step 3: Add the Excel file to Workbook Protection Refixer, by clicking the Open button and then navigating to the target Excel file.

Add excel file

Step 4: Unprotect Excel sheet by Remove Password button.

1) Once you click the Remove Password button, the sheet protection password is instantly removed. If the Excel file has workbook protection password, and readonly password, they can also be removed at once.

Click Remove Password

2) The original, protected Excel worksheet is saved as an unprotected worksheet in the same location. You can open the unprotected worksheet and make changes to the sheets without restrictions.

unprotected worksheet

Notes: The trial version is free and it only allows you to preview the features. The full version can truly unprotect Excel sheet & workbook, but it needs to be paid for. If you are sure you want to use it, pay few dollars to purchase Workbook Protection Refixer. If you want a free way you can unprotect Excel sheet without password, look at Way 2 in this page.

Way 2: Unprotect Excel sheet with VBA codes

If you don’t mind using cumbersome steps or spending a little more time to unprotect your Excel sheet, use the VBA codes. Steps are as follows.

Step 1: Open the Excel worksheet you need to unprotect.

Step 2: Press Alt + F11 to bring up the Microsoft Visual Basic for Applications (VBA for short) window.

Step 3: From the list under Microsoft Excel Objects on the left-side pane, select any item (e.g. sheet1), and double click on it. So a code input window will open on the right-side pane.

select the sheet to be unprotected

Step 4: Copy the following codes and paste them into the code input window. Don’t leave behind any of the characters.

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

input codes

Step 5: Click Run > Run Sub/UserForm or simply press F5 to run the codes.

Click Run to run codes

Step 6: You will be prompted with a dialog with one usable password, which means the VBA codes run successfully. Click OK to close the dialog.

Click OK

Step 7: Close the VBA window and return to the Excel worksheet. Now all the sheets are unprotected, and you can make changes to them without restrictions.