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

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

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

È¥³ýExcel¹¤×÷±íVBA±£»¤ÃÜÂë21fds3aK:JFD()±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
ºÜÓÐÓõÄС¹¤¾ß:)ewioK:JFD()$#_±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
²Ù×÷²½Ö裺dÖª1fkjhfjouK:JFD()$#_*(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
1. ´ò¿ªÐèÒªÆƽâÃÜÂëµÄExcel£»
2. Alt+F11£¬½øÈëVBA±à¼­½çÃ棻*&#%kcvmmK:JFD()$#±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
3. ²åÈë -- Ä£¿é(Module)£»)*(&#*(K:JFD()±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
4. ÔÚÓÒ±ßModuleµÄ¿Õ°×±à¼­ÇøÓò£¬¸´ÖÆÕ³ÌùÏÂÃæËùÓÐÄÚÈÝ£»K:JFD±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
5. F5£¬ÔËÐиÃVBAÃüÁ«oitre432K:JFD()$#±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
*(&#*($(Ŷ*&K:JFD()$#_*(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Option Explicittre43K:JFD±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Public Sub AllInternalPasswords()kcvmmvckjlK:JFD()$#_±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
' Breaks worksheet and workbook structure passwords. Bob McCormick70874*$#(*K:JFD()$#_±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
' probably originator of base code algorithm modified for coverage
' of workbook structure / windows passwords and for multiple passwordsds²»21fds3K:JFD()$#_±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
'
' Norman Harker and JE McGimpsey 27-Dec-2002 (Version 1.1)ds13¶«oiK:JFD()$±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
' Modified 2003-Apr-04 by JEM: All msgs to constants, andejµÀh$#$K:JFD()$±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
' eliminate one Exit Sub (Version 1.1.1)
' Reveals hashed passwords NOT original passwords*(&#*($(ÅK:JFD()$#±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Const DBLSPACE As String = vbNewLine & vbNewLinesfds1fads²»2K:JFD()$#_*(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Const AUTHORS As String = DBLSPACE & vbNewLine & _jlurewioK:JFD()$#_*±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
"Adapted from Bob McCormick base code by" & _
"Norman Harker and JE McGimpsey"mvckjlureK:JFD()$#±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Const HEADER As String = "AllInternalPasswords User Message"dsaf12K:JFD(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Const VERSION As String = DBLSPACE & "Version 1.1.1 2003-Apr-04"fds3a21fd3sK:JFD()$#_*±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Const REPBACK As String = DBLSPACE & "Please report failure " & _1fdÖª1K:JFD(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
"to the microsoft.public.excel.programming newsgroup."434321%$#(*$K:JFD()$#_*(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Const ALLCLEAR As String = DBLSPACE & "The workbook should " & _ds1faK:JFD±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
"now be free of all password protection, so make sure you:" & _
DBLSPACE & "SAVE IT NOW!" & DBLSPACE & "and also" & _
DBLSPACE & "BACKUP!, BACKUP!!, BACKUP!!!" & _sÒ²f12dsK:JFD()$±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
DBLSPACE & "Also, remember that the password was " & _
"put there for a reason. Don't stuff up crucial formulas " & _(ÎÒ)$#@3221aK:JFD()$#_*(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
"or data." & DBLSPACE & "Access and use of some data " & _43432K:JFD±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
"may be an offense. If in doubt, don't."4*$#(*)#$@K:JFD()$#_±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Const MSGNOPWORDS1 As String = "There were no passwords on " & _oitre432K:JFD()$±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
"sheets, or workbook structure or windows." & AUTHORS & VERSION1fdÖª1fkjK:JFD()$#±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Const MSGNOPWORDS2 As String = "There was no protection to " & _#*(ÎÒK:JFD±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
"workbook structure or windows." & DBLSPACE & _K:JFD()$#_±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
"Proceeding to unprotect sheets." & AUTHORS & VERSION
Const MSGTAKETIME As String = "After pressing OK button this " & _#ʲ21f3dsafK:JFD()$#_*±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
"will take some time." & DBLSPACE & "Amount of time " & _4afd5K:JFD±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
"depends on how many different passwords, the " & _1%$#(*$#K:JFD()$±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
"passwords, and your computer's specification." & DBLSPACE & _jhfjouierK:JFD()$#±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
"Just be patient! Make me a coffee!" & AUTHORS & VERSION(ÎÒ)$#@3221aK:JFD()$#_*(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Const MSGPWORDFOUND1 As String = "You had a Worksheet " & _e342ÊÇ4K:JFD()±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
"Structure or Windows Password set." & DBLSPACE & _
"The password found was: " & DBLSPACE & "$$" & DBLSPACE & _*$#(*)#$K:JFD()$±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
"Note it down for potential future use in other workbooks by " & _
"the same person who set this password." & DBLSPACE & _
"Now to check and clear other passwords." & AUTHORS & VERSION
Const MSGPWORDFOUND2 As String = "You had a Worksheet " & _
"password set." & DBLSPACE & "The password found was: " & _#ʲ21f3dsafK:JFD()$#_*±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
DBLSPACE & "$$" & DBLSPACE & "Note it down for potential " & _
"future use in other workbooks by same person who " & _
"set this password." & DBLSPACE & "Now to check and clear " & _2dsfdK:JFD±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
"other passwords." & AUTHORS & VERSIONds13¶«oitre4K:JFD()$#_*(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Const MSGONLYONE As String = "Only structure / windows " & _²f12dsfK:JFD()±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
"protected with the password that was just found." & _#%kcvmmvK:JFD()$±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
ALLCLEAR & AUTHORS & VERSION & REPBACKkjlurewK:JFD()±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Dim w1 As Worksheet, w2 As Worksheet5%#(ôK:JFD(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Dim i As Integer, j As Integer, k As Integer, l As Integer¶«oitre4328K: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 Integer54afd5a4fK:JFD()$#±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Dim PWord1 As Stringf3dsaf12zcvK:JFD()$#_*±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Dim ShTag As Boolean, WinTag As Boolean
Application.ScreenUpdating = FalsejouierpoejK:JFD()$#_±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
With ActiveWorkbook
WinTag = .ProtectStructure Or .ProtectWindows#(*$#ÊK:JFD(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
End With1a3dsK:JFD±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
ShTag = False
For Each w1 In Worksheetsf12zcv545%K:JFD()$#_±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
ShTag = ShTag Or w1.ProtectContents²»21fK:JFD±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Next w1%kcvmK:JFD±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
If Not ShTag And Not WinTag ThenouierpK:JFD(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
MsgBox MSGNOPWORDS1, vbInformation, HEADERa21fd3s1fK:JFD()$#±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Exit Subd3s1fdÖK:JFD()±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
End Ifds1fads²K:JFD()$±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
MsgBox MSGTAKETIME, vbInformation, HEADER$#&)*(&#*K:JFD()$#±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
If Not WinTag Then$#@322K:JFD(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
MsgBox MSGNOPWORDS2, vbInformation, HEADER
Else1fds3a21fd3K:JFD()$#_*±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
On Error Resume Nextfads²»21K:JFD()$±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Do 'dummy do loop@3221a3K: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 664fads13¶«oK: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 126Î÷708K:JFD±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
With ActiveWorkbook
.Unprotect Chr(i) & Chr(j) & Chr(k) & _
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _3s1fdÖª1fkjK:JFD()$#_*±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)&#*($(ŶK:JFD()$±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
If .ProtectStructure = False And _
.ProtectWindows = False Then*(ÎÒ)$#@3K:JFD()$#±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
PWord1 = Chr(i) & Chr(j) & Chr(k) & Chr(l) & _÷70874*$K:JFD()$±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)v545%#(ô$*K:JFD()$#_*±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
MsgBox Application.Substitute(MSGPWORDFOUND1, _3dsaf1K:JFD(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
"$$", PWord1), vbInformation, HEADERfads²»K:JFD(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Exit Do 'Bypass all for...nexts21fdsK:JFD±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
End IfµÀh$#$#&)*K:JFD()$#_±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
End Withdsfds1fadK:JFD()$#±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Next: Next: Next: Next: Next: Next3dsaf1K:JFD(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Next: Next: Next: Next: Next: Nextzcv545%#(ÃK:JFD()$#_±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Loop Until TruedsfdsK:JFD±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
On Error GoTo 04afd5a4f8K:JFD()$#±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
End If12zcv545%#(K:JFD()$#_*±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
If WinTag And Not ShTag ThenµÀh$#$#&)*(&K:JFD()$#_*(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
MsgBox MSGONLYONE, vbInformation, HEADER9Î÷70874*K:JFD()$#±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Exit SubjµÀh$#K:JFD(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
End If#@3221a3dsÒ²K:JFD()$#_*(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
On Error Resume Next
For Each w1 In Worksheets
'Attempt clearance with PWord1dÖª1fkjhfjouK:JFD()$#_*(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
w1.Unprotect PWord142ÊÇ4343K:JFD()$±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Next w1vckjlurewK:JFD()$#±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
On Error GoTo 0
ShTag = False
For Each w1 In Worksheetsfds1fads²»21K:JFD()$#_*(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
'Checks for all clear ShTag triggered to 1 if not.3289Î÷7087K:JFD()$#_±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
ShTag = ShTag Or w1.ProtectContents1f3dsaK:JFD(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Next w1s3a21fK:JFD(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
If ShTag Then
For Each w1 In Worksheets
With w1s1fdÖª1fkjK:JFD()$#_±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
If .ProtectContents Then
On Error Resume NextK:JFD(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Do 'Dummy do loop
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 668e342ÊK:JFD(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
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
.Unprotect Chr(i) & Chr(j) & Chr(k) & _
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _÷70874*$#K:JFD()$#±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)&%#*(ÎK:JFD(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
If Not .ProtectContents Then
PWord1 = Chr(i) & Chr(j) & Chr(k) & Chr(l) & _21%$#(*$#ÊK:JFD()$#_±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _cvmmvckjlureK:JFD()$#_*(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)12zcv5K:JFD(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
MsgBox Application.Substitute(MSGPWORDFOUND2, _289Î÷70K:JFD()±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
"$$", PWord1), vbInformation, HEADER
'leverage finding Pword by trying on other sheets
For Each w2 In Worksheets89Î÷708K:JFD()±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
w2.Unprotect PWord1
Next w23¶«oitK:JFD(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Exit Do 'Bypass all for...nexts
End If#(*$#ʲK:JFD()±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Next: Next: Next: Next: Next: Nextfads²»K:JFD(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
Next: Next: Next: Next: Next: Next
Loop Until True*($(Ŷ*&#%kK:JFD()$#_*±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
On Error GoTo 02dsfds1fads²K:JFD()$#_*(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
End If21fds3K:JFD(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
End With
Next w174*$#K:JFD±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
End Ifds3a21fdK:JFD()$±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
MsgBox ALLCLEAR & AUTHORS & VERSION & REPBACK, vbInformation, HEADER
End Sub4fads13¶K:JFD()$±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
545%#K: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    ÍêºóÏÂÔØÒ»¸öÈ¥Æƽâ¾ÍºÃÁË(*$#ʲK:JFD(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
3221a3dsÒ²fK:JFD()$#_*±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ

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

9        4        

ÖйúͨÐÅÈ˲ÅÍø | ½­ËÕͨÐÅÈ˲ÅÍø | ɽ¶«Í¨ÐÅÈ˲ÅÍø | Î人ͨÐÅÈ˲ÅÍø | Õ㽭ͨÐÅÈ˲ÅÍø | ºþÄÏͨÐÅÈ˲ÅÍø
ÖÐÒÆÌúͨÓÐÏÞ¹«Ë¾½­ÃÅ·Ö¹«Ë¾ Ƹ£ºÎ¬»¤Ö¸±ê¹Ü¿ØÖ÷¹Ü
ÐèÇóÈËÊý£º1 ÈË µØµã£º½­ÃÅÊÐ
ÉϺ£î£îìÖÇÄܿƼ¼ÓÐÏÞ¹«Ë¾ Ƹ£ºËÄ´¨Òƶ¯Åµ»ùÑǸºÔðÈË
ÐèÇóÈËÊý£º1 ÈË µØµã£ºÑÅ°²ÊÐ
±±¾©ÒËͨ»ªÈð¿Æ¼¼ÓÐÏÞ¹«Ë¾ Ƹ£ºÇåÔ¶ÊÐÒƶ¯»ªÎª4/5Gϵͳר¼Ò¼¶
ÐèÇóÈËÊý£º1 ÈË µØµã£ºÇåÔ¶ÊÐ
ÖØÇìÐÅ¿ÆͨÐŹ¤³ÌÓÐÏÞ¹«Ë¾ Ƹ£ºËÄ´¨°ÍÖÐ-IMCÕÐƸ
ÐèÇóÈËÊý£º1 ÈË µØµã£º°ÍÖÐÊÐ
º¼Öݶ«ÐÅÍøÂç¼¼ÊõÓÐÏÞ¹«Ë¾ Ƹ£º²×ÖÝ-¸ß/ÖÐ/³õ¼¶-ÍøÓŹ¤³Ìʦ
ÐèÇóÈËÊý£º30 ÈË µØµã£º²×ÖÝÊÐ
ÄϾ©»ªËտƼ¼ÓÐÏÞ¹«Ë¾ Ƹ£ºÍøÂçÓÅ»¯¹¤³Ìʦ
ÐèÇóÈËÊý£º5 ÈË µØµã£ºÌì½òÊÐ
¹ã¶«ÄÏ·½Í¨ÐŽ¨ÉèÓÐÏÞ¹«Ë¾ Ƹ£ºº£ÄϺǫ́ÓÅ»¯
ÐèÇóÈËÊý£º10 ÈË µØµã£ºº£¿ÚÊÐ,ÈýÑÇÊÐ
Ö麣ÊÀ¼Í¶¦Àû¿Æ¼¼¹É·ÝÓÐÏÞ¹«Ë¾ Ƹ£ºÊµÑéÊÒͨÐÅÉ豸°²×°Î¬»¤(Ë«ÐÝ£©
ÐèÇóÈËÊý£º1 ÈË µØµã£ºº¼ÖÝÊÐ
Õã½­Ê¡Óʵ繤³Ì½¨ÉèÓÐÏÞ¹«Ë¾ Ƹ£ºÉÂÎ÷ÓÜÁÖÒƶ¯5Gϵͳ¹¤³Ìʦ
ÐèÇóÈËÊý£º5 ÈË µØµã£ºÏÌÑôÊÐ,ÓÜÁÖÊÐ
³É¶¼ÆìѶͨÐż¼ÊõÓÐÏÞ¹«Ë¾ Ƹ£ºÄÏÄþ/ÎàÖÝ/±±º£ÕÐͶËß²âÊÔ¡¢ºǫ́
ÐèÇóÈËÊý£º12 ÈË µØµã£ºÄÏÄþÊÐ,ÎàÖÝÊÐ,±±º£ÊÐ,ºÓ³ØµØÇø,ÁøÖÝÊÐ
ÈȵãÎÊÌâ
¸ü¶à¾«²Ê

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