Unlock Excel Passwords: Removing Sheet Security

Buzz

Step 2. Open the Visual Basic Editor.

* For Excel 2003: To open the Visual Basic Editor, go to the Tools menu, select Macro , and choose Visual Basic Editor. (Download Office 2003)
* For Excel 2007, 2010, 2013: To open the Visual Basic Editor, use the shortcut Alt + F11

Download Excel 2007
Download Excel 2010
Download Excel 2013

Note: If you can't see the Sheets, press: Ctrl + R to display the Sheets.

Click the mouse on the Sheet you want to open the password. For example, I want to open the password for Sheet 'qly diem thi' and it is Sheet number 2, I choose Sheet 2 (qly diem thi).

Step 3. Copy the password-breaking code

Copy the code below to break the password for your Excel Sheet.

Sub PasswordBreaker() If ActiveSheet.ProtectContents = False Then MsgBox "Sheet '" & ActiveSheet.Name & "' is unprotected!", vbInformation Else If MsgBox("Sheet '" & ActiveSheet.Name & "' is protected, do you want to unprotect it?", _ vbYesNo + vbQuestion, "Unprotect Active Sheet") = vbNo Then Exit Sub 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) Next: Next: Next: Next: Next: Next Next: Next: Next: Next: Next: Next If ActiveSheet.ProtectContents = False Then MsgBox "Sheet '" & ActiveSheet.Name & "' is unprotected!", vbInformation End If End Sub

After copying the code, paste it into the Visual Basic Editor. From the Run menu =>Run Sub/UserForm (or press F5) to execute the command.

Quick guide to break Excel passwords efficiently

2. Unlock Excel File Password with iSumsoft Excel Password Refixer Software

Step 1: Download the iSumsoft Excel Password Refixer software to your computer HERE, then proceed with the normal installation.

Step 2: Launch the software and add the Excel file you want to unlock by clicking Open => navigate to the Excel file.

Step 3: Next, choose the method to unlock the Excel file password (Type of Attack), there are 4 methods available.

Brute-Force Method

Use the Brute-Force method when you have no clue about the Excel file password. This method will try all possible combinations to recover the password. However, you need to set the password range and length to enhance the password recovery chances.

Mask Method

Use this method if you can remember some characters of the password. Set the range and length for the method, then choose Mask to specify the password, using the symbol '?' to represent the unknown characters.

Dictionary Method

If you've ever noted your password somewhere but can't recall which one it is, you can use this method. It quickly retrieves the password for you.

Smart Method

If you've set an overly complex password that you can't remember anything about, this is an attack method you should use.

Step 4: Unlock the Excel file password

- Click the Start button to begin; the system will proceed to recover the password, and the completion time will depend on the password complexity.

- Once completed, the system will notify you of the password; simply copy and save it to open your Excel file.

3. Unlock Excel File Password with iSumsoft Excel Password Remover Software

If you want to completely remove the password from an Excel file, this software is designed for you. The software only supports *.xls Excel file formats.

Step 1: Download the iSumsoft Excel Password Remover software to your computer HERE, then install the software as usual.

Step 2: Click on Open to open the Excel file you want to remove the password from.

Step 3: Click on Remove Password to proceed with removing the password from the Excel file.

Step 4: After the process is complete, you can use the Excel file as usual.

The Excel password removal process is underway; wait until the system announces: Sheet 'file name' is unprotected, indicating that your Excel Sheet password has been successfully removed. This is a quick method to unlock any Sheet in Excel. If you want to remove the password for the entire file, follow a different approach. While setting a password for an Excel file ensures data security, it can also be inconvenient and troublesome when forgotten. Therefore, readers, consider carefully or store passwords in a secure and memorable place.

Mytour's content is for customer care and travel encouragement only, and we are not responsible.

For errors or inappropriate content, please contact us at: [email protected]