In nowadays, we are used to set the password to protect our private sensitive data, like the credit card, online social account, and work data. The most common password that I’m used to forget is Excel sheet password. Sometimes you may want to prevent other users from changing cells from your excel sheet that shouldn’t be changed, and also from moving or deleting important data. So you will set a password for it. If you forget this password, what will you do? As for me, there is no idea about how to fix that trouble, since I’m the worst users of Excel, just know how to copy and paste data into it. Facing that issue, the only way for me is to search answers on the Internet. Below is a tutorial guide on how to unprotect Excel sheet without the password.
Way 1: Unprotect excel sheet password with VBA code
Note: This way is for Excel 2010 or older Excel versions. And it’s very complicated for the average users, if you want a easier way, please jump to Way 2.
Step 1: First to press Alt + F11 to open the visual basic editor, then right-click the workbook name on the left pane (project-VBAproject pane) and select Insert, the module from the context menu.
Step 2: To copy and paste the following code without any change and delete;Sub PasswordBreaker()
‘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 “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)
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
Step3: After that, click on the Run Button or press F5. The macro will report a crack password for you to unlock the excel sheet, it works, nevertheless not for 100%.
If you feel the method above is much complex for you to unprotect excel sheet without the password, then you can try the method below.
Excel Password Recovery Software is designed for Excel users to recover excel sheet password easily. No matter you are the beginner or senior users of Excel, you will be able to unprotect password in 3 steps with its simple interface design. Take iSunshare Excel Password Genius as example.
Step 1: Free download and install iSunshare Excel password Genius below on your computer.
Step 2: Launch the tool and click open to import encrypted excel file that you want to recover its password.
Step 3: To choose password attack type and make detail settings for it. There are four attack types for you. Respectively are Brute-force, Mask, Dictionary, and Smart. You must choose one to improve password recovery speed.
Note: If you have no password, suggest choosing Dictionary or smart type.
Step 4：Click Start button to recover unprotect excel sheet password. After you click it, it will cost several minutes to recover the password. When following window pop up, it means the password recovery successful, you can copy the recovery password to open the excel sheet.
Don’t hesitate to try the two ways above to choose which method is much easier for you to fix to unprotect excel sheet without the password.