ئىنتىل تورى

تىزىملىتىش |كىرىش

ئىنتىل تورى › دەرۋازا › تېما كۆرۈش

excel2007 دە پارول يىشىش

يوللىغۇچى: Intil| يوللانغان ۋاقتى: 2010-9-8 02:23| كۆرۈلۈشى: 31| ئىنكاس سانى: 0

1- ھۆججەتنى ئېچىڭ.
2- 工具 دىن 宏 دىن 录制新宏 نى بېسىپ ماكرو قۇرۇڭ ، ماكرو نامىنى خالىغانچە قويۇڭ.
3- ماكرونى توختىتىڭ
4-工具 دىن 宏 دىن 宏نى بېسىپ بايىقى ماكرونى تاللاپ 编辑 نى بېسىڭ. چىققان جايدىكى كودنى تازىلاپ تۆۋەندىكى كودنى چاپلاپ كۆزنەكنى تاقاڭ.
5- 工具 دىن 宏 دىن 宏 نى بېسىپ AllInternalPasswords نى تاللاپ 运行  نى بېسىڭ، ئىككى قېتىم جەزملەشنى باسقاندىن كېيىن ئىككى مېنۇت ساقلىسىڭىز ئىش پۈتىدۇ.
  1. Public Sub AllInternalPasswords()
  2. ' Breaks worksheet and workbook structure passwords. Bob McCormick
  3. ' probably originator of base code algorithm modified for coverage
  4. ' of workbook structure / windows passwords and for multiple passwords
  5. '
  6. ' Norman Harker and JE McGimpsey 27-Dec-2002 (Version 1.1)
  7. ' Modified 2003-Apr-04 by JEM: All msgs to constants, and
  8. ' eliminate one Exit Sub (Version 1.1.1)
  9. ' Reveals hashed passwords NOT original passwords
  10. Const DBLSPACE As String = vbNewLine & vbNewLine
  11. Const AUTHORS As String = DBLSPACE & vbNewLine & _
  12. "Adapted from Bob McCormick base code by" & _
  13. "Norman Harker and JE McGimpsey"
  14. Const HEADER As String = "AllInternalPasswords User Message"
  15. Const VERSION As String = DBLSPACE & "Version 1.1.1 2003-Apr-04"
  16. Const REPBACK As String = DBLSPACE & "Please report failure " & _
  17. "to the microsoft.public.excel.programming newsgroup."
  18. Const ALLCLEAR As String = DBLSPACE & "The workbook should " & _
  19. "now be free of all password protection, so make sure you:" & _
  20. DBLSPACE & "SAVE IT NOW!" & DBLSPACE & "and also" & _
  21. DBLSPACE & "BACKUP!, BACKUP!!, BACKUP!!!" & _
  22. DBLSPACE & "Also, remember that the password was " & _
  23. "put there for a reason. Don't stuff up crucial formulas " & _
  24. "or data." & DBLSPACE & "Access and use of some data " & _
  25. "may be an offense. If in doubt, don't."
  26. Const MSGNOPWORDS1 As String = "There were no passwords on " & _
  27. "sheets, or workbook structure or windows." & AUTHORS & VERSION
  28. Const MSGNOPWORDS2 As String = "There was no protection to " & _
  29. "workbook structure or windows." & DBLSPACE & _
  30. "Proceeding to unprotect sheets." & AUTHORS & VERSION
  31. Const MSGTAKETIME As String = "After pressing OK button this " & _
  32. "will take some time." & DBLSPACE & "Amount of time " & _
  33. "depends on how many different passwords, the " & _
  34. "passwords, and your computer's specification." & DBLSPACE & _
  35. "Just be patient! Make me a coffee!" & AUTHORS & VERSION
  36. Const MSGPWORDFOUND1 As String = "You had a Worksheet " & _
  37. "Structure or Windows Password set." & DBLSPACE & _
  38. "The password found was: " & DBLSPACE & "$$" & DBLSPACE & _
  39. "Note it down for potential future use in other workbooks by " & _
  40. "the same person who set this password." & DBLSPACE & _
  41. "Now to check and clear other passwords." & AUTHORS & VERSION
  42. Const MSGPWORDFOUND2 As String = "You had a Worksheet " & _
  43. "password set." & DBLSPACE & "The password found was: " & _
  44. DBLSPACE & "$$" & DBLSPACE & "Note it down for potential " & _
  45. "future use in other workbooks by same person who " & _
  46. "set this password." & DBLSPACE & "Now to check and clear " & _
  47. "other passwords." & AUTHORS & VERSION
  48. Const MSGONLYONE As String = "Only structure / windows " & _
  49. "protected with the password that was just found." & _
  50. ALLCLEAR & AUTHORS & VERSION & REPBACK
  51. Dim w1 As Worksheet, w2 As Worksheet
  52. Dim i As Integer, j As Integer, k As Integer, l As Integer
  53. Dim m As Integer, n As Integer, i1 As Integer, i2 As Integer
  54. Dim i3 As Integer, i4 As Integer, i5 As Integer, i6 As Integer
  55. Dim PWord1 As String
  56. Dim ShTag As Boolean, WinTag As Boolean

  58. Application.ScreenUpdating = False
  59. With ActiveWorkbook
  60. WinTag = .ProtectStructure Or .ProtectWindows
  61. End With
  62. ShTag = False
  63. For Each w1 In Worksheets
  64. ShTag = ShTag Or w1.ProtectContents
  65. Next w1
  66. If Not ShTag And Not WinTag Then
  67. MsgBox MSGNOPWORDS1, vbInformation, HEADER
  68. Exit Sub
  69. End If
  70. MsgBox MSGTAKETIME, vbInformation, HEADER
  71. If Not WinTag Then
  72. MsgBox MSGNOPWORDS2, vbInformation, HEADER
  73. Else
  74. On Error Resume Next
  75. Do 'dummy do loop
  76. For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
  77. For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
  78. For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
  79. For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
  80. With ActiveWorkbook
  81. .Unprotect Chr(i) & Chr(j) & Chr(k) & _
  82. Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
  83. Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
  84. If .ProtectStructure = False And _
  85. .ProtectWindows = False Then
  86. PWord1 = Chr(i) & Chr(j) & Chr(k) & Chr(l) & _
  87. Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
  88. Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
  89. MsgBox Application.Substitute(MSGPWORDFOUND1, _
  90. "$$", PWord1), vbInformation, HEADER
  91. Exit Do 'Bypass all for...nexts
  92. End If
  93. End With
  94. Next: Next: Next: Next: Next: Next
  95. Next: Next: Next: Next: Next: Next
  96. Loop Until True
  97. On Error GoTo 0
  98. End If
  99. If WinTag And Not ShTag Then
  100. MsgBox MSGONLYONE, vbInformation, HEADER
  101. Exit Sub
  102. End If
  103. On Error Resume Next
  104. For Each w1 In Worksheets
  105. 'Attempt clearance with PWord1
  106. w1.Unprotect PWord1
  107. Next w1
  108. On Error GoTo 0
  109. ShTag = False
  110. For Each w1 In Worksheets
  111. 'Checks for all clear ShTag triggered to 1 if not.
  112. ShTag = ShTag Or w1.ProtectContents
  113. Next w1
  114. If ShTag Then
  115. For Each w1 In Worksheets
  116. With w1
  117. If .ProtectContents Then
  118. On Error Resume Next
  119. Do 'Dummy do loop
  120. For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
  121. For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
  122. For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
  123. For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
  124. .Unprotect Chr(i) & Chr(j) & Chr(k) & _
  125. Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
  126. Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
  127. If Not .ProtectContents Then
  128. PWord1 = Chr(i) & Chr(j) & Chr(k) & Chr(l) & _
  129. Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
  130. Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
  131. MsgBox Application.Substitute(MSGPWORDFOUND2, _
  132. "$$", PWord1), vbInformation, HEADER
  133. 'leverage finding Pword by trying on other sheets
  134. For Each w2 In Worksheets
  135. w2.Unprotect PWord1
  136. Next w2
  137. Exit Do 'Bypass all for...nexts
  138. End If
  139. Next: Next: Next: Next: Next: Next
  140. Next: Next: Next: Next: Next: Next
  141. Loop Until True
  142. On Error GoTo 0
  143. End If
  144. End With
  145. Next w1
  146. End If
  147. MsgBox ALLCLEAR & AUTHORS & VERSION & REPBACK, vbInformation, HEADER

  149. End Sub
مەزمۇننى كۆچۈرۈۋېلىش
باشقۇرغۇچى Intil بۇ تېمىنى يۆتكىگەن ۋاقتى تۈنۈگۈن  02:24

يېڭى ئىنكاسلار

intil.cn 因特乐 知识信息网 Uyghur Office ( 新ICP备10003688号)|ئالاقىلىشىڭ

GMT+8, 2010-9-9 22:06.

Powered by Discuz! X1(NurQut Team)

© 2001-2010 Comsenz Inc.