哎？！我的密码是啥来着？密码错误！密码错误！尝试了这么多次密码怎么还是不对，真的是欲哭无泪呀，现在这个文件着急用，怎么办怎么办？
遇到这种情况不要着急，相信很多朋友都会出现忘记文件密码的情况，设置密码的时候觉得嗯，这个密码这么简单一定可以记住！可事实就是当需要打开文件时密码给忘记了。
我也经历过这个场景，而且各种尝试，在经过我三天三夜的不断尝试，终于用下图这个里面的工具协助打开了，真的是太好了，当然有些人担心工具安装会有各种问题，我也找到了在线处理的方法，简单又方便方法就在这里，如果分享的这几个方法都无法帮助到你，那你可以
人
工找回（taotaops）
找回地址：找回助手.site
现在就迫不及待的把这个分享给各位。
当你在使用Excel工作表时忘记了密码，不要担心，有几种方法可以帮助你解决这个问题。首先，你可以尝试使用一些常见的密码，例如“123456”或“password”。如果这些方法都不奏效，你可以使用VBA宏来破解密码。将以下代码复制到VBA编辑器中并运行：
Sub PasswordBreaker()
Dim i As Integer
Dim j As Integer
Dim k As Integer
Dim l As Integer
Dim m As Integer
Dim n As Integer
Dim o As Integer
Dim p As Integer
Dim q As Integer
Dim r As Integer
Dim s As Integer
Dim t As Integer
Dim u As Integer
Dim v As Integer
Dim w As Integer
Dim x As Integer
Dim y As Integer
Dim z As Integer
Dim aa As Integer
Dim ab As Integer
Dim ac As Integer
Dim ad As Integer
Dim ae As Integer
Dim af As Integer
Dim ag As Integer
Dim ah As Integer
Dim ai As Integer
Dim aj As Integer
Dim ak As Integer
Dim al As Integer
Dim am As Integer
Dim an As Integer
Dim ao As Integer
Dim ap As Integer
Dim aq As Integer
On Error Resume Next
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 66
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 = 65 To 66
For o = 65 To 66: For p = 65 To 66: For q = 65 To 66
For r = 65 To 66: For s = 65 To 66: For t = 32 To 126
For u = 65 To 66: For v = 65 To 66: For w = 65 To 66
For x = 65 To 66: For y = 65 To 66: For z = 65 To 66
For aa = 65 To 66: For ab = 65 To 66: For ac = 65 To 66
For ad = 65 To 66: For ae = 65 To 66: For af = 65 To 66
For ag = 65 To 66: For ah = 65 To 66: For ai = 65 To 66
For aj = 65 To 66: For ak = 65 To 66: For al = 65 To 66
For am = 65 To 66: For an = 65 To 66: For ao = 65 To 66
For ap = 65 To 66: For aq = 65 To 66: For i7 = 65 To 66
For i8 = 65 To 66: For i9 = 65 To 66: For i10 = 32 To 126
ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n) & Chr(o) & _
Chr(p) & Chr(q) & Chr(r) & Chr(s) & Chr(t) & _
Chr(u) & Chr(v) & Chr(w) & Chr(x) & Chr(y) & _
Chr(z) & Chr(aa) & Chr(ab) & Chr(ac) & Chr(ad) & _
Chr(ae) & Chr(af) & Chr(ag) & Chr(ah) & Chr(ai) & _
Chr(aj) & Chr(ak) & Chr(al) & Chr(am) & Chr(an) & _
Chr(ao) & Chr(ap) & Chr(aq) & Chr(i7) & Chr(i8) & _
Chr(i9) & Chr(i10)
If ActiveSheet.ProtectContents = False Then
MsgBox "密码已破解：" & Chr(i) & Chr(j) & _
Chr(k) & Chr(l) & Chr(m) & Chr(i1) & _
Chr(i2) & Chr(i3) & Chr(i4) & Chr(i5) & _
Chr(i6) & Chr(n) & Chr(o) & Chr(p) & _
Chr(q) & Chr(r) & Chr(s) & Chr(t) & _
Chr(u) & Chr(v) & Chr(w) & Chr(x) & _
Chr(y) & Chr(z) & Chr(aa) & Chr(ab) & _
Chr(ac) & Chr(ad) & Chr(ae) & Chr(af) & _
Chr(ag) & Chr(ah) & Chr(ai) & Chr(aj) & _
Chr(ak) & Chr(al) & Chr(am) & Chr(an) & _
Chr(ao) & Chr(ap) & Chr(aq) & Chr(i7) & _
Chr(i8) & Chr(i9) & Chr(i10)
Exit Sub
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
End Sub
请注意，这种方法可能需要一些时间来破解密码。如果你觉得使用VBA宏太复杂，你还可以尝试使用一些第三方软件来破解Excel密码。无论哪种方法，希望能够帮助你找回忘记的Excel工作表密码。
标签： excel
