Differences

This shows you the differences between two versions of the page.

Link to this comparison view

sesipod:windows:exclrecv [2018/01/20 04:45] (current)
Line 1: Line 1:
 +====== Unlock password protected Excel spread sheets ======
  
 +Last tested and working: 09/06/2016
 +
 +----
 +
 +First open the excel spread sheet that is locked. In my case the top ribbon bar is locked.
 +
 +{{:​sesipod:​windows:​excel-locked.jpg?​nolink&​900|}}
 +
 +Next hit ALT + F11 to open the VB editor. At the top click on INSERT + Module in the new box insert the below text and then close the editor.
 +
 +{{:​sesipod:​windows:​screen_shot_2016-09-06_at_10.36.46_am.png?​nolink&​900|}}
 +
 +  Sub PasswordBreaker()
 +    '​Author unknown but submitted by brettdj of www.experts-exchange.com
 +    ​
 +    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)
 +     ​ActiveWorkbook.Sheets(1).Select
 +     ​Range("​a1"​).FormulaR1C1 = 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
 +
 +Now click on the new Module and select the green play button at the bottom select Macros In: All Projects
 +
 +{{:​sesipod:​windows:​excel-locked-macro.jpg?​nolink&​500|}} ​
 +
 +This should now unlock the file and open a one time password box just close this. Now the ribbon bar should display properly.
 +
 +{{:​sesipod:​windows:​excel-locked-unlocked.jpg?​nolink&​900|}}
 +
 +
 +Sourse: http://​www.theofficeexperts.com/​VBASamples/​Excel02.htm