ÎÊÌâÒÑ¿ªÆô (ÆÕͨÎÊÌâ)
¹ØÓÚHW6900µÄMML¹¤²ÎÖÆ×÷ºêV6µÄºêÃÜÂë
Ë­ÖªµÀ HW6900µÄMML¹¤²ÎÖÆ×÷ºêV6 µÄºêÃÜÂ룬ÒòM2000Éý¼¶£¬ÐèÐÞ¸ÄGTRX¼¶µÄ¶«Î÷¡£µ«Ð¡µÜ²»ÖªµÀºêÃÜÂ룬ÎÞ·¨Ð޸ġ£Çó½â¡£¡£¡£ÅªºÃÁËÎÒ»á·ÖÏí¸ø´ó¼ÒµÄ¡£
ÌáÎÊÕß: tang_00  ÌáÎÊʱ¼ä: 2013-09-29    
 
  ÎÒÒª»Ø´ð£º
 

  ÇëÏÈ µÇ¼ »ò ×¢²á ÔٻشðÎÊÌâ

¸ü¶à MML Ïà¹ØÎÊÌâ
ÎÊÌâ´ð°¸ ( 2 )

È¥³ýExcel¹¤×÷±íVBA±£»¤ÃÜÂëfd3s1fdÖªK:JFD()$#±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
ºÜÓÐÓõÄС¹¤¾ß:)K:JFD()$±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
²Ù×÷²½Ö裺ckjlurewiK:JFD()$#±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
1. ´ò¿ªÐèÒªÆƽâÃÜÂëµÄExcel£»vmmvckjluK:JFD()$#±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
2. Alt+F11£¬½øÈëVBA±à¼­½çÃ棻&#%kcK:JFD±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
3. ²åÈë -- Ä£¿é(Module)£»
4. ÔÚÓÒ±ßModuleµÄ¿Õ°×±à¼­ÇøÓò£¬¸´ÖÆÕ³ÌùÏÂÃæËùÓÐÄÚÈÝ£»$*@#(_@s4fadK:JFD()$#_*(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
5. F5£¬ÔËÐиÃVBAÃüÁ
42ÊÇ43432K:JFD()$#±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Option Explicit9Î÷7087K:JFD()±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Public Sub AllInternalPasswords()
' Breaks worksheet and workbook structure passwords. Bob McCormickfd5a4K:JFD±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
' probably originator of base code algorithm modified for coverage
' of workbook structure / windows passwords and for multiple passwords»21fds3a21fK:JFD()$#_*±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
'5a4f8e342ÊK:JFD()$#_±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
' Norman Harker and JE McGimpsey 27-Dec-2002 (Version 1.1)uierpoejµÀhK:JFD()$#_*±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
' Modified 2003-Apr-04 by JEM: All msgs to constants, andK:JFD±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
' eliminate one Exit Sub (Version 1.1.1)
' Reveals hashed passwords NOT original passwordss²»21fds3a2K:JFD()$#_*±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Const DBLSPACE As String = vbNewLine & vbNewLine
Const AUTHORS As String = DBLSPACE & vbNewLine & _
"Adapted from Bob McCormick base code by" & _
"Norman Harker and JE McGimpsey"
Const HEADER As String = "AllInternalPasswords User Message"1%$#(*K:JFD(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Const VERSION As String = DBLSPACE & "Version 1.1.1 2003-Apr-04"cvmmvcK:JFD(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Const REPBACK As String = DBLSPACE & "Please report failure " & _&)*(&#*($(ŶK:JFD()$#_*(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
"to the microsoft.public.excel.programming newsgroup."5%#(ô$*@#(_K:JFD()$#_*(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Const ALLCLEAR As String = DBLSPACE & "The workbook should " & _
"now be free of all password protection, so make sure you:" & _
DBLSPACE & "SAVE IT NOW!" & DBLSPACE & "and also" & _
DBLSPACE & "BACKUP!, BACKUP!!, BACKUP!!!" & _&#%kcvmmvcK:JFD()$#_±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
DBLSPACE & "Also, remember that the password was " & _Ç434321%$#(*K:JFD()$#_*(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
"put there for a reason. Don't stuff up crucial formulas " & _
"or data." & DBLSPACE & "Access and use of some data " & _
"may be an offense. If in doubt, don't."3289Î÷70874*K:JFD()$#_*(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Const MSGNOPWORDS1 As String = "There were no passwords on " & _a4f8e342ÊÇK:JFD()$#_±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
"sheets, or workbook structure or windows." & AUTHORS & VERSION)$#@3221a3dsK:JFD()$#_*(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Const MSGNOPWORDS2 As String = "There was no protection to " & _K:JFD()$#±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
"workbook structure or windows." & DBLSPACE & _cv545%#(K:JFD()$±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
"Proceeding to unprotect sheets." & AUTHORS & VERSION
Const MSGTAKETIME As String = "After pressing OK button this " & _874*$#(*)#$@K:JFD()$#_*(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
"will take some time." & DBLSPACE & "Amount of time " & _%#(ôK:JFD±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
"depends on how many different passwords, the " & _jouierpK:JFD()±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
"passwords, and your computer's specification." & DBLSPACE & _$#&)*(&#*(K:JFD()$#_±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
"Just be patient! Make me a coffee!" & AUTHORS & VERSION42ÊÇ4K:JFD±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Const MSGPWORDFOUND1 As String = "You had a Worksheet " & _dsÒ²f1K:JFD(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
"Structure or Windows Password set." & DBLSPACE & _K:JFD()$#_±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
"The password found was: " & DBLSPACE & "$$" & DBLSPACE & _289Î÷7087K:JFD()$#±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
"Note it down for potential future use in other workbooks by " & _
"the same person who set this password." & DBLSPACE & _kcvmmK:JFD±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
"Now to check and clear other passwords." & AUTHORS & VERSIONsaf12zcvK:JFD()$±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Const MSGPWORDFOUND2 As String = "You had a Worksheet " & _$#(*$#ʲ21K:JFD()$#_±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
"password set." & DBLSPACE & "The password found was: " & _54afd5a4K:JFD()$±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
DBLSPACE & "$$" & DBLSPACE & "Note it down for potential " & _Àh$#$#K:JFD(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
"future use in other workbooks by same person who " & _sfds1faK:JFD()±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
"set this password." & DBLSPACE & "Now to check and clear " & _*@#(_@s4fadK:JFD()$#_*±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
"other passwords." & AUTHORS & VERSION
Const MSGONLYONE As String = "Only structure / windows " & _5a4f8eK:JFD(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
"protected with the password that was just found." & _kjlurewK:JFD()±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
ALLCLEAR & AUTHORS & VERSION & REPBACK2zcv54K:JFD(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Dim w1 As Worksheet, w2 As Worksheet
Dim i As Integer, j As Integer, k As Integer, l As Integer#*($(Ŷ*&K:JFD()$#±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Dim m As Integer, n As Integer, i1 As Integer, i2 As Integer
Dim i3 As Integer, i4 As Integer, i5 As Integer, i6 As Integer&#*($(ÅK:JFD()±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Dim PWord1 As String%#(ô$*@#(_@K:JFD()$#_*(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Dim ShTag As Boolean, WinTag As Booleanª1fkjhK:JFD(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Application.ScreenUpdating = False3¶«oitre432K:JFD()$#_*±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
With ActiveWorkbookf12dsfds1fadK:JFD()$#_*(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
WinTag = .ProtectStructure Or .ProtectWindows
End With
ShTag = False*(&#*($(ÅK:JFD()$#±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
For Each w1 In Worksheets
ShTag = ShTag Or w1.ProtectContents¶*&#%kcvmK:JFD()$#±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Next w1
If Not ShTag And Not WinTag Then
MsgBox MSGNOPWORDS1, vbInformation, HEADER
Exit Sub
End If
MsgBox MSGTAKETIME, vbInformation, HEADERÎÒ)$#@3221K:JFD()$#_±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
If Not WinTag ThendsÒ²f12dsfdK:JFD()$#_*±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
MsgBox MSGNOPWORDS2, vbInformation, HEADER)*(&#*($(K:JFD()$#±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Else3dsÒ²f12dsK:JFD()$#_±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
On Error Resume NextpoejµÀh$#K:JFD()$#±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Do 'dummy do loopf12dsfds1fK:JFD()$#_±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
For i = 65 To 66: For j = 65 To 66: For k = 65 To 661fdÖª1fK:JFD()±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66ouierpoejµÀhK:JFD()$#_*(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66K:JFD(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 12634321%$#(*$#K:JFD()$#_*(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
With ActiveWorkbook4321%$#(K:JFD()$±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
.Unprotect Chr(i) & Chr(j) & Chr(k) & _ckjlurewioK:JFD()$#_*(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)545%#(ÃK:JFD()±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
If .ProtectStructure = False And _
.ProtectWindows = False Then1a3dsÒ²f12K:JFD()$#_±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
PWord1 = Chr(i) & Chr(j) & Chr(k) & Chr(l) & _
Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
MsgBox Application.Substitute(MSGPWORDFOUND1, _
"$$", PWord1), vbInformation, HEADERds1fadsK:JFD()±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Exit Do 'Bypass all for...nexts545%#(K:JFD(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
End Ifds3a21fd3s1fK:JFD()$#_*(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
End Withs1fdÖªK:JFD(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Next: Next: Next: Next: Next: Nexte43289ÎK:JFD()±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Next: Next: Next: Next: Next: Nexta3dsÒ²f12dsK:JFD()$#_*±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Loop Until True89Î÷70K:JFD(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
On Error GoTo 0ds1fadK:JFD(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
End If1fkjhfK:JFD(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
If WinTag And Not ShTag Then
MsgBox MSGONLYONE, vbInformation, HEADER
Exit Sub&)*(&#*($K:JFD()$#±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
End If9Î÷7087K:JFD()±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
On Error Resume Next1fkjhfjouierK:JFD()$#_*(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
For Each w1 In Worksheetse43289ÎK:JFD()±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
'Attempt clearance with PWord1Ç434321%$#(K:JFD()$#_*±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
w1.Unprotect PWord1#$@&%#K:JFD(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Next w1
On Error GoTo 0
ShTag = False
For Each w1 In WorksheetsejµÀh$#$#&K:JFD()$#_±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
'Checks for all clear ShTag triggered to 1 if not.
ShTag = ShTag Or w1.ProtectContents)$#@3221a3dsK:JFD()$#_*(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Next w1
If ShTag Then#@3221a3dsÒ²K:JFD()$#_*(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
For Each w1 In Worksheets3289ÎK:JFD±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
With w154afd5a4fK:JFD()$#±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
If .ProtectContents ThenŶ*&#%kcvmK:JFD()$#_±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
On Error Resume NextjlurewioK:JFD()$#±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Do 'Dummy do loopsaf12zcK:JFD()±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
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 66dÖª1fkK:JFD(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66jµÀh$#$#&)K:JFD()$#_±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126(*$#ʲ21fK:JFD()$#±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
.Unprotect Chr(i) & Chr(j) & Chr(k) & _#(*)#K:JFD±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _5a4f8e34K:JFD()$±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)ÎÒ)$#@32K:JFD()$±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
If Not .ProtectContents Then#ʲ21f3K:JFD()±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
PWord1 = Chr(i) & Chr(j) & Chr(k) & Chr(l) & _
Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _sfds1fadK:JFD()$±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)342ÊÇ43432K:JFD()$#_±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
MsgBox Application.Substitute(MSGPWORDFOUND2, _#(_@s4faK:JFD()$±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
"$$", PWord1), vbInformation, HEADERfd5a4fK:JFD(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
'leverage finding Pword by trying on other sheets
For Each w2 In Worksheetsd5a4f8e342K:JFD()$#_±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
w2.Unprotect PWord1tre43289Î÷7K:JFD()$#_*±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Next w2
Exit Do 'Bypass all for...nextsfd3s1fdÖK:JFD()$±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
End If@#(_@K:JFD±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Next: Next: Next: Next: Next: Next%#*(ÎÒ)$#K:JFD()$#±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Next: Next: Next: Next: Next: Next
Loop Until TrueerpoejµÀh$#$K:JFD()$#_*(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
On Error GoTo 0s1fdÖª1fkjhfK:JFD()$#_*(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
End Iffads13¶«oiK:JFD()$#_±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
End With@3221a3dsÒK:JFD()$#_±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Next w1$#&)*K:JFD±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
End Iffds1fads²»2K:JFD()$#_*±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
MsgBox ALLCLEAR & AUTHORS & VERSION & REPBACK, vbInformation, HEADER
End Sub
@#(_@sK:JFD(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
ds1fadK:JFD(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ

»Ø´ðÕߣº FridayCai     »Ø´ðʱ¼ä£º2013-09-29 17:02    

5        4        
°ÑÄãµÄ½Å±¾¸´ÖƹýÀ´ºÃ¶àMSCBSCµÄ´úÂë°¡¡£
tang_00  2013-09-30 09:17 

ÄãÕâ¸öÐв»Í¨£¬°ÑÎҵĺ궼¸øÇåÀíÁË¡£¹¤¾ßҲûÓÐÁË¡£¡£
tang_00  2013-09-30 09:46 



ÏÈ °Ù¶È Passware_Kit    ÍêºóÏÂÔØÒ»¸öÈ¥Æƽâ¾ÍºÃÁË


»Ø´ðÕߣº cswcsw123     »Ø´ðʱ¼ä£º2013-09-29 20:25    

9        4        

ÖйúͨÐÅÈ˲ÅÍø | ½­ËÕͨÐÅÈ˲ÅÍø | ɽ¶«Í¨ÐÅÈ˲ÅÍø | Î人ͨÐÅÈ˲ÅÍø | Õ㽭ͨÐÅÈ˲ÅÍø | ºþÄÏͨÐÅÈ˲ÅÍø
ÄϾ©Ð­Ö®Ô¶ÐÅÏ¢¼¼ÊõÓÐÏÞ¹«Ë¾ Ƹ£ºµçÐÅЭÓÅÈÏÖ¤ ³õ¼¶/Öм¶¹¤³Ìʦ
ÐèÇóÈËÊý£º20 ÈË µØµã£º½­ËÕÊ¡
ÄϾ©ÐÀÍøͨÐſƼ¼¹É·ÝÓÐÏÞ¹«Ë¾ Ƹ£ºÍøÓŹ¤³Ìʦ£¨¸ß¼¶£©
ÐèÇóÈËÊý£º2 ÈË µØµã£ºÌ©ÖÝÊÐ,Õò½­ÊÐ
¹ã¶«»ªÑ¶¹¤³ÌÓÐÏÞ¹«Ë¾ Ƹ£º¹ã¶«Åµ»ùÑÇLTE Öи߼¶ºǫ́
ÐèÇóÈËÊý£º2 ÈË µØµã£º¹ã¶«Ê¡
Î÷°²³¤ºÓͨѶÓÐÏÞÔðÈι«Ë¾ Ƹ£ºÍøÂç²âÊÔ·ÖÎö¹¤³Ìʦ
ÐèÇóÈËÊý£º10 ÈË µØµã£º¾ÆȪÊÐ,¶Ø»ÍÊÐ,ÓñÃÅÊÐ,°×ÒøÊÐ
¼Î»·¿Æ¼¼¹É·ÝÓÐÏÞ¹«Ë¾ Ƹ£º²âÊÔ¹¤³Ìʦ
ÐèÇóÈËÊý£º15 ÈË µØµã£ºÀ¥Ã÷ÊÐ,ÁÙ²×ÊÐ,µÂºêÖÝ,ºìºÓÖÝ,ÓñϪÊÐ
ɽ¶«Ê¡Óʵ繤³ÌÓÐÏÞ¹«Ë¾ Ƹ£º¿¢¹¤×ÊÁϽáËãÔ±
ÐèÇóÈËÊý£º5 ÈË µØµã£º¸£ÖÝÊÐ
¸£½¨Ê¡ºè¹ÙͨÐŹ¤³ÌÓÐÏÞ¹«Ë¾ Ƹ£ºÕ㽭ʵϰǰ̨¹¤³Ìʦ
ÐèÇóÈËÊý£º7 ÈË µØµã£ºÕã½­Ê¡
¹ãÖÝå«ÐÅͨÐſƼ¼¹É·ÝÓÐÏÞ¹«Ë¾ Ƹ£º¸ßÌú/¸ßËÙÍøÓŹ¤³Ìʦ£¨¶«Ý¸£©
ÐèÇóÈËÊý£º2 ÈË µØµã£º¶«Ý¸ÊÐ
Ö麣ÊÀ¼Í¶¦Àû¿Æ¼¼¹É·ÝÓÐÏÞ¹«Ë¾ Ƹ£ºÊµÑéÊÒͨÐÅÉ豸°²×°Î¬»¤(Ë«ÐÝ£©
ÐèÇóÈËÊý£º1 ÈË µØµã£ºº¼ÖÝÊÐ
Õã½­Ê¡Óʵ繤³Ì½¨ÉèÓÐÏÞ¹«Ë¾ Ƹ£ºÉÂÎ÷ÓÜÁÖÒƶ¯5Gϵͳ¹¤³Ìʦ
ÐèÇóÈËÊý£º5 ÈË µØµã£ºÏÌÑôÊÐ,ÓÜÁÖÊÐ
ÈȵãÎÊÌâ
¸ü¶à¾«²Ê

ÁªÏµÎÒÃÇ - ÎÊͨÐÅר¼Ò Powered by MSCBSC Òƶ¯Í¨ÐÅÍø  © 2006 -