Articles Office How to unlock Excel Spreadsheet for editing when forgot password

How to Unlock Excel Spreadsheet for Editing When Forgot Password

Updated: By Yvonne Keller

unlock excel

Lock the cells on your Excel spreadsheet and protect them with password can helps to prevent other users from accidentally and deliberately changing, moving or deleting the data on your Excel worksheet. However, if unfortunately forgot the Excel sheet protection password, you won't be able to edit the protection part of worksheet too.

ask for unprotect sheet

How to unlock an Excel spreadsheet for editing when forgot password? Here will show you 3 ways, and it is sure to help you get rid of this tiresome password problem.

Applies to Excel 2007/2010/2013/2016.

3 ways to unlock password protected Excel sheet for editing:
Way 1: Copy the data to another sheet to edit it
Way 2: Unlock Excel sheet without password by Workbook Unprotect Tuner
Way 3: Use VBA code to unlock the locked Excel sheet

Way 1: Copy the data to another sheet to edit it

When you forgot the password to unprotect Excel sheet to edit the data, first you can create a new sheet, then copy and paste the data to the new sheet to edit it.

This way works only if the "Select locked cells" and "Select unlocked cells" actions are allowed in the protected sheet.

1. Select all the data on the sheet that needs to be unlocked.

copy data

2. Press "Ctrl + C" to copy the contents.

3. Click on the New sheet button to add a new sheet on the workbook, or press "Ctrl + N" to create a new workbook.

new sheet

4. Press "Ctrl + V" to paste the data on the new sheet. Now you can modify the data on the new sheet, and save them after editing.

Tips: You can select "Keep Source Formatting" under Paste Options, so that you don't need to adjust them in the new sheets manually. But if the protected sheet has external links to other sheets or workbooks, you need to add those links manually.

Way 2: Unlock Excel sheet without password by Workbook Unprotect Tuner

Cocosenor Workbook Unprotect Tuner can help to remove Excel Worksheet, Workbook, Read-only protection password in two seconds no matter how long or complex the password is.

1. To run Workbook Unprotect Tuner on your computer, first you need to download it, and install it.

2. Click on the Open or Add file button, and them select the Excel file to import it into the program.

import excel file

3. Click on "Remove Password" button. In two seconds, the Excel worksheet protection password is removed!

sheet protection password remove

4. Go to the folder where the Excel file is located, you will find a new Excel file with the same name but marked as "Unprotected", click on this Excel file, you will find it is the same with the old one, and the protected sheet is editable.

Tips: If the Excel file is also encrypted with opening password, remove the Excel file encrypted password first. If you forgot the Excel opening password too, go and see how to recover password when forgot Excel password.

Way 3: Use VBA code to unlock the locked Excel sheet

This way works on Excel spreadsheet 2007 and earlier version.

1. Open the Excel file, and press "Alt + F11".

2. Click on Insert, select Module.

insert module

3. Paste the following VBA code to the module box:

Sub UnprotectSheet()
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)
ActiveWorkbook.Sheets(1).Select
Range("a1").FormulaR1C1 = 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

4. Press F5 or click on the Run button to execute the Macro.

5. If it goes well, you will see the password on a popping up box.

Tips:

I got these VBA codes from the internet, and have tried on my Excel sheet 2016, but it didn't respond, maybe it only works on Excel 2007 and ealier version. If the sheet is on Excel 2010/2013/2016, go to way 2 that will work well for you.

Related Articles