Microsoft Excel is one of the most widely used applications for handling financial data. With its wide range of features, Excel has made it possible for businesses to manage their data in an organized manner. However, sometimes we tend to forget the password we set to keep our Excel files safe. In such cases, it can become difficult to access your Excel data, but don’t worry, there is a way to unlock your Excel file and continue your work.
Cara Membuka File Excel yang Terkunci
If you are facing difficulty in opening your locked Excel file, there is no need to panic. In this article, we will guide you with some simple steps that will help you to unlock your protected Excel file without any loss of data. Follow the below-mentioned steps:
Step 1: Open the protected Excel file
The first step is to open the locked Excel file. When you try to open the file, it will prompt you to enter a password. But since you have forgotten the password, you cannot access the file. But there is a way around it.
Step 2: Open the VBA Editor
Now press Alt + F11 to open the VBA editor. This action will open the Visual Basic for Applications Editor window.
Step 3: Enter the module to remove the password
Now click on “Insert” and select “Module”. A new module will appear on the right side.
Step 4: Enter the Password Remover Code
Now, paste the following code:
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 SubStep 5: Run the Code
Now click on “Run” (the triangle icon) or press F5 to run the code. The code will take some time to execute and finally, a message will appear with the usable password.
Step 6: Use the Usable Password
Now, use this password to unlock your Excel file. Congratulations! You have successfully unlocked your locked Excel file.
Cara Membuka File Excel yang Terkunci Tanpa Aplikasi
If you don’t want to install any third-party tool to unlock your Excel file, there is still another way to do it. In this method, we will use a Notepad to break the password on the Excel file. Follow the steps given below:
Step 1: Open the Excel File in Notepad
First, close all Excel files and open Notepad. Now, drag and drop the protected Excel file into the Notepad window or you can go to “File” and select “Open” to open the file in Notepad.
Step 2: Find the Password Parameter
Once the file is open in Notepad, search for the line “<sheetProtection password=”xxxxxxxxxxxxxxxx” sheet=”1″/>” where the “xxxxxxxxxxxxxxxx” are 15 random characters that represent the password.
Step 3: Remove the Password Parameter
Delete the “xxxxxxxxxxxxxxxx” section and save the file by pressing “Ctrl + S”.
Step 4: Open the File in Excel
Now, close Notepad and open the Excel file. The password protection will be removed, and you can easily view the file without any password.
FAQ
1. Can I lose my data while unlocking the password-protected Excel file?
No, you will not lose any data while unlocking the password-protected Excel file using the methods mentioned above. These methods are safe and reliable as they do not alter any data in the file.
2. Is there any other way to unlock my password-protected Excel file?
Yes, there are various third-party tools available that can help you unlock your password-protected Excel file. You can search for them on the Internet, but we suggest you use the methods mentioned above, as they are safe and effective.
Video Youtube: How to Unlock Password Protected Excel File?
Watch the video below to get a clear understanding of how to unlock a password-protected Excel file using the two methods mentioned in this article:
