Public Sub 工作表保护密码破解() C(CwsdlP
Const DBLSPACE As String = vbNewLine & vbNewLine <qGxkV
Const AUTHORS As String = DBLSPACE & vbNewLine & _ .>#X *u
"作者:XXXXXXX" Op()`x
m
Const HEADER As String = "工作表保护密码破解"
$Mg[e*ct
Const VERSION As String = DBLSPACE & "版本 Version 1.1.1" g'cLc5\
Const REPBACK As String = DBLSPACE & "" mHe[
NkY6
Const ZHENGLI As String = DBLSPACE & " XXXXXXX" V#X#rDfJZ
Const ALLCLEAR As String = DBLSPACE & "该工作簿中的工作表密码保护已全部解除!!" & DBLSPACE & "请记得另保存" _ ba-4V8w
& DBLSPACE & "注意:不要用在不当地方,要尊重他人的劳动成果!" . n[;H;
Const MSGNOPWORDS1 As String = "该文件工作表中没有加密" )OHGg
Const MSGNOPWORDS2 As String = "该文件工作表中没有加密2" bT>MZK8b
Const MSGTAKETIME As String = "解密需花费一定时间,请耐心等候!" & DBLSPACE & "按确定开始破解!" #{_iNr a9
Const MSGPWORDFOUND1 As String = "密码重新组合为:" & DBLSPACE & "$$" & DBLSPACE & _ /U26IbJ
"如果该文件工作表有不同密码,将搜索下一组密码并修改清除" (vP<}
Const MSGPWORDFOUND2 As String = "密码重新组合为:" & DBLSPACE & "$$" & DBLSPACE & _ )iX2r{
"如果该文件工作表有不同密码,将搜索下一组密码并解除" /_SQKpic
Const MSGONLYONE As String = "确保为唯一的?" 2ieyU5q7#
Dim w1 As Worksheet, w2 As Worksheet ibH!bS{
Dim i As Integer, j As Integer, k As Integer, l As Integer @cB7tY*Ski
Dim m As Integer, n As Integer, i1 As Integer, i2 As Integer
r)S:-wP
Dim i3 As Integer, i4 As Integer, i5 As Integer, i6 As Integer w.VjGPp
Dim PWord1 As String 0:I[;Qt
Dim ShTag As Boolean, WinTag As Boolean "hid3"G
Application.ScreenUpdating = False sGFvSW
With ActiveWorkbook "w&IO}j;=
WinTag = .ProtectStructure Or .ProtectWindows %>'Zy6C<j
End With Oh# z zo
ShTag = False ?7=c`
For Each w1 In Worksheets |xawguJ
ShTag = ShTag Or w1.ProtectContents 4SVIdSA
Next w1 ~ Y/:]&wF
If Not ShTag And Not WinTag Then j%+>y;).
MsgBox MSGNOPWORDS1, vbInformation, HEADER OEw#;l4 C
Exit Sub uM)#T*(
End If {ty)2
MsgBox MSGTAKETIME, vbInformation, HEADER Znw3P|>B
If Not WinTag Then y>^FKN/
Else 8+i=u"<
On Error Resume Next 8Sxk[`qx\K
Do 'dummy do loop Ty<."dyPW
For i = 65 To 66: For j = 65 To 66: For k = 65 To 66 bT7+$^NHf
For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66 unKPqc%q=n
For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66 A=W:}szt]
For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126 r[g
With ActiveWorkbook f+!k:}K
.Unprotect Chr(i) & Chr(j) & Chr(k) & _ xO[V>Ud
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
)Fgu'
Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n) 'uC=xG.*}
If .ProtectStructure = False And _ y0f:N
U
.ProtectWindows = False Then W{m_yEOf
PWord1 = Chr(i) & Chr(j) & Chr(k) & Chr(l) & _ R_W6}
Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _ &NKb},~
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n) fn#qcZv?
MsgBox Application.Substitute(MSGPWORDFOUND1, _ 5o6X.sC8e
"$$", PWord1), vbInformation, HEADER mUj_V#v
Exit Do 'Bypass all for...nexts mqtX7rej
End If PctXh, =
End With <@Z`<T6
Next: Next: Next: Next: Next: Next mq}V @H5
Next: Next: Next: Next: Next: Next JR_%v=n~x
Loop Until True n
g%~mt
On Error GoTo 0 !mZDukfjQ
End If .^dtdFZ8,
If WinTag And Not ShTag Then S86,m=
MsgBox MSGONLYONE, vbInformation, HEADER \&_pI2X
Exit Sub ?wP/l
End If po\(O8#5U
On Error Resume Next ]!q>@b
For Each w1 In Worksheets 2cEvsvw>
'Attempt clearance with PWord1 BItH0r7
w1.Unprotect PWord1 "%}24t%
Next w1 RDfvD|}VN
On Error GoTo 0 GXaPfC0-y
ShTag = False )x+P9|
For Each w1 In Worksheets @r&*Qsf|
'Checks for all clear ShTag triggered to 1 if not. j*\oK@
ShTag = ShTag Or w1.ProtectContents !He_f-eZ
Next w1 Nj;5iy
If ShTag Then a8$4
For Each w1 In Worksheets nuH=pIq6x
With w1 NX4G;+6
If .ProtectContents Then YdDP;,
DA
On Error Resume Next c=,HLHpFO(
Do 'Dummy do loop VBUrtx:
For i = 65 To 66: For j = 65 To 66: For k = 65 To 66 A(_HMqA]
For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66 GQ(*k)'a
For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66 nz|6CP
For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126 x(n|zp ("
.Unprotect Chr(i) & Chr(j) & Chr(k) & _ e@Mg9VwDc
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _ v%rmfI U
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n) 3n,jrX75u
If Not .ProtectContents Then vBzUuX
PWord1 = Chr(i) & Chr(j) & Chr(k) & Chr(l) & _ cO$xT;kK
Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _ B"YN+So
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n) jB<B_"
MsgBox Application.Substitute(MSGPWORDFOUND2, _ gky+.EP.
"$$", PWord1), vbInformation, HEADER 3xk_ZK82
'leverage finding Pword by trying on other sheets ZIN1y;dJ
For Each w2 In Worksheets 4VF4 8
w2.Unprotect PWord1 ,eGguNA9
Next w2 J}NMF#w/;
Exit Do 'Bypass all for...nexts GKc?
End If EXMW,
Next: Next: Next: Next: Next: Next en>n\;U
Next: Next: Next: Next: Next: Next Q6T"8K/
Loop Until True > ^=n|%
On Error GoTo 0 Fr~\ZL
End If ~R&rQJJeJ
End With 5S<Rz) 1r
Next w1 :.9Y
End If IaZmN.k*
MsgBox ALLCLEAR & AUTHORS & VERSION & REPBACK & ZHENGLI, vbInformation, HEADER x<h|$$4S
End Sub L{&>,ww