Closed Thread
Results 1 to 2 of 2

Password Breaker Crashing Excel

  1. #1
    Registered User
    Join Date
    04-22-2013
    Location
    Manchester, England
    MS-Off Ver
    Excel for Mac 2011
    Posts
    22

    Password Breaker Crashing Excel

    Hi All,

    I forgot the password to unprotect on of the worksheets within a document I was working on and I've always used the below to unlock it. But for some reason, this is just sending Excel unresponsive. I really don't want to spend time having to redo the one worksheet. Does anyone have any ideas?

    Sub VBAPWD_BREAK()
    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)
    Exit Sub
    End If
    Next: Next: Next: Next: Next: Next
    Next: Next: Next: Next: Next: Next
    End Sub

    Thank you,

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,411

    Re: Password Breaker Crashing Excel

    Your post does not comply with Rule 11 of our Forum RULES.

    Don't post questions regarding breaking or bypassing any security measure. Such posts will be deleted, and repeat offenders will be banned. This includes posting of links to sites that offer software, code or services to do this or posting of code to remove passwords
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Removed from Forum
    By 20183740 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-26-2017, 01:57 AM
  2. Excel crashing when trying to view code before macro run; not crashing after first run
    By goonerforlyf in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-21-2015, 05:27 PM
  3. Password Breaker Code
    By Dreamwine59 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-09-2014, 08:12 AM
  4. Excel crashing
    By foleyp in forum Excel General
    Replies: 0
    Last Post: 04-01-2010, 10:40 AM
  5. Ice Breaker - My First Excel Experience
    By NBVC in forum The Water Cooler
    Replies: 14
    Last Post: 06-10-2008, 12:42 PM
  6. Password Breaker
    By Christmas May in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-12-2006, 06:40 PM
  7. [SOLVED] Excel Sort Tie Breaker
    By Casper in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-08-2006, 07:50 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1