Do you have an Excel file that is password-protected and you need to remove the password? Luckily, there are several easy ways to accomplish this task. In this blog post, we will guide you through some effortless methods to remove passwords from Excel files. Let’s get started!

Method 1: Using Excel’s Unprotect Sheet Option

The first method we recommend is using Excel’s built-in “Unprotect Sheet” option. Here’s how you can do it:

  • Open the Excel file that is password-protected.
  • Go to the “Review” tab in the Excel menu.
  • Click on the “Unprotect Sheet” button.
  • Enter the password when prompted.
  • Voila! The password protection on the Excel file is now removed.

Method 2: Removing Passwords using VBA Code

If the first method doesn’t work for you or if the “Unprotect Sheet” option is grayed out, you can try removing the password using VBA code. Follow these steps:

  • Open the Excel file.
  • Press “Alt + F11” to open the Visual Basic for Applications (VBA) editor.
  • In the VBA editor, click on “Insert” and then choose “Module” to insert a new module.
  • Paste the following VBA code into the module:

    Sub PasswordBreaker()
    Dim i As Integer, j As Integer, k As Integer
    Dim l As Integer, m As Integer, n 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
  • Press “F5” to run the code.
  • Wait for a few minutes while the code tries to crack the password.
  • If successful, a message box will appear with the usable password.

Method 3: Using Third-Party Software

If both the previous methods fail, you can resort to using third-party software to remove the password from Excel files. There are several reliable tools available on the internet that can quickly and efficiently remove passwords from Excel files. Some popular options include Passper for Excel, iSunshare Excel Password Remover, and Excel Password Recovery. Make sure to choose a trusted software tailored to your needs.

With these effortless methods at your disposal, you can easily remove passwords from Excel files without any hassle. Just remember to use them responsibly and only on files that you have the permission to access. Happy Excel editing!

Quest'articolo è stato scritto a titolo esclusivamente informativo e di divulgazione. Per esso non è possibile garantire che sia esente da errori o inesattezze, per cui l’amministratore di questo Sito non assume alcuna responsabilità come indicato nelle note legali pubblicate in Termini e Condizioni
Quanto è stato utile questo articolo?
0Vota per primo questo articolo!