CARA EDIT FILE EXCEL 2010 YANG DIPROTECT

Excel is a widely used software for data processing and analysis. However, sometimes we encounter situations where we need to open an Excel file, but it is password protected. It might be a frustrating experience as we are unable to access the data. In this article, we will discuss some ways to open password-protected Excel files without using any software.

Baca Cepat show

CARA EDIT FILE EXCEL 2010 YANG DIPROTECT Cara Membuka File Excel yang Terkunci Tanpa Aplikasi

If you are unable to open an Excel file because it is password protected, do not worry. You can open the file using simple techniques. Here are a few methods to open password-protected Excel files:

Method 1: Use Google Sheets

We all know that Google Sheets is an alternative to Microsoft Excel. You can use Google Sheets to open password-protected Excel files. Here are the steps:

  1. Open Google Drive and upload the password-protected Excel file.
  2. Double-click the uploaded file to open it with Google Sheets.
  3. Enter the password to unlock the file.
  4. Once you have entered the password, you can save the file in Google Sheets or download it as an Excel file.

Method 2: Use the Excel Viewer

Another option to view password-protected Excel files is to use the Excel Viewer. Here are the steps:

  1. Download and install the Excel Viewer from the Microsoft website.
  2. Launch the Excel Viewer and open the password-protected Excel file.
  3. The Excel Viewer will prompt you to enter the password to unlock the file. Once you have entered the password, you can view the file.
Baca Juga :  CARA MEMBUAT MACRO EXCEL 2007

Cara Membuka Password File Excel Yang Diprotect Cara Membuka Password File Excel Yang Diprotect

Excel files can also be password protected at the sheet level. In such cases, you can protect or unprotect the Excel sheet. Here are some methods to open password-protected Excel sheets:

Method 1: Unprotect Excel Sheet

If you know the password to the Excel sheet, you can unprotect the sheet by following these steps:

  1. Open the Excel sheet that is password protected.
  2. Click on the “Review” tab in the ribbon menu.
  3. Click on “Unprotect Sheet.”
  4. Enter the password in the dialogue box and click “OK.”

Method 2: Use VBA Code

If you do not know the password to the Excel sheet, you can use VBA code to unprotect the sheet. Follow these steps:

  1. Open the Excel sheet that is password protected.
  2. Press “Alt + F11” to open the Visual Basic Editor.
  3. Click on “Insert” and then “Module” to create a new module.
  4. Enter the following code in the module:
    5. 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) & 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
  5. Press “F5” to run the code.
  6. The code will loop through all possible passwords to find the one that works. Once the password is found, the sheet will be unprotected.
Baca Juga :  Cara Menghitung Melalui Ms Excel 2010

Cara membuka cell excel yang diprotect password tanpa software Cara membuka cell excel yang diprotect password tanpa software

Sometimes, only certain cells in an Excel sheet are password protected. You can follow these steps to unprotect the cells:

  1. Open the Excel sheet that contains the protected cells.
  2. Select the cells that you want to unprotect.
  3. Right-click on the selected cells and click on “Format Cells.”
  4. In the “Protection” tab, uncheck the “Locked” option.
  5. Click “OK.”
  6. Click “Review” in the ribbon menu and then click on “Protect Sheet.”
  7. Enter a password (optional) and click “OK.”

Cara Membuka Password File Excel Yang Diprotect Cara Mengetahui Password Excel yang Diprotect

Sometimes, we forget the password of a password-protected Excel file. It might seem impossible to open the file, but there are ways to recover the password. Here are a few methods to recover the password of an Excel file:

Method 1: Use the “Forgot Password” Option

If you have forgotten the password of an Excel file, you can use the “Forgot Password” option. Follow these steps:

  1. Open the password-protected Excel file.
  2. Click on “File” and then “Protect Workbook.”
  3. Select “Encrypt with Password.”
  4. Delete the existing password and click “OK.”
  5. Save the file. The password will be removed.

Method 2: Use a Password Recovery Tool

If you are unable to recover the password using the “Forgot Password” option, you can use password recovery tools. Follow these steps:

  1. Download and install a password recovery tool like Passper for Excel or iSunShare Excel Password Genius.
  2. Launch the password recovery tool and select the password-protected Excel file.
  3. Choose the appropriate method to recover the password and wait for the process to complete.
  4. Once the password is recovered, you can use it to open the file.

FAQ

Q1. How do I open a password-protected Excel file on Mac?

To open a password-protected Excel file on Mac, follow these steps:

  1. Click on “File” and then “Open.”
  2. Select the password-protected Excel file and click “Open.”
  3. You will be prompted to enter the password. Enter the password and click “OK.”
  4. You can now access the file.
Baca Juga :  Cara Membuat Rumus Untuk Memanggil Data Di Excel

Q2. Can I remove the password from an Excel file without knowing the password?

Yes, you can remove the password from an Excel file without knowing the password. Follow these steps:

  1. Open the password-protected Excel file.
  2. Press “Alt + F11” to open the Visual Basic Editor.
  3. Click on “Insert” and then “Module” to create a new module.
  4. Enter the following code in the module:
    5. 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) & i1 & i2 & i3 & i4 & i5 & i6 & Chr(n)
        If ActiveSheet.ProtectContents = False Then
            ActiveSheet.EnableSelection = xlUnlockedCells
            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
  5. Press “F5” to run the code.
  6. The code will loop through all possible passwords to find the one that works. Once the password is found, the sheet will be unprotected.

In conclusion, password-protected Excel files can be opened using the methods mentioned in this article. You can use Google Sheets or the Excel Viewer to open password-protected Excel files. You can also unprotect Excel sheets or cells if you know the password or by using VBA code. If you have forgotten the password, you can use the “Forgot Password” option or password recovery tools to recover the password.

Warga.Co.Id
© Copyright 2024, All Rights Reserved