How to open Password Protected Excel File

How to open Password Protected Excel File

Posted on

Have you ever experienced that you can’t open an Excel file because it uses password protection? You must know How to open Password Protected Excel File in order to be able to open it when you need it at any time.

Microsoft Excel is a software developed by the Microsoft company which is often used to process worksheets in the form of numbers. Most of them use it to calculate and record financial data of a company.

Excel files can also be given a password so that not everyone can make changes to data. If an Excel file has been given a password or Protect Sheet, then anyone will not be able to change the excel file unless they know the password of the excel file.

The password feature in the Excel file is very useful, but have you ever thought that one day you forgot what your Excel password was? Even though the excel file is very important and you have to make changes or edit the excel file.

No need to panic, there are still ways to easily How to open Password Protected Excel File. You don’t even need to use the help of other software. It is enough to use Microsoft Excel to be able to open a protected excel file.

How to Open a Password Protected Excel File

How to open Password Protected Excel File will use the example in Microsoft Excel 2013. If you are using another version above or below, you can simply adjust because basically, it will not be much different.

To open Excel passwords yourself, there are two ways you can try. You don’t need to use any software to be able to unprotect the Excel file you want.

Also Read: How to Remove Red Underline in Word 2020, 2016, 2010, 2007, 2003

The first is that you can open the excel file directly without requiring a password. And for the second method, you can find out and display the passwords used in the excel file.

How to Open Excel Password

One sign of a password-protected or password-protected excel file is when you double-click on the worksheet, a warning will appear as shown below.

unprotect excel workbook without password

If you don’t know what password was used in the Excel file, follow the steps to unlock the Excel password below:

  • Open an Excel file that is protected or password protected.
  • Press Alt + F11 on the keyboard to bring up Microsoft Visual Basic.
  • Click on the Insert menu and select Module.
unlock password protected excel file online free
  • The module form will appear, you must copy the following code into the module form.

Sub InternalPasswords ()
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
ActiveWorkbook.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 Then
If ActiveWorkbook.ProtectWindows = False Then
If ActiveSheet.ProtectContents = False Then
Exit Sub
End If
End If
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next

excel password remover free
  • Select the Sheet that you want to open. For example select Sheet 1 and then click the Run Macro icon or press the F5 key.
  • A Macros dialog box will appear and then click Run.
how to remove password from excel file when opening file

Just wait until the process of opening Excel is complete. The time it takes to process depends on the size of your excel file. So, the smaller the size and the fewer data in it, the faster the process is needed.

Also Read: How to Create a Watermark and Remove in Word

Sometimes if the excel file is very large, usually the excel software will not respond. But you don’t need to worry, even so, the excel file will still be protected.

Bring up the Excel Password

The second way is to show what password is used in the protected excel file. After you know what password is used in the excel file, you can Unprotect the sheet in the excel file as usual.

How to generate an Excel file password is not much different from the first way to open an Excel file. However, you must use the following code below to enter the module form.

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

If you have entered the code above into the module form, wait for the process to complete. After you have managed to get the excel password, close Microsoft Visual Basic.

Then to open it, when on the Excel page select the Review menu option then click the Unprotect Password option. And finally, enter the excel password that matches the password that you got.

Also Read: How to Recover Facebook Password Without Email and Phone Number

So, those are two way How to open Password Protected Excel File. You can open it directly or find out what the password is first. Choose according to your wishes.

One thought on “How to open Password Protected Excel File

Leave a Reply

Your email address will not be published. Required fields are marked *