想必大家都經(jīng)歷過(guò)忘記密碼的痛苦和煩惱，明明設(shè)置的密碼是自己熟悉的密碼啊，怎么到需要的時(shí)候忘記了呢？這么重要的文件密碼忘記打不開(kāi)怎么辦？本來(lái)設(shè)置密碼，是為了保護(hù)文件的安全性，但是在用時(shí)打不開(kāi)文檔忘記密碼也挺讓人苦惱的。別著急，你們經(jīng)歷過(guò)的這些我也經(jīng)歷過(guò)，經(jīng)過(guò)我不斷的嘗試終于用下圖這個(gè)里面工具把我的密碼給破解開(kāi)來(lái)了，當(dāng)然有些人擔(dān)心工具安裝會(huì)有各種問(wèn)題，我也找到了在線處理的方法，簡(jiǎn)單又方便方法就在這里，如果分享的這幾個(gè)方法都無(wú)法幫助到你，那你可以

人

工找回（taotaops）?

（工具地址+在線工具）找回地址：找回助手.site

現(xiàn)在就來(lái)分享一下。

當(dāng)你在使用Excel工作表時(shí)忘記了密碼，不要擔(dān)心，有幾種方法可以幫助你解決這個(gè)問(wèn)題。首先，你可以嘗試使用一些常見(jiàn)的密碼，例如“123456”或“password”。如果這些方法都不奏效，你可以使用VBA宏來(lái)破解密碼。將以下代碼復(fù)制到VBA編輯器中并運(yùn)行：

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

請(qǐng)注意，這種方法可能需要一些時(shí)間來(lái)破解密碼。如果你覺(jué)得使用VBA宏太復(fù)雜，你還可以嘗試使用一些第三方軟件來(lái)破解Excel密碼。無(wú)論哪種方法，希望能夠幫助你找回忘記的Excel工作表密碼。