CARA MEMBUKA FILE EXCEL YANG DIPROTECT TANPA SOFTWARE

Have you ever found yourself in a situation where you can’t open an Excel file because it has been locked or protected with a password that you don’t know? Well, worry no more as we have compiled some useful tips and tricks to help you unlock and access your protected Excel file.

Cara membuka file Excel yang dikunci / dilindungi

If you encounter a password-locked Excel file, the first thing that you can try is to use a password hint, if it is available. Often, people use simple and easy-to-remember passwords, and their hints can be helpful in unlocking the file. In case the password hint doesn’t work, you can try the following methods:

1. Use an Online Tool

There are several online tools that can help you unlock password-protected Excel files. All you need to do is upload your file to the website and wait for the tool to process it. Once the tool has finished, you can download the unlocked file to your device.

Some popular online tools include CrackMyPDF, FreeMyPDF, and Online PDF Unlocker. However, keep in mind that uploading sensitive information to an online tool can be risky. Make sure to choose a reputable and trustworthy website that guarantees the safety of your data.

2. Use a VBA Macro

If you are familiar with Visual Basic for Applications (VBA), you can use a macro to unlock your Excel file. A macro is a script that automates repetitive tasks in Excel. You can use a macro to remove the password protection from your file. Here’s how:

1. Open your password-protected Excel file and press ALT + F11 to open the VBA editor.
2. Click on ‘Insert’ from the menu and select ‘Module’.
3. 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 Sub
       

4. Press F5 or click on ‘Run’ to execute the macro.
5. A pop-up box will appear with a message that one usable password has been found. Note it down and use it to unlock your file.

Cara Membuka Password File Excel

Another method that you can use to access your password-protected Excel file is to remove the password altogether. Here are some ways to do it:

1. Use “Save As” Feature

You can use the “Save As” feature to create an unprotected copy of your password-protected Excel file. Here’s how:

1. Open your password-protected Excel file and enter the password to access it.
2. Click on ‘File’ from the top menu and select ‘Save As’.
3. In the ‘Save As’ dialog box, select the file format as “Excel Workbook (*.xlsx)”.
4. Choose a destination folder and filename for your new file and click on ‘Save’.
5. The new file will be saved to your selected location and will no longer be password-protected.

2. Use ZIP Compression

You can also use the ZIP compression feature to remove the password protection from your Excel file. Here’s how:

1. Right-click on your password-protected Excel file and select ‘Rename’.
2. Change the file extension from “.xlsx” to “.zip”.
3. Press ‘Enter’ to confirm the change.
4. Double-click on the renamed file to open the compressed folder.
5. Inside the compressed folder, navigate to the ‘xl’ folder and open it.
6. Delete the ‘workbook.xml’ file.
7. Close the compressed folder and rename it back to its original extension of “.xlsx”.
8. Double-click on the file to open it and you will find that the password protection has been removed.

FAQ

1. Can I use these methods to unlock any Excel file?

These methods are applicable to Excel files that are password-protected. If the Excel file is not password-protected, you do not need to use these methods.

2. Is it legal to use these methods to unlock an Excel file?

If the Excel file belongs to you and you have forgotten or lost the password, then it is legal to use these methods to unlock it. However, if the Excel file belongs to someone else, then using these methods without their permission might be illegal and could result in legal consequences.