如何取消Excel文件密码保护

当你忘记Excel文件的密码时，这可能会让你感到沮丧。不过，不用担心！本文将教你几种简单有效的方法，帮助你解除Excel文件的密码保护，让你重新获得对文件的访问权。

方法一：使用VBA代码解除密码

1. 打开你的Excel文件。

2. 按下 ALT + F11 打开VBA编辑器。

3. 在“插入”菜单中选择“模块”。

4. 将以下代码粘贴到模块中：

Sub PasswordBreaker() Dim i As Integer, j As Integer, k As Integer, l As Integer Dim m As Integer, n As Integer, o As Integer Dim p As Integer, q As Integer Dim r As Integer, s As Integer Dim t As Integer, u As Integer Dim v As Integer, w As Integer Dim x As Integer, y As Integer Dim z As Integer Dim password As String Dim wb As Workbook Dim ws As Worksheet Set wb = ThisWorkbook 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 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 = 65 To 66 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 password = Chr(i) & Chr(j) & Chr(k) & Chr(l) & Chr(m) & 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) On Error Resume Next wb.Worksheets(1).Unprotect password If Err.Number = 0 Then MsgBox "密码是 " & password Exit Sub End If Next Next Next Next Next Next Next Next Next Next Next Next Next Next Next Next Next Next Next Next End Sub

5. 运行代码，等待解除密码。

6. 保存文件。

方法二：使用文件恢复工具

1. 下载并安装专业的Excel密码恢复工具，如 Excel Password Recovery。

2. 打开软件并导入你的Excel文件。

3. 选择适合的破解方式（如字典攻击或暴力攻击）。

4. 开始破解，等待软件完成。

5. 获取密码后，使用密码打开文件。

方法三：备份恢复

1. 检查你的电脑或云盘是否有文件的备份版本。

2. 找到备份文件并查看是否有未加密的版本。

3. 如果有，直接使用该版本打开。

希望这些方法能帮助你成功解除Excel文件的密码保护！如果你有其他想法或解决方案，请分享给我们！更多模板可点击下方图片下载WPS查看

本文编辑：贰拾叁，来自加搜AIGC