CARA MEMBUKA FILE EXCEL YANG DIPROTECT DI MICROSOFT EXCEL 2016

Opening password-protected Excel files can be a daunting task, especially if you are not familiar with the process. Luckily, there are several ways to unlock these protected files and access the information they contain.

Cara membuka Aplikasi Sheet Excel yang di Protect

If you have encountered a protected Excel file, the first thing you need to do is find out what type of protection has been applied to it. This information will help you choose the appropriate method for unlocking the file.

One common method of protecting Excel files is by using a password. If this is the case, you will need to enter the correct password to access the contents of the file. However, if you do not know the password, there are a few ways to unlock the file without it.

Step One: Open the Password-Protected File

The first step in unlocking a protected Excel file is to open it. Depending on the version of Excel you are using, the process may differ slightly:

  • Excel 2016/2019: Go to the “File” menu and click “Open.” Select the password-protected file from your computer and click “Open.”
  • Excel 2010/2013: Go to the “File” menu and click “Open.” Select the password-protected file from your computer, click the drop-down menu next to “Open,” and select “Open as Read-Only.”
Baca Juga :  CARA CEK FILE DOBEL DI EXCEL

Step Two: Copy the Data from the Password-Protected File

Once you have opened the password-protected file, you will need to copy the data to a new file. This can be done by following these steps:

  1. Click on the “Select All” button to highlight all of the data in the file.
  2. Right-click on the highlighted data and select “Copy.”
  3. Open a new, blank Excel file.
  4. Right-click on cell “A1” and select “Paste.”

Step Three: Save the New File

After you have copied the data from the password-protected file to a new file, you will need to save the new file. This can be done by following these steps:

  1. Click on the “File” menu and select “Save As.”
  2. Enter a name for the new file and choose a location to save it to.
  3. Click on the “Save” button to save the new file.

Once you have saved the new file, you will be able to access the data it contains without the need for a password.

Cara Membuka Password File Excel Yang Diprotect

If the Excel file you are trying to open is password-protected, there are a few methods you can use to unlock it:

Method One: Using an Online Password-Removal Service

One of the easiest ways to unlock a password-protected Excel file is to use an online password-removal service. These services use advanced algorithms to crack the password and unlock the file. Here’s how to use one:

  1. Visit an online password-removal service, such as password-online.com or lostmypass.com.
  2. Upload the password-protected file to the service’s website.
  3. Follow the provided instructions to unlock the file.
Baca Juga :  Cara Mengambil Data Tanggal Di Excel

It’s important to note that using an online password-removal service can be risky, as you are giving the service access to your personal data.

Method Two: Using a VBA Macro

If you are comfortable with programming, you can use a VBA macro to unlock the password-protected Excel file. Here’s how:

  1. Open the password-protected Excel file.
  2. Press “Alt” + “F11” to open the Visual Basic for Applications (VBA) editor.
  3. Click “Insert” and then “Module.”
  4. Paste the following 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 = 65 To 66: For n = 32 To 126
    		ActiveWorkbook.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 ActiveWorkbook.ProtectStructure = False Then
    			MsgBox "Workbook unprotected.", vbInformation, "Password Breaker"
    			Exit Sub
    		End If
    		Next: Next: Next: Next: Next: Next
    		Next: Next: Next: Next: Next: Next
    	End Sub
  5. Click “Run” to execute the macro. If the macro is successful, the worksheet password protection will be removed.
  6. Save the file without a password.

Using a VBA macro can be more complex than using an online password-removal service, but it is a safer option as it doesn’t require you to give access to your personal data.

Baca Juga :  Cara Membuat R Tabel Pada Excel

FAQ:

Q: What if the Excel file is protected with a password and the method above doesn’t work?

A: If the above methods do not work, you may need to use a more advanced password-cracking tool, such as Excel Password Recovery Master or Accent EXCEL Password Recovery. These tools are designed to crack even the most complex passwords and can be downloaded online.

Q: Can I protect my Excel file without a password?

A: Yes, you can protect your Excel file without a password by using the “Encrypt with Password” option. This option will encrypt the file without requiring a password to open it. However, if you want to modify the file, you will need to enter a password.

Video Tutorial:

Conclusion

Unlocking password-protected Excel files is not as difficult as it may seem. By using the right tools and methods, you can easily access the data contained within these files. Whether you choose to use an online password-removal service or a VBA macro, always remember to use caution when accessing personal data online and to follow best practices for data security.