Last active
          April 25, 2018 13:55 
        
      - 
      
- 
        Save kebien6020/74f328202d9c46e5d0b18b0b96aade6b to your computer and use it in GitHub Desktop. 
    Force Unlock Excel Sheet
  
        
  
    
      This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
      Learn more about bidirectional Unicode characters
    
  
  
    
  | 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 | |
| ActiveWorkbook.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 ActiveWorkbook.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 | 
  
    Sign up for free
    to join this conversation on GitHub.
    Already have an account?
    Sign in to comment