如何取消Excel文件的打开密码

在日常工作中，我们常常会遇到需要输入密码才能打开的Excel文件。如果您忘记了密码，别担心！本文将为您提供几种简单的方法，帮助您解除Excel文件的密码保护，让您重新获得对文件的访问权限。

方法一：使用VBA代码解锁

1. 打开Excel，按下 Alt + F11 进入VBA编辑器。

2. 点击 插入 > 模块，然后在代码窗口中粘贴以下代码：

Sub PasswordBreaker() Dim i As Integer, j As Integer, 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 password As String Dim ws As Worksheet For Each ws In Worksheets On Error Resume Next For i = 65 To 90 For j = 65 To 90 For k = 65 To 90 For l = 65 To 90 For m = 65 To 90 For n = 65 To 90 For o = 65 To 90 For p = 65 To 90 For q = 65 To 90 For r = 65 To 90 For s = 65 To 90 For t = 65 To 90 For u = 65 To 90 For v = 65 To 90 For w = 65 To 90 For x = 65 To 90 For y = 65 To 90 For z = 65 To 90 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) ws.Unprotect password If ws.ProtectContents = False Then MsgBox "Password is: " & 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 Next Next Next Next Next Next Next Next Next Next Next Next Next Next Next Next End Sub

3. 关闭VBA编辑器，回到Excel，按下 F5 运行代码。

4. 如果成功，您将看到弹出窗口显示密码。

方法二：使用第三方工具

如果您觉得手动解锁复杂，可以考虑使用一些专业的Excel密码恢复工具，如 Excel Password Recovery 或 PassFab for Excel。这些工具通常具有简单的界面，并能快速解除密码保护。

方法三：使用备份文件

如果您曾经备份过Excel文件，可以尝试从备份文件中恢复数据。这是解决问题的最简单方法之一。

无论您选择哪种方法，确保在操作前备份原始文件，以避免数据丢失。希望这些方法能帮助您顺利解除Excel文件的密码保护！

欢迎您在下方分享您的想法、解决方案或问题，让我们一起交流学习！更多模板可点击下方图片下载WPS查看。

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