Alternatively, you can use one of the free tools, for example, Password Protection Remover add-in for Excel. Run the macro to unprotect the worksheet, and then save the workbook back as a. Then, close Excel and reopen the workbook – it will be opened in compatibility mode. 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.If your Excel file contains more than one protected sheet, run the macro for each sheet individually to unprotect it.Simply click OK and the sheet is unprotected! You do not need to remember this fake password or enter it anywhere. The macro will report a cracked password, which is not the original one (always some combination of A’s and B’s), but nevertheless, it works.Press F5 or click the Run button on the toolbar and wait a couple of minutes.If ActiveSheet.ProtectContents = False Then In the window that appears, paste in the following code:ĭim i As Integer, j As Integer, k As Integerĭim i As Integer, m As Integer, n As Integerĭim i1 As Integer, i2 As Integer, i3 As Integerĭim i4 As Integer, i5 As Integer, i6 As Integerįor i = 65 To 66: For j = 65 To 66: For k = 65 To 66įor l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66įor i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66įor i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126ĪctiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _Ĭhr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _.Right-click the workbook name on the left pane ( Project-VBAProject pane) and select Insert > Module from the context menu.Press Alt + F11 to open the Visual Basic Editor.You can do it by clicking on the file icon, it will open a list of options, select the info tab and click on the protect workbook.(it should be active when you run the code). Open your Excel document and switch to the password-protected sheet.If you are using Excel 2010 or older, you can unlock a sheet with a password with the following steps: Unlock Excel spreadsheet with VBA code (for Excel 2010 and lower) Charting: Once the numbers are developed for any sales and development report, it is necessary to develop a simple understanding model.Such models are easily developed with the help of Excels.

How to open ws file