So, you forgot your Worksheet password, but you can still access the Spreadsheet file?
The difference between a Spreadsheet and a Worksheet is that an Excel Spreadsheet file contains Worksheets that some people call “tabs”. See screenshot below.
To Unprotect Worksheet(s) all you need to do is to follow this guide:
1. Open your .xlsx file
2. Press ALT+F11 to open VBA. You will then see all your worksheets on the left hand side:
3. Double click on any of the worksheets and paste the following code:
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)
Exit Sub
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
End Sub
It should look like this:
4. Cluck Run (“play” button) or press F5 on your keyboard to run the code. This will unprotect the worksheet on which you ran this code.
You will see a small pop up window with the password you need to use to unprotect the remaining worksheets.
5. Use the above password (it will be different in your case, probably something like AAABAABBBBBv) to unprotect any other worksheet that is protected in this Spreadsheet file.
Job done. Couldn’t be easier.
