CARA MENGHAPUS PASSWORD EXCEL

Excel is an essential tool for many people, used to store, analyze, and present data in various formats. However, one of the downsides of using Excel is that it requires a password to access your work. Whether it’s to protect sensitive data or to prevent unauthorized access, password-protected Excel files can sometimes become an inconvenience. In this article, we’ll explore how to remove a password from an Excel file using different methods.

Method 1: Using a Password Remover Application

One of the most straightforward methods for removing a password from Excel is by using a specialized password remover application. These applications can be downloaded for free from various websites, and they offer a quick and easy way to remove passwords from Excel files.

To use a password remover application, simply download and install it onto your computer. Once installed, follow these steps:

  1. Open the password remover application
  2. Click on “Open” and select the Excel document you want to remove the password from.
  3. Click on “Remove Password” or “Unprotect Sheet” depending on the application’s interface.
  4. The application will now remove the password from the Excel file, and you should be able to access it without any issues.

Method 2: Using VBA Code to Remove the Password

If you prefer to use Excel’s built-in tools to remove the password, you can do so by using the Visual Basic for Applications (VBA) code. The VBA code is a programming language that can be used to automate repetitive tasks in Excel, and it can also be used to remove passwords from Excel files.

Baca Juga :  Cara Membuat Angka Menjadi Huruf Di Excel 2007

Here’s how to remove the password using VBA code:

  1. Open the Excel file you want to remove the password from.
  2. Press “Alt” + “F11” to open the Visual Basic Editor.
  3. Click on “Insert” from the menu bar and select “Module.”
  4. Copy and paste the following code into the module:
  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) & i1 & i2 & i3 & i4 & i5 & 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 & 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. If the password is successfully removed, an alert box will appear with the password.

FAQ

Q: Can I remove the password from an Excel file without using an application or VBA code?

A: Yes, you can remove the password from an Excel file without using an application or VBA code. One method is to try and guess the password by trying different combinations of characters. Another method is to use online password removers, which can be found by doing a simple Google search.

Baca Juga :  Cara Membuat Rumus Dalam Excel

Q: Can I remove the password from an Excel file without knowing the password?

A: Yes, you can remove the password from an Excel file without knowing the password. One method is to use a specialized password remover application, as mentioned earlier. Another method is to use VBA code, which can remove the password without the need for the actual password.

Video Tutorial

For those who prefer visual aids, the following video tutorial demonstrates how to remove passwords from Excel files:

Conclusion

Removing passwords from Excel files can be a simple and quick process, whether by using a specialized application or VBA code. As with any sensitive data, it’s always recommended to use strong passwords and keep them in a secure location.