CARA MEMBUKA FILE EXCEL YANG DI HIDDEN

Have you ever found yourself trying to open an Excel file but it’s locked with a password? It can be frustrating, especially if you urgently need to access the data within. But don’t worry, there are ways to unlock Excel files without software and we’re here to guide you through them.

How to Unlock Excel Files Without Software

Excel files can be protected in various ways including password protection, read-only restriction, and workbook structure protection. Here are some ways to unlock Excel files without the use of software.

Method 1: Using Google Sheets

One way to unlock Excel files is by converting them to Google Sheets. Follow these steps:

1. Open Google Drive in your web browser and sign in to your account.
2. Click the “New” button and select “File upload”.
3. Select the locked Excel file you want to unlock.
4. Right-click the uploaded file in Google Drive and select “Open with” followed by “Google Sheets”.
5. The Excel file will now be converted to a Google Sheets file, and you’ll be able to access it without any password restrictions.

Please note that some formatting may be lost in the conversion process, so you may need to format the sheet manually.

Method 2: Using VBA Code

Another way to unlock Excel files is by using VBA (Visual Basic for Applications) code. This method is more advanced but effective. Follow these steps:

1. Open the locked Excel file and press “Alt + F11” to open the VBA editor window.
2. Double-click the sheet you want to unlock in the left panel of the VBA editor. If the sheet is hidden, right-click any sheet tab and select “Unhide” to show it.
3. Copy and paste the following code into the sheet module:

   Sub PasswordBreaker()
       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 to run the code. A message box will appear with the unlocked password.
5. Close the VBA editor window and enter the password to unlock the sheet.

Please note that this method may not work for all Excel files, especially those that have strong passwords or were created in newer versions of Excel.

FAQs

Q: I forgot the password of my Excel file, what should I do?

A: Try using the VBA code method as described above. It may take some time, but it’s worth a shot. If that doesn’t work, you may need to use third-party software to recover the password.

Q: Can I remove the password protection from an Excel file permanently?

A: Yes, you can remove the password protection from an Excel file permanently. Open the file, go to the “Review” tab, click “Protect Workbook” or “Protect Sheet”, and then select “Unprotect Workbook” or “Unprotect Sheet” depending on the option you originally used. Enter the password if prompted, and the file will be unprotected.

Watch this Video Tutorial on How to Unlock Excel Files Without Software

Check out this video tutorial by Kevin Stratvert on how to unlock Excel files without software.