Many people use protection to keep their Excel Sheets safe. There are times when you get a protected Excel sheet, and you do not know the password to access it. You might have lost the password or forgotten it, whatever the reason is. If you can’t access the Excel Sheet that is protected, do not worry about creating a new sheet. There are various ways to unprotect Excel Sheets without passwords. If you want to know how to do it, do not skip this article. We have listed multiple methods to help you solve this problem.
Without any further ado, let’s get started.
You can unprotect the Excel Sheets using the VBA Code. However, it only works on the MS Excel version 2010 and the versions older than this.
Steps to unprotect Excel Sheet
1. Launch the Excel Sheet that is protected by the password. Now, press the ‘ALT‘ key and the ‘F11‘ key to open the Visual Basic Editor.
2. Right-click on the workbook name, this is a Project-VBA window. Now, hit the ‘Insert‘ button and the ‘Module‘ button from the menu.
3. You will notice a window where you need to paste the code that is written below.
‘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
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 “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)
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
After copying the code, tap on the ‘Run’ option, or hit the F5 key and then hang around for some time.
The macro will come back with a fresh password. However, this password is not original to the protected Excel Sheet, but it works fine. There is no requirement of copying the password or trying to remember it. Just tap on the ‘OK’ button, and the protect sheet will be free of protection.
Tips to remember
- If there is more than one protected sheet, run VBA macro for every sheet
- If you have the MS Excel version 2013 or 2016, then save the files like MS Excel 97-2003 workbook along with ‘XLS’ extension. Now, you can run the VBA macro to unprotect your sheets and save the files as .xlsx
This tool is widely used to restore the lost or forgotten password for MS Excel files. Other than this, Passper for Excel removes the restrictions for MS Excel Sheets as well as workbooks.
Passper for Excel gives a guarantee that the data won’t be lost after using it. It supports MS Excel versions from 97 to 2019.
Features of Passper for Excel
- There is a 100% rate of success upon using this tool to remove protection as well as restrictions. You can make changes, copy, and print the sheets
- The process of password removal takes only three seconds
- Passper for Excel is a trusted tool to remove protection. It is recognized by a few well-known websites, such as Macworld and MakeUseOf. This proves the safety and security of using this tool
- Restore the passwords in a short span of time to access the locked file. Passper for Excel has a quick response rate and does the work efficiently
Install the ‘Passper for Excel‘ on the PC. Now, follow the steps mentioned below to execute the process.
1. After installing the program, select the ‘Remove Restrictions‘ option.
2. Add the MS Excel protected sheet and tap on the ‘Remove‘ option.
3. It will take around three seconds to eliminate the password. The unprotected MS Excel sheet will automatically open to be edited.
Steps to perform this method
1. Open Passper for Excel and choose the ‘Recover Passwords‘ option from the main UI.
2. Upload the decrypted file to the program. Use the ‘+‘ key to execute the process of uploading the file. Now, choose an attack mode according to your file.
The four attack modes are mentioned below. See which attack mode fits for your file.
- Mask Attack: In this attack mode, you need to know something about the password, either the length or the placement of special characters or alphabets
- Combination Attack: It merges the characters that include numbers and symbols randomly to find the correct password
- Brute-Force: This mode will discover each character to find the MS Excel password. Brute-Force mode takes the longest time
- Dictionary Attack: Dictionary mode imports a list of possible passwords for the Excel Sheet. Passper for Excel will scan the list to find the password for your Sheet.
3. As soon as the recovery process finishes, the program will show the password on the screen.
Passper for Excel can break simple as well as complex passwords of the protected MS Excel sheet. It is easy and safe to operate.
Just have a try if you Forgot the Excel password.
There is a fine line of difference between a password-protected MS Excel Sheet or workbook and an unprotected MS Excel Sheet or workbook.
Steps to execute this method
1. Make the MS Excel file and secure it with a password. Now, make another file without any password protection.
2. Now, make changes in the file extension to .zip format and take the help of a file extraction tool to unzip both the MS Excel files. Then, save the files in unique folders with unique names.
3. Open every folder and analyze the /xl/workbook.xml file. You will see that the file that is protected by a password has a label <workbookProtection…/>. On the other hand, the unprotected workbook won’t have this label.
4. Get rid of the labels from the password-protected MS Excel Sheet as well as the workbook. Now, save the file.
5. Now, make use of the extraction tool to include the files within the 2nd folder and make changes in the file extension to .xlsx. Now, open the file, and you will notice that the protected password is eliminated.
To avoid the loss of data, try to create a backup of the MS Excel Sheet, then follow the steps mentioned below to get rid of the password.
Steps to unprotect the Sheets
1. Launch Google Docs. Log in to your account on Gmail.
2. Select the ‘Open File Picker‘ option.
3. You will see a dialog box; select the ‘Upload‘ option to add the password-protected MS Excel Sheet.
4. As soon as you are done uploading the Excel Sheet, the file will display in Google Docs. Go to the ‘File‘ option and select the ‘Download As‘ button, and further choose the ‘Microsoft Excel‘ option.
5. Your MS Excel will be unprotected because it is downloaded on the PC.
After all these steps, when you open the file on the PC, it will not ask for any password. You can make changes, copy, or print the file.
This particular method works perfectly for MS Excel files in the .xlsx format. So, if your MS Excel Sheet is saved in format .xls, you need to change it into the .xlsx format.
Steps to perform this method
- Make changes in the extension of the file name from .xlsx format to .zip format and tap on the ‘Yes‘ option.
- Use 7ZIP for opening the ZIP archive. , open the ‘xl->worksheets‘ named folder where you will notice the files like sheet1.xml and sheet2.xml. To unprotect the Excel Sheet 1, just right-click on the sheet1.xml and tap on the ‘Edit‘ option and ‘Open with Notepad.’
- Eliminate the tag which starts from ‘sheetProtection.’
- Save the sheet1.xml file and close it.
- Now, update the tailored sheet1.xml in the ZIP archive then close it.
- In the last step, make changes in the extension name back to .xlsx. You will get access to view and edit the MS Excel Sheet.
The methods mentioned above will assist you in unprotecting the MS Excel Sheets without a password. Now, you no more have to seek answers to ‘How to unprotect Excel sheet without password?’ We hope that this information was useful for you. Let us know if you try any techniques.