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. Step 1: From the Review tab, in the Changes group select Unprotect Sheet. _ Sub PasswordBreaker() 'Breaks worksheet password protection. The first step to unprotecting an Excel file is to check whether it is password-. To unprotect the sheet, follow the steps below. You should not have to change anything, sheet name etc. Open the Excel workbook for which you want to remove the password. Open your Excel document and switch to the password-protected sheet (it should be active when you run the macro). Use the extraction program to comprise the files in the second folder and change the extension of the file to. Delete the tag that starts with 'sheetProtection'. Unprotecting Excel spreadsheets, firstly, you should try VBA, which is a built-in function in Excel, although you will need to input a large number of codes during the course.

Insert the code below in the general declarations page you have opened. To unprotect Excel sheet2, right-click on 'sheet2.xml' and click on Edit then open with Notepad.

How to make excel sheet unprotected