Lompat ke konten Lompat ke sidebar Lompat ke footer

How to Unlock Password Protected Excel Files

Are you having problems with excel files that can’t be opened because they are locked by a password? This article is really the answer, because we will provide steps on how to easily open an excel password.

This is what happens to us sometimes. It could happen because the sender forgot the password or was deliberately not notified, even though the excel file is very important for work or for assignments. However, it is also possible that the file is confidential which can only be opened and known by certain people.

Well, don’t worry if you are experiencing problems like that, we will provide a solution that hopefully can be understood by all of you. Without further ado, we will share how to open an excel file password.

Here’s How To Easily Open Excel Password Without An Application

  • First, please open the locked or password protected Excel file.
  • if you have, then my friend press the key combination Alt+F11 on the keyboard, then it will automatically appear Microsoft Visual Basic.
how to open excel password
  • If it appears, here, please, my friend, select the menu Insert
  • Next, my friend, choose Module to be able to open the module menu.
  • Later on your screen, the module menu will appear. What is next?
unlock excel password
  • Here, please copy the following code and enter it into the module menu.

Here’s the source code that you have to copy

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
End Sub

  • If it has been copied, then paste it into the module menu. The display will look like below
how to open excel password
  • If so, my friend, please select the Sheet you want to open in the left panel. Then you press the button F5. Later, a Macro dialog box will appear and of course you select the button Run.
  • Yup! You just have to wait until the process is complete. Here Long or fast processing time depends on the size of the file and a lot of data in the file, yes!
  • Finally, Click OK on the window pop-upPassword The new password will be displayed, but you don’t need to write it down. Click “OK” to lift the protection on the worksheet automatically.

How? Pretty easy isn’t it the way to open a locked excel password?

Also Read: How to Open Enc File Files

The final word

Well maybe the discussion above is how to open an excel password that we can provide for you. Hopefully this method still works and can also be understood by my friend. But if you have another way to open a locked excel file, it’s really okay to share it with all of us so we can both find out other ways. Ok, good luck and good luck! ?

Posting Komentar untuk "How to Unlock Password Protected Excel Files"