Excel spreadsheets provide an array of powerful tools for organizing, analyzing, and presenting data. However, protecting sensitive data or preventing accidental modifications may lead to a password-protected Excel file. If you find yourself locked out of an Excel spreadsheet, fear not! In this step-by-step guide, we will walk you through the process of unlocking an Excel spreadsheet.

Step 1: Open the Excel Spreadsheet

The first step is to open the Excel spreadsheet you wish to unlock. Simply locate the file on your computer or cloud storage, double-click to open it, and Excel will launch automatically.

Step 2: Access the Review Tab

Once the Excel spreadsheet is open, navigate to the “Review” tab on the Excel ribbon at the top of the window. Click on the “Review” tab to access the related options.

Step 3: Click on “Unprotect Sheet”

Under the “Review” tab, you will notice various options and functionalities. Look for the “Changes” group, and within it, you will find the “Unprotect Sheet” button. Click on this button to begin the unlocking process.

Step 4: Enter the Password

A dialog box will appear, prompting you to enter the password for the locked spreadsheet. If you know the password, enter it into the text field. However, if you do not know the password, proceed to the next step.

Step 5: Use VBA Code to Unlock the Spreadsheet

If you do not know the password to unlock the Excel spreadsheet, you can utilize a VBA code to bypass the password protection. Here’s how:

  • Press “Alt + F11” to open the Visual Basic for Applications (VBA) editor.
  • Click on “Insert” in the top menu bar, then select “Module.”
  • Copy and paste the following VBA code into the blank module:

Sub PasswordRecovery()
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

After you’ve pasted the code, close the VBA editor by clicking on the “X” in the top-right corner or pressing “Alt + Q”.

Step 6: Run the VBA Code

To execute the VBA code and unlock the Excel spreadsheet, follow these steps:

  • Click on “Developer” in the Excel ribbon.
  • Click on “Macros” in the “Code” group.
  • Select the “PasswordRecovery” macro and click on “Run”.
  • If the code runs successfully, it will display a usable password.

Step 7: Access the Unprotected Excel Spreadsheet

After obtaining the usable password, close the VBA editor, and return to the Excel spreadsheet. Enter the password into the dialog box and click “OK”. Congratulations! You have successfully unlocked the Excel spreadsheet.

Remember to save an unprotected version of the Excel spreadsheet under a new name to avoid losing the password in the future.

Unlocking an Excel spreadsheet doesn’t have to be a daunting task. By following this step-by-step guide, you can gain access to password-protected Excel files in no time. Excel’s built-in functionality and the clever utilization of VBA code ensure that you can handle any locked spreadsheet that comes your way!

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!