Skip to content Skip to sidebar Skip to footer
Home / Game

How to Open Uneditable/Protected Excel

Home PC How to Open Uneditable/Protected Excel
How to Open Uneditable Excel

Generally all the content contained in the Microsoft Excel application you can edit easily. But the problem is when the file only displays features Read Only. The existence of this feature makes you need a way to open Excel that cannot be edited. Of course, you can open this feature so that the content in the file can be edited.

Unlike Microsoft Word, users can simply disable this feature by enabling Editing. In Microsoft Excel, you need to do this by entering the script code through the module window. Below is a method that you can use to open non-editable Excel.

How to Open Uneditable Excel

  1. The first step you need to do is open an Excel file that is protected or cannot be edited.
  2. After the file opens, press the key combination between ”ALT and F11” at the same time on the keyboard for the Windows operating system.
  3. Then a new window will appear in the form of Visual Basic Script or VBS.
  4. In this view, you can select the menu Insert on the top left.
  5. Then, select the option Module so that you can enter a script to open the excel file.
  6. The script code that you can input can be as below.
Sub InternalPasswords()Dim i As Integer, j As Integer, k As IntegerDim l As Integer, m As Integer, n As IntegerDim i1 As Integer, i2 As Integer, i3 As IntegerDim i4 As Integer, i5 As Integer, i6 As IntegerOn Error Resume NextFor i = 65 To 66: For j = 65 To 66: For k = 65 To 66For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126ActiveWorkbook.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)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 ActiveWorkbook.ProtectStructure = False ThenIf ActiveWorkbook.ProtectWindows = False ThenIf ActiveSheet.ProtectContents = False ThenExit SubEnd IfEnd IfEnd IfNext: Next: Next: Next: Next: NextNext: Next: Next: Next: Next: NextEnd Sub
  • Just copy and paste the command above on the module page.
  • If you have, then you can click the Sheet or Workbook that you want to open the password for. Generally the position of this Sheet is on the left side of Visual Basic Script. In addition, there are also file titles that are protected or cannot be opened.
  • Next, you can save the script by selecting the File menu, then selecting the Save option.
  • After the file is saved, then you can close the file and open a protected worksheet or excel file.
  • In the excel file view, you can select the Macro menu, then Show Macro, then go to Internal Password, and do Run.
  • Next, you can wait until the Excel file is successfully extracted. This process takes time which varies depending on the size of the Excel file.
  • If it is finished, then you can edit the file freely.

Also read: How to Translate Document Files in Google Translate

With this method, you don’t have to wait for a password to open Sheet protection in Microsoft Excel. In addition, this non-editable way of opening Excel can be your best alternative to using Unprotect Sheet.