Results 1 to 14 of 14
  1. #1
    2 Star Lounger
    Join Date
    Jul 2002
    Location
    London, United Kingdom
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Password Cracker (2000 SR-1)

    Can anyone recommend a FREE, and FREE is the operative word, download to crack passwords in Excel Workbooks.

    The holiday season is well underway and a number of people have password protected workbooks and worksheets and <img src=/w3timages/censored.gif alt=censored border=0> off on holiday. Naturally they haven't told anyone the passwords

    Any recommendations would be gratefully received

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Password Cracker (2000 SR-1)

    Hetty,
    Are you talking about passwords to open the workbook, or passwords that protect the workbook/worksheets from changes? If it's the former, then you may have considerable trouble even with commercial crackers, depending on the length and complexity of the password.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    2 Star Lounger
    Join Date
    Jul 2002
    Location
    London, United Kingdom
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Password Cracker (2000 SR-1)

    Hi Rory

    Both....unfortunately

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Password Cracker (2000 SR-1)

    I don't know offhand of any free crackers that will do passwords for opening workbooks. I have the Elcomsoft one, which comes in Pro and Standard versions and isn't too expensive (you'd only need the Standard version) but as I mentioned, it can take weeks (or longer) to crack a complicated password by brute force! It will do passwords for modify protection pretty much instantaneously though. There is a trial version you can download but it only works for 30 days and will only do passwords up to 4 letters for brute force. I know there are free ones to do worksheet passwords but don't have any web addresses offhand - I'm sure someone else can chip with some links to those. You can also in some versions of Excel remove the protection by reprotecting the sheet in code with a blank password!
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Password Cracker (2000 SR-1)

    Erlandsen has a free password cracker, but it can take forever at the Workbook Protection level, and I don't recall if it does Workbook Open Protection cracking.
    -John ... I float in liquid gardens
    UTC -7DS

  6. #6
    3 Star Lounger
    Join Date
    May 2002
    Location
    Toronto, Ontario, Canada
    Posts
    314
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Password Cracker (2000 SR-1)

    Check out the link below...
    http://www.erlandsendata.no/english/downloads/tools.php
    I downloaded the "Find Lost Passwords" tool... I've only used it a couple of times but it's worked great for me... It's a free Addin...
    Give it a shot and let me know what you think...

    HTH <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  7. #7
    3 Star Lounger
    Join Date
    May 2002
    Location
    Toronto, Ontario, Canada
    Posts
    314
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Password Cracker (2000 SR-1)

    This is what the site says John... I guess it does work for the Workbook opening protection, but luckily I haven't had to try that yet...
    (Quick!.... Knock on some wood for me! <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>)

    "Find lost passwords
    Have you ever forgotten or lost your workbook passwords?
    This tool will find the lost workbook and worksheet protection passwords for you in a relative short time.
    Have you forgotten the password you used to protect the file itself from being opened?
    This tool can help you find this password too, but this will probably take a very long time.
    This tool is not capable of unprotecting any VBprojects in a workbook."

  8. #8
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Password Cracker (2000 SR-1)

    Since the Lounge Search function is taking a rest, here are two sets of code for accessing password protected Worksheets that have been previously posted. Put either one into a standard module and attach it to a custom icon. I can vouch for the first.<pre>Sub PasswordBreaker()
    'Author unknown
    '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
    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)
    'It may be unnecessary to use the offered password
    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
    End Sub


    Sub UnprotectActiveSheet()
    'Exploits a rather exotic security flaw to unprotect any workSHEET (97 SR2)
    Dim sDlgTitle As String
    sDlgTitle = "Sub UnprotectActiveSheet"
    With ActiveSheet
    If .ProtectContents = True Then
    'First pre-requisite
    .Protect userInterfaceOnly:=True
    'Second pre-requisite. Assumes all 'very last cells' are not used
    ActiveWorkbook.Worksheets.FillAcrossSheets .Range("IV65536")
    'Check whether trick was sucessfull
    If .ProtectContents = False Then
    'Trumpet it
    MsgBox "Protection of " & .Name & " was set to " & .ProtectContents, _
    vbInformation, sDlgTitle
    Else
    'Case security flaw will be patched
    MsgBox "Protection of " & .Name & " could not be removed", vbCritical, sDlgTitle
    End If
    Else
    MsgBox .Name & " was not protected to start with !", vbExclamation, sDlgTitle
    End If
    End With
    End Sub</pre>

    HTH
    Gre

  9. #9
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Password Cracker (2000 SR-1)

    Unk -

    You make it seem so hard. To unprotect any active worksheet try:

    Sub SheetPassword()
    ActiveSheet.Protect "", , , , True
    ActiveSheet.Range("A1").Copy ActiveSheet.Range("A1")
    End Sub

    This will produce an error if A1 is merged, but you can easily change that to any other cell.

    The only real advantage of your first version is that it gives you a password that you can use to re-protect the worksheet and still allow whoever has the original password to still use it.

    Cheers
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  10. #10
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Password Cracker (2000 SR-1)

    Mate - you should have been around when these were originally posted in the Lounge! <img src=/S/ribbon.gif border=0 alt=ribbon width=15 height=15> I've never really applied my own mind to this kind of thing. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

    Just to clarify your comment on the first piece I posted. The password it delivers isn't necessarily the exact same password as was used to protect the sheet - although it works the same.
    Gre

  11. #11
    2 Star Lounger
    Join Date
    Jul 2002
    Location
    London, United Kingdom
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Password Cracker (2000 SR-1)

    Thanks to everyone for their assistance.

    I am going to hand this over to those that can better deal with it than me. I don't know VB and when I have tried to use it in the past, any success was purely luck. I wish this company would send me on a VB course, just to be able to employ code that has already been written.

    Who knows it may be that we are going to have to invest some cold hard cash.

    Again, many thanks

  12. #12
    2 Star Lounger
    Join Date
    May 2002
    Posts
    121
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Password Cracker (2000 SR-1)

    Could you please explain how to use this macro. I also need a password to create a macro.

    Thanks.

  13. #13
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Password Cracker (2000 SR-1)

    If the workbook VB project is password protected, you will have to:
    open a new workbook
    Start vb, insert a module, copy the macro into the module.
    Activate the sheet in the workbook that you want to unprotect
    then run your macro in the other workbook.

    Steve

  14. #14
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Password Cracker (2000 SR-1)

    Hi,

    The macros discussed in this thread are designed to remove worksheet protection. They do not remove passwords that prevent workbooks being opened. Nor do they remove passwords that have been set on vba projects.

    If you "need a password to create a macro", I suspect you're after the last of the above. In that case, you'll need to obtain the password from whoever protected the project or you'll need to use one of the commercial programs.

    Cheers
    Cheers,

    Paul Edstein
    [MS MVP - Word]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •