Well on this occasion we will provide an easy way to open a locked Excel password.
Microsoft Excel is an application that is often used to create financial and other reports.
But Excel suddenly locked, this is because the sender forgot to send the password or password.
Even though Excel files are very important for a job or task to count money and calculate other things.
There are types of Excel files that are confidential and should only be known or opened by important or certain people.
Therefore, if you are experiencing problems like the discussion above, you can listen to our explanation below for how to open an excel password.
How to Open Excel Password
1. How to Open Excel Password Without Application
 |
| How to Open Excel Password Without Application |
Now for those of you who want to open an Excel password, then you can use this first method without an application.
Here’s how to open an Excel password without an application:
- First you open an Excel file that is locked or protected by a password or password.
- Then you press (Alt + F11) on your keyboard and then wait a few moments until “Microsoft Visual Basic.
- Next, please select the “Insert” menu and also select “Moduke” to be able to open the module menu.
- If you have then on your device screen a module menu will appear.
- Then you enter and copy the code below into the module menu.
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 NextFor 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 you have copied or copied the text above, then you can paste it into the module.
- After that you select which sheet you want to open in the Excel file and select also “run macro”.
- If the pop up window on “Marco” has been opened, then click “Run” to start the process of cracking the Excel password.
- Wait a few moments until the break-in process is complete.
- If the break-in process is complete, then you can open or change the Excel data file freely.
2. How to Open Excel Password With Zip
 |
| How to Open Excel Password With Zip |
The second method that you can use to unlock Excel that has forgotten the password or password.
But if you want to use this method, you must first have an application called WinRAR or a 7-zip application that you can download for free.
You can download the application via the following link (Download the WinRAR Application) and (Download the 7-zip App).
If you have downloaded and installed the two additional applications, then you can listen to the tutorial below.
Here’s How to open an Excel password with ZIP:
- First you open the Excel file for which you forgot the password so that Excel is locked.
- If you have then you can click “View” on the menu and put a check mark on the “File Name Extension” section.
- Then in the Excel file format, you have to change it from .xlsx to .zip click enter or yes.
- After that you open the excel file using the ZIP application, and change the naa format of your file from .xml to .txt.
- Next you open the file with the notepat application then you find the code “
- Then if a notification appears then you can click yes.
- Finally, you return the Excel file format to .xml and close the ZIP application, then you change the format to .xlsx as before.
- Finished.
The final word
Those are two ways that you can use or you can use to open Excel passwords on your computer.
So that the process of opening the Excel password is successful, we remind you that you follow the above method correctly and sequentially.
Hopefully with the explanation above can help you to open the password or Excel password.
For more details, you can continue to listen to our website so you don’t miss other exciting and interesting information.
This is the entire contents of our discussion this time about the article How to Open Excel Password. That is all and thank you.
