Home > Resources > Office Password > Remove and Bypass Sheet Protection

3 Ways to Remove and Bypass Sheet Protection Password

Probably you have ever faced the problem about sheet locked for editing.

excel sheet protected for editing

Actually it is just because excel sheet is protected with password you don’t know or forgot. If you can remove and bypass excel sheet protection password on excel workbook 2007-2016, it would be resolved, just like what the following article discussed.

  1. 1. Easiest way to remove and bypass excel sheet protection password
  2. 2. Free ways to remove Excel sheet protection password and bypass

Part 1: Remove and Bypass Excel Sheet Protection Password with the Easiest Way

Don’t doubt whether there is an easy and powerful way that could remove excel sheet protection password. Since if you can get the specialized third-party software, iSunshare Workbook Unprotect Genius, you would be amazed and cannot see why it can remove not only sheet protection password, but also workbook protection password so fast.

Step 1: Add password protected Excel sheet.

1. Find Workbook Unprotect Genius (full version) to install on computer.

2. After running it successfully, click Open button on it to select excel workbook (2007-2016) that includes the password protected sheet you intend to remove protection password.

Note: If it is workbook 97-2003 in .xls format, just convert it into .xlsx format and then add it.

3. Click Open button again in Open window to import it into Workbook Unprotect Genius. Then you can see it in "Encrypted File" box.

add password protected excel sheet

Step 2: Remove and bypass sheet protection password on excel workbook.

Click on Remove Password button now on Workbook Password Genius. Then you will be prompted Sheet protection password is removed. It means it has removed all of excel sheet password. From then on, you could bypass excel sheet protection password to edit any worksheet on excel workbook.

remove excel sheet protection password with easiest way

Tips: Also workbook protection password and read-only password can be removed if your workbook is protected with them but not protected with open password.

remove excel workbook protection

Part 2: Free Ways to Remove and Bypass Excel Sheet Protection Password

If you are more interested in free ways than above easy way to bypass excel sheet protection password, please try following two options to remove excel sheet protection without password for free.

Option 1: Remove Protection from Excel Sheet with Free Code

VBA code is free for everyone to use on MS Excel. So if you could create a code in VBA that can remove password protection from excel sheet, it would be better to try another free but dangerous way.

Step 1: Open your excel workbook and press Alt + F11 to open VBA.

Step 2: Select password protected Excel sheet you want to remove protection.

Several sheets list in the menu in the left or on the top of VBA window. Select the right sheet your need to remove protection based on its name, which is shown in the brackets.

select excel sheet and enter vba code

Step 3: Enter following code in VBA editor.

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 4: Press F5 or click "Run> Run Macro" in menu to run VBA code.

When there is a window pops up, just confirm the Macro you want to run and click Run button. Instantly, a new box appears with a usable code and turns you back to worksheet you have selected.

confirm to run macro in selected excel sheet

Step 5: Remove and bypass sheet protection.

Tap on OK button on the box and you would see the excel sheet protection password has been removed. From the next time, if you want to edit the sheet, password can be bypassed.

remove and bypass sheet protection

Option 2: Remove Excel Sheet Protection Using ZIP

This way works for excel workbook 97-2016. Therefore, no matter your excel workbook is in .xls or .xlsx format, you could try this way to remove sheet protection password.

Step 1: Change the excel file name from .xls or .xlsx to .zip.

Click the excel file and press F2 to rename it. But just change the extensions to .zip. Then click on Yes to save change when prompted.

change excel file name extensions to zip

Step 2: Open xml file related to excel sheet you need to remove protection.

Open the ZIP archive with 7-ZIP. Open the folder xl > worksheets and you could see several xml file. Select the xml file related to password protected excel sheet and right click on it to select Edit. Then it will be opened in Notepad by default. If not, please open it in Notepad manually.

find and open xml file related to protected sheet

Step 3: Remove "sheetProtection" tag in xml file.

Check "sheetProtection" tag in opening xml file and delete the tap beginning with it. Then press Ctrl + S to save changes and close the sheet2.xml file.

delete sheet protection tag in xml file

Step 4: Update xml file after changes in zip file.

Make sure to update the modified xml file when prompted. Just click OK button and it would be updated in zip archive.

update modified xml file

Step 5: Change zip file name extension back to .xls or .xlsx.

Rename zip file name and change zip file name extension backup to .xls or .xlsx. At this point, your excel sheet protection password has been removed.

change zip file back to excel file

Tips: Surely excel sheet also can be protected with open password. If you cannot open password protected excel sheet, just go to remove excel file open password at first and then bypass sheet protection on excel workbook.

Related Articles:

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 +