Sometime we protect our Excel spreadsheet to make it easier for sharing and of course, to prevent us and anyone to make a silly mistake and delete all the formula in a cell.
There will be time when we need to update some formula or the format of our spreadsheet. Since this will most likely happen once in a blue moon, often, we already forgot the password to unprotect the document.

In case this happen to you, here is some code for you to remove that password without any special software. To make this work, Open your protected document, then press ALT+F11, to bring the Visual Basic Application Console. On the menu above, go to Insert > Module.

Copy and paste the following code to your Module

Sub unProtect() 'Remove excel protect password 'show the password hashes ONLY 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 Hashes: " & 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
Then press F5 to run the application.
Voilla! You just remove your password!