CARA KASIH PASSWORD FILE EXCEL

Excel is a versatile tool that is used by many people to manage and analyze data. However, there are times when Excel files are password-protected to prevent unauthorized access. If you have ever found yourself in a situation where you need to access a password-protected Excel file but you don’t know the password, then you have come to the right place. In this article, we will discuss some ways to unlock password-protected Excel files.

Cara membuka password file excel tanpa software

If you have forgotten the password to your Excel file, don’t worry as there is a way to unlock it without using any third-party software. Follow these steps to unlock your password-protected Excel file:

  1. Open the password-protected Excel file.
  2. Press Alt + F11 to open the Visual Basic Editor.
  3. In the Visual Basic Editor, click on Insert and then click on Module.
  4. Paste the following code into the Module window:
  5. 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
    
  6. Press F5 to run the code.
  7. Wait for the code to finish running. This may take several minutes depending on the length of the password.
  8. Once the code finishes running, a message box will appear with the password. Copy the password and use it to unlock your Excel file.
Baca Juga :  Cara Membuat Angka Di Kolom Excel Secara Otomatis

Cara Membuka Password File Excel Yang Terproteksi

If you want to open a password-protected Excel file, follow these steps:

  1. Open the password-protected Excel file.
  2. Click on File and then click on Save As.
  3. In the Save As dialog box, click on the Tools button and then click on General Options.
  4. In the General Options dialog box, delete the password that is in the Password to open field and click OK.
  5. Save the file with a new name.
  6. Close and then reopen the file. The password protection should now be removed and you should be able to access the file without entering a password.

FAQ

What should I do if the code does not work?

If the code does not work, there are a few things you can try:

  • Make sure that you have followed the instructions correctly.
  • Try running the code on a different computer.
  • If the file is protected with a password longer than 12 characters, the code may not work.

Is it ethical to unlock a password-protected Excel file?

It is important to remember that password protection is there for a reason. If you have been given permission to access the file by the owner, then unlocking the file is ethical. However, if you do not have permission to access the file, then unlocking the file is not ethical.

Video Tutorial

Check out this video tutorial for more information on how to unlock password-protected Excel files:

Conclusion

In conclusion, unlocking password-protected Excel files can be done without using any third-party software. However, it is important to remember that password protection is there for a reason, and if you do not have permission to access the file, then unlocking the file is not ethical. Always make sure to get permission from the owner before attempting to unlock a password-protected Excel file.

Baca Juga :  CARA MENGGABUNGKAN FILE WORD DAN EXCEL KE PDF