CARA MEMBUKA FILE EXCEL BINARY WORKSHEET

Microsoft Excel is a popular spreadsheet program used by millions of people all around the world. It offers a variety of features that make it useful for both personal and professional purposes. However, sometimes we may encounter situations where we need to unlock an Excel file that has been locked or protected, either because we forgot the password or we received it from someone else. In this article, we will discuss how to unlock a locked Excel file without using any third-party software, including some frequently asked questions about Excel file protection.

How to Unlock an Excel File?

If you have forgotten the password for an Excel file, you can still unlock it by using some built-in features of Excel. Here are the steps you need to follow:

Method 1: Using an XML Editor

1. Change the file extension to .zip by renaming the file.
2. Unzip or extract the contents of the .zip file using a file archiving software such as WinZip or WinRAR.
3. Open the extracted folder and locate the ‘xl’ folder.
4. Inside the ‘xl’ folder, look for a file named ‘workbook.xml’ and open it using an XML editor (e.g. Notepad++).
5. Find the element ‘<workbookProtection>’ and delete it.
6. Save the file and close it.
7. Rezip or compress the extracted folder into a .zip file.
8. Rename the .zip file extension back to .xlsx or .xls.

Your Excel file should now be unlocked and you can open it without entering any password.

Method 2: Using a Macro

If you are unable to follow the above method, you can try using a macro to unlock the Excel file. Here’s how:

1. Open your Excel file and press ‘Alt + F11’ to open the VBA editor.
2. Click ‘Insert -> Module’ to create a new module.
3. Paste the following VBA code into the module.

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 = 97 To 122: For n = 32 To 126
        ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
        Chr(l) & Chr(m) & i1 & i2 & i3 & i4 & 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) & i1 & i2 & i3 & _
            i4 & 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’ to execute the macro.
5. The macro will generate a usable password for you.
6. Use this password to unlock your Excel file.

Note: this method may take some time to generate a usable password depending on the complexity of your original password.

Protecting an Excel File

Now that we have discussed how to unlock an Excel file, let’s take a look at how to protect an Excel file to prevent unauthorized access.

Method 1: Using a Password

You can protect your Excel file by adding a password to it. Here are the steps you need to follow:

1. Open your Excel file and click ‘File -> Info -> Protect Workbook -> Encrypt with Password’.
2. Enter a password and click ‘OK’.
3. Confirm the password and click ‘OK’.
4. Save the file.

Note: please use a strong password that is difficult to guess or crack.

Method 2: Restricting Editing

You can also prevent others from editing your Excel file by restricting editing. Here’s how:

1. Open your Excel file and click ‘Review -> Protect Workbook -> Restrict Editing’.
2. In the ‘Restrict Editing’ pane, select the ‘Allow only this type of editing in the document’ check box.
3. Select the ‘No changes (Read only)’ option in the drop-down list.
4. Click ‘Yes, Start Enforcing Protection’.
5. Enter a password and click ‘OK’.
6. Confirm the password and click ‘OK’.
7. Save the file.

Now your Excel file is protected and can only be opened or edited by someone who knows the password or has permission to make changes.

FAQ

Q1: Can I unlock an Excel file without using any third-party software?

A: Yes, you can unlock an Excel file by using some built-in features of Excel, such as an XML editor or a macro.

Q2: What should I do if I forget the password for an Excel file?

A: You can try using an XML editor or a macro to remove the password protection from the Excel file. If these methods do not work, you can use a third-party password recovery tool.

Conclusion

Unlocking and protecting an Excel file is an important skill that can be useful in various situations. By using the methods discussed in this article, you can unlock a locked Excel file without using any third-party software, and protect your Excel files from unauthorized access or editing. If you have any questions or suggestions, feel free to leave a comment below. Also, don’t forget to check out this helpful video tutorial on Excel file protection: