excel表格密码忘了怎么办

Excel表格是我们日常工作中经常使用的工具，但是有时候我们会因为太多密码而忘记了其中一个密码，这时候该怎么办呢？下面就来介绍一些解决方法。

方法一：使用VBA代码

如果你是使用自己的电脑打开Excel表格，那么可以使用VBA代码来解锁表格。首先按下Alt F11键进入VBA编辑器，然后在左侧窗口中找到你需要解锁的表格所在的工作簿，点击它，再点击“模块”按钮，在弹出的窗口中输入以下代码：

Sub PasswordBreaker()
    Dim i As Integer, j As Integer, k As Integer
    Dim l As Integer, m As Integer, n As Integer
    Dim i1 As Integer, i2 As Integer, i3 As Integer
    Dim i4 As Integer, i5 As Integer, i6 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 = 32 To 126
    ActiveSheet.Unprotect Chr(i)