轻松去掉Excel密码，恢复您的文件访问

当您忘记了Excel文件的密码时，您可能会感到无比沮丧。不过，不用担心，本文将教您几种简单的方法来去除Excel文件中的密码，让您轻松恢复对文件的访问。

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

1. 打开您的Excel文件，按下 ALT + F11 进入VBA编辑器。

2. 在菜单中选择 插入 -> 模块。

3. 粘贴以下代码：

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 a As Integer Dim b As Integer Dim c As Integer Dim d As Integer Dim e As Integer Dim f As Integer Dim g As Integer Dim h As Integer 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 password As String Dim passwordFound As Boolean passwordFound = False 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) If password = ActiveSheet.ProtectPassword Then MsgBox "密码是: " & password passwordFound = True Exit For End If Next Next Next Next next next next next next next next next next next next next next next If Not passwordFound Then MsgBox "未找到密码" End Sub

4. 运行代码，等待程序完成。密码将被去掉。

方法二：利用另存为功能

1. 打开需要去掉密码的Excel文件。

2. 选择 文件 -> 另存为。

3. 选择保存位置，文件类型选择 Excel工作簿 (*.xlsx)。

4. 在弹出的对话框中，确保不输入任何密码，然后保存文件。

5. 打开新保存的文件，您将发现密码已被移除。

方法三：使用在线工具

1. 打开浏览器，搜索并访问一个免费的Excel密码移除工具。

2. 上传您的Excel文件。

3. 按照网站的指示操作，通常只需点击 解锁 按钮。

4. 下载无密码的Excel文件。

分享您的经验

您是否尝试过其他有效的方法？欢迎在评论区分享您的想法和经验，或者提出您遇到的问题，我们一起探讨解决方案！

更多模板可点击下方图片下载WPS查看

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