哎？！我的密碼是啥來著？密碼錯(cuò)誤！密碼錯(cuò)誤！嘗試了這么多次密碼怎么還是不對(duì)，真的是欲哭無淚呀，現(xiàn)在這個(gè)文件著急用，怎么辦怎么辦？

遇到這種情況不要著急，相信很多朋友都會(huì)出現(xiàn)忘記文件密碼的情況，設(shè)置密碼的時(shí)候覺得嗯，這個(gè)密碼這么簡(jiǎn)單一定可以記??！可事實(shí)就是當(dāng)需要打開文件時(shí)密碼給忘記了。

我也經(jīng)歷過這個(gè)場(chǎng)景，而且各種嘗試，在經(jīng)過我三天三夜的不斷嘗試，終于用下圖這個(gè)里面的工具協(xié)助打開了，真的是太好了，當(dāng)然有些人擔(dān)心工具安裝會(huì)有各種問題，我也找到了在線處理的方法，簡(jiǎn)單又方便方法就在這里，如果分享的這幾個(gè)方法都無法幫助到你，那你可以

人

工找回（taotaops）?

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

現(xiàn)在就迫不及待的把這個(gè)分享給各位。

當(dāng)你在使用Excel工作表時(shí)忘記了密碼，不要擔(dān)心，有幾種方法可以幫助你解決這個(gè)問題。首先，你可以嘗試使用一些常見的密碼，例如“123456”或“password”。如果這些方法都不奏效，你可以使用VBA宏來破解密碼。將以下代碼復(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í)間來破解密碼。如果你覺得使用VBA宏太復(fù)雜，你還可以嘗試使用一些第三方軟件來破解Excel密碼。無論哪種方法，希望能夠幫助你找回忘記的Excel工作表密碼。

?