• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need Help With Password Unlock and Loop

ham123

Member
Greetings Experts,

I have this VBA code and what it does is that it will help to recover a sheet's password and show it in a message box.

Code:
Sub WorksheetLoop()

    Dim WS_Count As Integer
    Dim Q As Integer
    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
    
    WS_Count = ActiveWorkbook.Worksheets.Count

    For Q = 1 To WS_Count


    
    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


    MsgBox ActiveWorkbook.Worksheets(I).Name

    Next Q

End Sub
I need help looping the code for all sheets as for now, it only recovers the password and unlocks the active sheet. At the end, I also need the messagebox to show all the passwords for the respective sheet.

Any help is much appreciated! :)
 
Top