To unprotect Excel sheet without password in the modern versions of Excel 2019, Excel 2016 and Excel 2013, you can save the document as Excel 97-2003 workbook (.xls) first. 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. If your Excel file contains more than one protected sheet, run the macro for each sheet individually to unprotect it. _ Sub PasswordBreaker() 'Breaks worksheet password protection. You should not have to change anything, sheet name etc. xlsx format and include the worksheet you want to unprotect. The excel file you import should be saved in. Step 2: Import excel file that includes the worksheet you need to unprotect.
Insert the code below in the general declarations page you have opened. Im not reproducing the protect/unprotect grouped worksheet behavior on 64-bit Windows Excel 2010, 2013 or 2016 in a Windows 10 VM. Full version is recommended if you are sure to successfully unprotect your excel sheet in few seconds.
