How to Unprotect an Excel Spreadsheet if you have lost your password.
http://www.excelsupersite.com/how-to-unprotect-an-excel-spreadsheet-if-you-have-lost-your-password/ How to unprotect a password protected worksheet. So what do you do… In the case of a password protected worksheet where you are unable to Edit the data you can try the following steps to unprotect your worksheet. Step 1 Press ALT + F11 or click View Code on the Developers Tab Step 2 Double click on the worksheet that is password protected. Step 3 Copy and paste the code below into the (Code) window. Do not change any of the code, just copy and paste it. Sub PasswordBreaker () 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