{"id":788,"date":"2021-11-22T12:48:00","date_gmt":"2021-11-22T04:48:00","guid":{"rendered":"https:\/\/b.yesiyu.top\/?p=788"},"modified":"2021-11-22T12:48:15","modified_gmt":"2021-11-22T04:48:15","slug":"excel%e5%b7%a5%e4%bd%9c%e8%a1%a8%e4%bf%9d%e6%8a%a4%e5%af%86%e7%a0%81%e7%a0%b4%e8%a7%a3","status":"publish","type":"post","link":"https:\/\/b.yesiyu.top\/?p=788","title":{"rendered":"EXCEL\u5de5\u4f5c\u8868\u4fdd\u62a4\u5bc6\u7801\u7834\u89e3"},"content":{"rendered":"

EXCEL\u5de5\u4f5c\u8868\u4fdd\u62a4\u5bc6\u7801\u7834\u89e3
\n\u65b9\u6cd5:
\n1\\\u6253\u5f00\u53d7\u4fdd\u62a4\u7684\u6587\u4ef6
\n2\\\u5feb\u6377\u952eAltF11
\n3\\\u63d2\u5165-\u5b8f
\n4\\\u590d\u5236\u9644\u4ef6\u4ee3\u7801
\n5\\\u8fd0\u884c-\u5b8f
\n6\\\u5173\u95ed\u7f16\u8f91\u7a97\u53e3
\n7\\\u6587\u4ef6\u5373\u53ef\u7f16\u8f91\uff0c\u65e0\u5bc6\u7801\u4fdd\u62a4<\/p>\n

\u9644\u4ef6\u4ee3\u7801
\nSub PasswordBreaker()
\n\u3000\u3000Dim i As Integer, j As Integer, k As Integer
\n\u3000\u3000Dim l As Integer, m As Integer, n As Integer
\n\u3000\u3000Dim i1 As Integer, i2 As Integer, i3 As Integer
\n\u3000\u3000Dim i4 As Integer, i5 As Integer, i6 As Integer
\n\u3000\u3000On Error Resume Next
\n\u3000\u3000For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
\n\u3000\u3000For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
\n\u3000\u3000For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
\n\u3000\u3000For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
\n\u3000\u3000ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
\n\u3000\u3000Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
\n\u3000\u3000Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
\n\u3000\u3000If ActiveSheet.ProtectContents = False Then
\n\u3000\u3000MsgBox “One usable password is ” & Chr(i) & Chr(j) & _
\n\u3000\u3000Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
\n\u3000\u3000Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
\n\u3000\u3000ActiveWorkbook.Sheets(1).Select
\n\u3000\u3000Range(“a1”).FormulaR1C1 = Chr(i) & Chr(j) & _
\n\u3000\u3000Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
\n\u3000\u3000Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
\n\u3000\u3000Exit Sub
\n\u3000\u3000End If
\n\u3000\u3000Next: Next: Next: Next: Next: Next
\n\u3000\u3000Next: Next: Next: Next: Next: Next
\n\u3000\u3000End Sub<\/p>\n","protected":false},"excerpt":{"rendered":"

EXCEL\u5de5\u4f5c\u8868\u4fdd\u62a4\u5bc6\u7801\u7834\u89e3 \u65b9\u6cd5: 1\\\u6253\u5f00\u53d7\u4fdd\u62a4\u7684\u6587\u4ef6 2\\\u5feb\u6377\u952eAltF11 3\\\u63d2\u5165-\u5b8f 4\\\u590d\u5236\u9644\u4ef6 … <\/p>\n

\u7ee7\u7eed\u9605\u8bfb\u201cEXCEL\u5de5\u4f5c\u8868\u4fdd\u62a4\u5bc6\u7801\u7834\u89e3\u201d<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-788","post","type-post","status-publish","format-standard","hentry","category-1"],"_links":{"self":[{"href":"https:\/\/b.yesiyu.top\/index.php?rest_route=\/wp\/v2\/posts\/788","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/b.yesiyu.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/b.yesiyu.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/b.yesiyu.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/b.yesiyu.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=788"}],"version-history":[{"count":1,"href":"https:\/\/b.yesiyu.top\/index.php?rest_route=\/wp\/v2\/posts\/788\/revisions"}],"predecessor-version":[{"id":789,"href":"https:\/\/b.yesiyu.top\/index.php?rest_route=\/wp\/v2\/posts\/788\/revisions\/789"}],"wp:attachment":[{"href":"https:\/\/b.yesiyu.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=788"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/b.yesiyu.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=788"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/b.yesiyu.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=788"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}