如何破解excel密码

曲谱自学网今天精心准备的是《如何破解excel密码》，下面是详解！

如何破解EXCEL的打开密码

如果Excel文件的打开密码忘记了，且密码是6位数以内的数字，可用以下步骤解开（关掉所有程序，为了速度）：
新开一Excel，同时按Alt和F11，进入VBA界面，点菜单上的插入，模块，在新出来的窗口粘贴一下代码：
Sub crack()
Dim i As Long
Dim FileName As String
i = 0
FileName = Application.GetOpenFilename("Excel文件（*.xls & *.xlsx）,*.xls;*.xlsx", , "VBA破解")
FileName = Right(FileName, Len(FileName) - InStrRev(FileName, "\"))
Application.ScreenUpdating = False
line2: On Error GoTo line1
Workbooks.Open FileName, , True, , i
MsgBox "Password is " & i
Exit Sub
line1: i = i + 1
Resume line2
Application.ScreenUpdating = True
End Sub

然后在此界面直接按F5运行此宏，选择文件，等啊等（看密码长度了）

忘记EXCEL表格的密码了，如何破解？？

1、按住快捷键ALT+F11，然后切换出VBA编辑窗口，在该窗口的左侧我们的选择那个忘记密码的工作表，比如sheet 1...

2、然后我们复制以下代码“Sub Pojie()ActiveSheet.Protect AllowFiltering:=True: ActiveSheet.UnprotectEnd Sub”，双击刚才选中的sheet 1以后，在编辑窗口我们输入刚才复制的那段代码；

3、接下来依次点击“运行”-“运行宏”，在弹出的宏对话框，我们再次点击“运行”，此时原先加密的工作表就被解除密码了，重新打开以后我们会发现可以直接进去；

4、我们还可以将其更改为压缩文件，将之前.xlsx后缀更改为.zip，然后双击该压缩文件，我们依次找到“xl”-“worksheets”文件夹

5、进入到该文件夹以后，鼠标右键点击加密的那一个工作表“打开”，此时系统会以记事本的形式将其打开

6、接着以上，我们在记事本里按照Ctrl+F切换出查找，然后输入“protection”，然后我们将记事本中带有protection的那一段代码以及两边的<>符号全部删除；

7、保存为新的记事本以后，我们依旧将之前的工作簿后缀更改为.xlsx，此时被加密的文件就变成了可编辑状态，也就是说密码被破解了

如何破解excel文件密码

• 我就用我自己的加密的excel文件叫大家怎么破解清除excel密码，首先打开有自己加密的excel文档，如下图：

• excel2010和以前的版本有所不同，功能更人性化，更智能化。首先我们要做的是，加载宏文件，excel为宏设置默认是关闭的，我们要启用宏，就必须开启宏；“文件”下的子菜单”选项“

  如下图所示：

• 点击“选项”选择子菜单下“信任中心”“宏设置”在宏设置下。选择“启用所以宏”然后点击“确定”

  如下图所示：

• 点击“视图”在右下面我们会看“宏”打开宏，如下图所示：

• 现在我们就开始录制新宏，宏名：随便填，我这么久填密码，保存在：选择当前工作薄，说明可以不填。

  如下图所示：

• 我们在宏工作薄中，把一下宏程序写进去。

  Option Explicit

  Public Sub AllInternalPasswords()' Breaks worksheet and workbook structure passwords. Bob McCormick' probably originator of base code algorithm modified for coverage' of workbook structure / windows passwords and for multiple passwords'' Norman Harker and JE McGimpsey 27-Dec-2002 (Version 1.1)' Modified 2003-Apr-04 by JEM: All msgs to constants, and' eliminate one Exit Sub (Version 1.1.1)' Reveals hashed passwords NOT original passwordsConst DBLSPACE As String = vbNewLine & vbNewLineConst AUTHORS As String = DBLSPACE & vbNewLine & _"Adapted from Bob McCormick base code by" & _"Norman Harker and JE McGimpsey"Const HEADER As String = "AllInternalPasswords User Message"Const VERSION As String = DBLSPACE & "Version 1.1.1 2003-Apr-04"Const REPBACK As String = DBLSPACE & "Please report failure " & _"to the microsoft.public.excel.programming newsgroup."Const ALLCLEAR As String = DBLSPACE & "The workbook should " & _"now be free of all password protection, so make sure you:" & _DBLSPACE & "SAVE IT NOW!" & DBLSPACE & "and also" & _DBLSPACE & "BACKUP!, BACKUP!!, BACKUP!!!" & _DBLSPACE & "Also, remember that the password was " & _"put there for a reason. Don't stuff up crucial formulas " & _"or data." & DBLSPACE & "Access and use of some data " & _"may be an offense. If in doubt, don't."Const MSGNOPWORDS1 As String = "There were no passwords on " & _"sheets, or workbook structure or windows." & AUTHORS & VERSIONConst MSGNOPWORDS2 As String = "There was no protection to " & _"workbook structure or windows." & DBLSPACE & _"Proceeding to unprotect sheets." & AUTHORS & VERSIONConst MSGTAKETIME As String = "After pressing OK button this " & _"will take some time." & DBLSPACE & "Amount of time " & _"depends on how many different passwords, the " & _"passwords, and your computer's specification." & DBLSPACE & _"Just be patient! Make me a coffee!" & AUTHORS & VERSIONConst MSGPWORDFOUND1 As String = "You had a Worksheet " & _"Structure or Windows Password set." & DBLSPACE & _"The password found was: " & DBLSPACE & "$$" & DBLSPACE & _"Note it down for potential future use in other workbooks by " & _"the same person who set this password." & DBLSPACE & _"Now to check and clear other passwords." & AUTHORS & VERSIONConst MSGPWORDFOUND2 As String = "You had a Worksheet " & _"password set." & DBLSPACE & "The password found was: " & _DBLSPACE & "$$" & DBLSPACE & "Note it down for potential " & _"future use in other workbooks by same person who " & _"set this password." & DBLSPACE & "Now to check and clear " & _"other passwords." & AUTHORS & VERSIONConst MSGONLYONE As String = "Only structure / windows " & _"protected with the password that was just found." & _ALLCLEAR & AUTHORS & VERSION & REPBACKDim w1 As Worksheet, w2 As WorksheetDim i As Integer, j As Integer, k As Integer, l As IntegerDim m As Integer, n As Integer, i1 As Integer, i2 As IntegerDim i3 As Integer, i4 As Integer, i5 As Integer, i6 As IntegerDim PWord1 As StringDim ShTag As Boolean, WinTag As Boolean

  Application.ScreenUpdating = FalseWith ActiveWorkbookWinTag = .ProtectStructure Or .ProtectWindowsEnd WithShTag = FalseFor Each w1 In WorksheetsShTag = ShTag Or w1.ProtectContentsNext w1If Not ShTag And Not WinTag ThenMsgBox MSGNOPWORDS1, vbInformation, HEADERExit SubEnd IfMsgBox MSGTAKETIME, vbInformation, HEADERIf Not WinTag ThenMsgBox MSGNOPWORDS2, vbInformation, HEADERElseOn Error Resume NextDo 'dummy do loopFor i = 65 To 66: For j = 65 To 66: For k = 65 To 66For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126With ActiveWorkbook.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)If .ProtectStructure = False And _.ProtectWindows = False ThenPWord1 = Chr(i) & Chr(j) & Chr(k) & Chr(l) & _Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)MsgBox Application.Substitute(MSGPWORDFOUND1, _"$$", PWord1), vbInformation, HEADERExit Do 'Bypass all for...nextsEnd IfEnd WithNext: Next: Next: Next: Next: NextNext: Next: Next: Next: Next: NextLoop Until TrueOn Error GoTo 0End IfIf WinTag And Not ShTag ThenMsgBox MSGONLYONE, vbInformation, HEADERExit SubEnd IfOn Error Resume NextFor Each w1 In Worksheets'Attempt clearance with PWord1w1.Unprotect PWord1Next w1On Error GoTo 0ShTag = FalseFor Each w1 In Worksheets'Checks for all clear ShTag triggered to 1 if not.ShTag = ShTag Or w1.ProtectContentsNext w1If ShTag ThenFor Each w1 In WorksheetsWith w1If .ProtectContents ThenOn Error Resume NextDo 'Dummy do loopFor i = 65 To 66: For j = 65 To 66: For k = 65 To 66For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126.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)If Not .ProtectContents ThenPWord1 = Chr(i) & Chr(j) & Chr(k) & Chr(l) & _Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)MsgBox Application.Substitute(MSGPWORDFOUND2, _"$$", PWord1), vbInformation, HEADER'leverage finding Pword by trying on other sheetsFor Each w2 In Worksheetsw2.Unprotect PWord1Next w2Exit Do 'Bypass all for...nextsEnd IfNext: Next: Next: Next: Next: NextNext: Next: Next: Next: Next: NextLoop Until TrueOn Error GoTo 0End IfEnd WithNext w1End IfMsgBox ALLCLEAR & AUTHORS & VERSION & REPBACK, vbInformation, HEADEREnd Sub

• 点击菜单栏上的工具“宏”选AllInternalPasswords,执行,确定两次； 耐心等一会,再点击两次确定，

• 在此打开自己加密的excel，看看，密码是不是没有了。

如何快速破解EXCEL表格密码

工具/原料

• 快解密码读取工具(FastReader)

方法/步骤

• 准备好我们需要破解的EXCEL表格文件

• 下载快解密码读取工具(FastReader) 

• 打开快解密码读取工具(FastReader) 

• 切换到“OFFICE”选项卡，在“OFFICE文件格式”中选择“EXCEL”

• 点击“打开文件”按钮打开我们所需要破解的EXCEL文件

• 点击“快速破解”按钮，开始破解EXCEL表格密码

• 7

  等待几分钟后，提示破解成功，得到EXCEL表格的密码，我们就可以直接修改被密码保护的EXCEL表格的信息了

EXCEL表格中的密码能破解吗？

EXCEL保护工作表和保护工作薄两项都已经设置保护（密码有：字母数字和符号密码长度：10位以上）还能不能破解呢？2003版的EXCEL，不是文件的打开密码，是表格里面的公式保护密码，（保...

EXCEL 保护工作表和保护工作薄 两项都已经设置保护（密码有：字母数字和符号 密码长度：10位以上）
还能不能破解呢？
2003版的EXCEL，不是文件的打开密码，
是表格里面的公式保护密码，（保护工作表、保护工作薄密码）能破解或移除吗？？？
如果能破解，那么微软EXCEL的保护功能不是就没有用了吗？？？ 展开

打开EXCEL文件，ALLT+F11打开Visual Basic编辑器－把以下代码复制进去，然后按F5运行一遍就可以了
Public Sub AllInternalPasswords()
' Breaks worksheet and workbook structure passwords. Bob McCormick
' probably originator of base code algorithm modified for coverage
' of workbook structure / windows passwords and for multiple passwords
'
' Norman Harker and JE McGimpsey 27-Dec-2002 (Version 1.1)
' Modified 2003-Apr-04 by JEM: All msgs to constants, and
' eliminate one Exit Sub (Version 1.1.1)
' Reveals hashed passwords NOT original passwords
Const DBLSPACE As String = vbNewLine & vbNewLine
Const AUTHORS As String = DBLSPACE & vbNewLine & _
"Adapted from Bob McCormick base code by" & _
"Norman Harker and JE McGimpsey"
Const HEADER As String = "AllInternalPasswords User Message"
Const VERSION As String = DBLSPACE & "Version 1.1.1 2003-Apr-04"
Const REPBACK As String = DBLSPACE & "Please report failure " & _
"to the microsoft.public.excel.programming newsgroup."
Const ALLCLEAR As String = DBLSPACE & "The workbook should " & _
"now be free of all password protection, so make sure you:" & _
DBLSPACE & "SAVE IT NOW!" & DBLSPACE & "and also" & _
DBLSPACE & "BACKUP!, BACKUP!!, BACKUP!!!" & _
DBLSPACE & "Also, remember that the password was " & _
"put there for a reason. Don't stuff up crucial formulas " & _
"or data." & DBLSPACE & "Access and use of some data " & _
"may be an offense. If in doubt, don't."
Const MSGNOPWORDS1 As String = "There were no passwords on " & _
"sheets, or workbook structure or windows." & AUTHORS & VERSION
Const MSGNOPWORDS2 As String = "There was no protection to " & _
"workbook structure or windows." & DBLSPACE & _
"Proceeding to unprotect sheets." & AUTHORS & VERSION
Const MSGTAKETIME As String = "After pressing OK button this " & _
"will take some time." & DBLSPACE & "Amount of time " & _
"depends on how many different passwords, the " & _
"passwords, and your computer's specification." & DBLSPACE & _
"Just be patient! Make me a coffee!" & AUTHORS & VERSION
Const MSGPWORDFOUND1 As String = "You had a Worksheet " & _
"Structure or Windows Password set." & DBLSPACE & _
"The password found was: " & DBLSPACE & "$$" & DBLSPACE & _
"Note it down for potential future use in other workbooks by " & _
"the same person who set this password." & DBLSPACE & _
"Now to check and clear other passwords." & AUTHORS & VERSION
Const MSGPWORDFOUND2 As String = "You had a Worksheet " & _
"password set." & DBLSPACE & "The password found was: " & _
DBLSPACE & "$$" & DBLSPACE & "Note it down for potential " & _
"future use in other workbooks by same person who " & _
"set this password." & DBLSPACE & "Now to check and clear " & _
"other passwords." & AUTHORS & VERSION
Const MSGONLYONE As String = "Only structure / windows " & _
"protected with the password that was just found." & _
ALLCLEAR & AUTHORS & VERSION & REPBACK
Dim w1 As Worksheet, w2 As Worksheet
Dim i As Integer, j As Integer, k As Integer, l As Integer
Dim m As Integer, n As Integer, i1 As Integer, i2 As Integer
Dim i3 As Integer, i4 As Integer, i5 As Integer, i6 As Integer
Dim PWord1 As String
Dim ShTag As Boolean, WinTag As Boolean

Application.ScreenUpdating = False
With ActiveWorkbook
WinTag = .ProtectStructure Or .ProtectWindows
End With
ShTag = False
For Each w1 In Worksheets
ShTag = ShTag Or w1.ProtectContents
Next w1
If Not ShTag And Not WinTag Then
MsgBox MSGNOPWORDS1, vbInformation, HEADER
Exit Sub
End If
MsgBox MSGTAKETIME, vbInformation, HEADER
If Not WinTag Then
MsgBox MSGNOPWORDS2, vbInformation, HEADER
Else
On Error Resume Next
Do 'dummy do loop
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
With ActiveWorkbook
.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)
If .ProtectStructure = False And _
.ProtectWindows = False Then
PWord1 = Chr(i) & Chr(j) & Chr(k) & Chr(l) & _
Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
MsgBox Application.Substitute(MSGPWORDFOUND1, _
"$$", PWord1), vbInformation, HEADER
Exit Do 'Bypass all for...nexts
End If
End With
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
Loop Until True
On Error GoTo 0
End If
If WinTag And Not ShTag Then
MsgBox MSGONLYONE, vbInformation, HEADER
Exit Sub
End If
On Error Resume Next
For Each w1 In Worksheets
'Attempt clearance with PWord1
w1.Unprotect PWord1
Next w1
On Error GoTo 0
ShTag = False
For Each w1 In Worksheets
'Checks for all clear ShTag triggered to 1 if not.
ShTag = ShTag Or w1.ProtectContents
Next w1
If ShTag Then
For Each w1 In Worksheets
With w1
If .ProtectContents Then
On Error Resume Next
Do 'Dummy do loop
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
.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)
If Not .ProtectContents Then
PWord1 = Chr(i) & Chr(j) & Chr(k) & Chr(l) & _
Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
MsgBox Application.Substitute(MSGPWORDFOUND2, _
"$$", PWord1), vbInformation, HEADER
'leverage finding Pword by trying on other sheets
For Each w2 In Worksheets
w2.Unprotect PWord1
Next w2
Exit Do 'Bypass all for...nexts
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
Loop Until True
On Error GoTo 0
End If
End With
Next w1
End If
MsgBox ALLCLEAR & AUTHORS & VERSION & REPBACK, vbInformation, HEADER
End Sub

如何破解excel文档密码破解

工具：5秒WORD-EXCEL密码破解.exe
步骤如下：
1、百度“5秒WORD-EXCEL密码破解”，点击下方的连接，下载软件，软件不是很大，直接下载下来就可以了，下载下来是一个压缩包，解压该压缩包。打开压缩包解压出来的文件夹，第二个文件就是我们的密码破解工具，双击打开工具。
2、浏览，找到我们要破解的文件，点击确定，破解就开始啦。点击移除密码。
3、弹出对话框，点击确定，当然，电脑是要能联网的，相信你能看到这篇经验，电脑应该也是能联网的。
4、解密时间要看密码复杂程度，不过应该没有太变态的密码。
5、成功破解密码，并且生成了一个新的没有密码的文件。

excel密码怎么破解？

操作方法：

• 01

  打开excel工作表。

• 02

  然后在Excel表中找到【视图】。

• 03

  点开【宏】。

• 04

  然后选择【录制宏】。

• 05

  接着会弹出一个窗口，点击【确定】。

• 06

  在此点开【宏】，点击【停止录制】。

• 07

  然后再点击【宏】，弹出窗口点击【编辑】。

• 08

  然后点击【模板1】，并清空右边红框里的代码，如下图。

• 09

  然后把破解代码复制粘贴进入空白处（破解代码小编将在文章最底部分享给大家）。

• 10

  然后在打开【查看宏】，点击执行破解代码。

• 11

  会弹出一个框，是英文的，看不懂没关系，点击确定，解密需要一段时间。

• 12

  破解代码:
  Public Sub AllInternalPasswords() 
  ' Breaks worksheet and workbook structure passwords. Bob McCormick 
  ' probably originator of base code algorithm modified for coverage 
  ' of workbook structure / windows passwords and for multiple passwords 
  ' 
  ' Norman Harker and JE McGimpsey 27-Dec-2002 (Version 1.1) 
  ' Modified 2003-Apr-04 by JEM: All msgs to constants, and 
  ' eliminate one Exit Sub (Version 1.1.1) 
  ' Reveals hashed passwords NOT original passwords 
  Const DBLSPACE As String = vbNewLine & vbNewLine 
  Const AUTHORS As String = DBLSPACE & vbNewLine & _ 
  "Adapted from Bob McCormick base code by" & _ 
  "Norman Harker and JE McGimpsey" 
  Const HEADER As String = "AllInternalPasswords User Message" 
  Const VERSION As String = DBLSPACE & "Version 1.1.1 2003-Apr-04" 
  Const REPBACK As String = DBLSPACE & "Please report failure " & _ 
  "to the microsoft.public.excel.programming newsgroup." 
  Const ALLCLEAR As String = DBLSPACE & "The workbook should " & _ 
  "now be free of all password protection, so make sure you:" & _ 
  DBLSPACE & "SAVE IT NOW!" & DBLSPACE & "and also" & _ 
  DBLSPACE & "BACKUP!, BACKUP!!, BACKUP!!!" & _ 
  DBLSPACE & "Also, remember that the password was " & _ 
  "put there for a reason. Don't stuff up crucial formulas " & _ 
  "or data." & DBLSPACE & "Access and use of some data " & _ 
  "may be an offense. If in doubt, don't." 
  Const MSGNOPWORDS1 As String = "There were no passwords on " & _ 
  "sheets, or workbook structure or windows." & AUTHORS & VERSION 
  Const MSGNOPWORDS2 As String = "There was no protection to " & _ 
  "workbook structure or windows." & DBLSPACE & _ 
  "Proceeding to unprotect sheets." & AUTHORS & VERSION 
  Const MSGTAKETIME As String = "After pressing OK button this " & _ 
  "will take some time." & DBLSPACE & "Amount of time " & _ 
  "depends on how many different passwords, the " & _ 
  "passwords, and your computer's specification." & DBLSPACE & _ 
  "Just be patient! Make me a coffee!" & AUTHORS & VERSION 
  Const MSGPWORDFOUND1 As String = "You had a Worksheet " & _ 
  "Structure or Windows Password set." & DBLSPACE & _ 
  "The password found was: " & DBLSPACE & "" & DBLSPACE & _ 
  "Note it down for potential future use in other workbooks by " & _ 
  "the same person who set this password." & DBLSPACE & _ 
  "Now to check and clear other passwords." & AUTHORS & VERSION 
  Const MSGPWORDFOUND2 As String = "You had a Worksheet " & _ 
  "password set." & DBLSPACE & "The password found was: " & _ 
  DBLSPACE & "" & DBLSPACE & "Note it down for potential " & _ 
  "future use in other workbooks by same person who " & _ 
  "set this password." & DBLSPACE & "Now to check and clear " & _ 
  "other passwords." & AUTHORS & VERSION 
  Const MSGONLYONE As String = "Only structure / windows " & _ 
  "protected with the password that was just found." & _ 
  ALLCLEAR & AUTHORS & VERSION & REPBACK 
  Dim w1 As Worksheet, w2 As Worksheet 
  Dim i As Integer, j As Integer, k As Integer, l As Integer 
  Dim m As Integer, n As Integer, i1 As Integer, i2 As Integer 
  Dim i3 As Integer, i4 As Integer, i5 As Integer, i6 As Integer 
  Dim PWord1 As String 
  Dim ShTag As Boolean, WinTag As Boolean 
  
  Application.ScreenUpdating = False 
  With ActiveWorkbook 
  WinTag = .ProtectStructure Or .ProtectWindows 
  End With 
  ShTag = False 
  For Each w1 In Worksheets 
  ShTag = ShTag Or w1.ProtectContents 
  Next w1 
  If Not ShTag And Not WinTag Then 
  MsgBox MSGNOPWORDS1, vbInformation, HEADER 
  Exit Sub 
  End If 
  MsgBox MSGTAKETIME, vbInformation, HEADER 
  If Not WinTag Then 
  MsgBox MSGNOPWORDS2, vbInformation, HEADER 
  Else 
  On Error Resume Next 
  Do 'dummy do loop 
  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 
  With ActiveWorkbook 
  .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) 
  If .ProtectStructure = False And _ 
  .ProtectWindows = False Then 
  PWord1 = Chr(i) & Chr(j) & Chr(k) & Chr(l) & _ 
  Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _ 
  Chr(i4) & Chr(i5) & Chr(i6) & Chr(n) 
  MsgBox Application.Substitute(MSGPWORDFOUND1, _ 
  "", PWord1), vbInformation, HEADER 
  Exit Do 'Bypass all for...nexts 
  End If 
  End With 
  Next: Next: Next: Next: Next: Next 
  Next: Next: Next: Next: Next: Next 
  Loop Until True 
  On Error GoTo 0 
  End If 
  If WinTag And Not ShTag Then 
  MsgBox MSGONLYONE, vbInformation, HEADER 
  Exit Sub 
  End If 
  On Error Resume Next 
  For Each w1 In Worksheets 
  'Attempt clearance with PWord1 
  w1.Unprotect PWord1 
  Next w1 
  On Error GoTo 0 
  ShTag = False 
  For Each w1 In Worksheets 
  'Checks for all clear ShTag triggered to 1 if not. 
  ShTag = ShTag Or w1.ProtectContents 
  Next w1 
  If ShTag Then 
  For Each w1 In Worksheets 
  With w1 
  If .ProtectContents Then 
  On Error Resume Next 
  Do 'Dummy do loop 
  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 
  .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) 
  If Not .ProtectContents Then 
  PWord1 = Chr(i) & Chr(j) & Chr(k) & Chr(l) & _ 
  Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _ 
  Chr(i4) & Chr(i5) & Chr(i6) & Chr(n) 
  MsgBox Application.Substitute(MSGPWORDFOUND2, _ 
  "", PWord1), vbInformation, HEADER 
  'leverage finding Pword by trying on other sheets 
  For Each w2 In Worksheets 
  w2.Unprotect PWord1 
  Next w2 
  Exit Do 'Bypass all for...nexts 
  End If 
  Next: Next: Next: Next: Next: Next 
  Next: Next: Next: Next: Next: Next 
  Loop Until True 
  On Error GoTo 0 
  End If 
  End With 
  Next w1 
  End If 
  MsgBox ALLCLEAR & AUTHORS & VERSION & REPBACK, vbInformation, HEADER 
  End Sub

我的excel表格密码忘记了，怎么解密啊

excel表格密码忘记后的解密步骤如下：

1.按住快捷键ALT+F11，然后切换出VBA编辑窗口，如图一；在该窗口的左侧我们的选择那个忘记密码的工作表，比如sheet 1。

2.然后我们复制以下代码

“Sub Pojie()ActiveSheet.Protect AllowFiltering:=True: ActiveSheet.UnprotectEnd Sub”，双击刚才选中的sheet 1以后，在编辑窗口我们输入刚才复制的那段代码。

3.接下来依次点击“运行”-“运行宏”。

4.在弹出的宏对话框，我们再次点击“运行”，此时原先加密的工作表就被解除密码了，重新打开以后我们会发现可以直接进去。这样就解决了excel表格密码忘记后的解密问题了。

excel密码破解

操作方法：

• 01

  打开excel工作表。

• 02

  然后在Excel表中找到【视图】。

• 03

  点开【宏】。

• 04

  然后选择【录制宏】。

• 05

  接着会弹出一个窗口，点击【确定】。

• 06

  在此点开【宏】，点击【停止录制】。

• 07

  然后再点击【宏】，弹出窗口点击【编辑】。

• 08

  然后点击【模板1】，并清空右边红框里的代码，如下图。

• 09

  然后把破解代码复制粘贴进入空白处（破解代码小编将在文章最底部分享给大家）。

• 10

  然后在打开【查看宏】，点击执行破解代码。

• 11

  会弹出一个框，是英文的，看不懂没关系，点击确定，解密需要一段时间。

• 12

  破解代码:
  Public Sub AllInternalPasswords() 
  ' Breaks worksheet and workbook structure passwords. Bob McCormick 
  ' probably originator of base code algorithm modified for coverage 
  ' of workbook structure / windows passwords and for multiple passwords 
  ' 
  ' Norman Harker and JE McGimpsey 27-Dec-2002 (Version 1.1) 
  ' Modified 2003-Apr-04 by JEM: All msgs to constants, and 
  ' eliminate one Exit Sub (Version 1.1.1) 
  ' Reveals hashed passwords NOT original passwords 
  Const DBLSPACE As String = vbNewLine & vbNewLine 
  Const AUTHORS As String = DBLSPACE & vbNewLine & _ 
  "Adapted from Bob McCormick base code by" & _ 
  "Norman Harker and JE McGimpsey" 
  Const HEADER As String = "AllInternalPasswords User Message" 
  Const VERSION As String = DBLSPACE & "Version 1.1.1 2003-Apr-04" 
  Const REPBACK As String = DBLSPACE & "Please report failure " & _ 
  "to the microsoft.public.excel.programming newsgroup." 
  Const ALLCLEAR As String = DBLSPACE & "The workbook should " & _ 
  "now be free of all password protection, so make sure you:" & _ 
  DBLSPACE & "SAVE IT NOW!" & DBLSPACE & "and also" & _ 
  DBLSPACE & "BACKUP!, BACKUP!!, BACKUP!!!" & _ 
  DBLSPACE & "Also, remember that the password was " & _ 
  "put there for a reason. Don't stuff up crucial formulas " & _ 
  "or data." & DBLSPACE & "Access and use of some data " & _ 
  "may be an offense. If in doubt, don't." 
  Const MSGNOPWORDS1 As String = "There were no passwords on " & _ 
  "sheets, or workbook structure or windows." & AUTHORS & VERSION 
  Const MSGNOPWORDS2 As String = "There was no protection to " & _ 
  "workbook structure or windows." & DBLSPACE & _ 
  "Proceeding to unprotect sheets." & AUTHORS & VERSION 
  Const MSGTAKETIME As String = "After pressing OK button this " & _ 
  "will take some time." & DBLSPACE & "Amount of time " & _ 
  "depends on how many different passwords, the " & _ 
  "passwords, and your computer's specification." & DBLSPACE & _ 
  "Just be patient! Make me a coffee!" & AUTHORS & VERSION 
  Const MSGPWORDFOUND1 As String = "You had a Worksheet " & _ 
  "Structure or Windows Password set." & DBLSPACE & _ 
  "The password found was: " & DBLSPACE & "" & DBLSPACE & _ 
  "Note it down for potential future use in other workbooks by " & _ 
  "the same person who set this password." & DBLSPACE & _ 
  "Now to check and clear other passwords." & AUTHORS & VERSION 
  Const MSGPWORDFOUND2 As String = "You had a Worksheet " & _ 
  "password set." & DBLSPACE & "The password found was: " & _ 
  DBLSPACE & "" & DBLSPACE & "Note it down for potential " & _ 
  "future use in other workbooks by same person who " & _ 
  "set this password." & DBLSPACE & "Now to check and clear " & _ 
  "other passwords." & AUTHORS & VERSION 
  Const MSGONLYONE As String = "Only structure / windows " & _ 
  "protected with the password that was just found." & _ 
  ALLCLEAR & AUTHORS & VERSION & REPBACK 
  Dim w1 As Worksheet, w2 As Worksheet 
  Dim i As Integer, j As Integer, k As Integer, l As Integer 
  Dim m As Integer, n As Integer, i1 As Integer, i2 As Integer 
  Dim i3 As Integer, i4 As Integer, i5 As Integer, i6 As Integer 
  Dim PWord1 As String 
  Dim ShTag As Boolean, WinTag As Boolean 
  
  Application.ScreenUpdating = False 
  With ActiveWorkbook 
  WinTag = .ProtectStructure Or .ProtectWindows 
  End With 
  ShTag = False 
  For Each w1 In Worksheets 
  ShTag = ShTag Or w1.ProtectContents 
  Next w1 
  If Not ShTag And Not WinTag Then 
  MsgBox MSGNOPWORDS1, vbInformation, HEADER 
  Exit Sub 
  End If 
  MsgBox MSGTAKETIME, vbInformation, HEADER 
  If Not WinTag Then 
  MsgBox MSGNOPWORDS2, vbInformation, HEADER 
  Else 
  On Error Resume Next 
  Do 'dummy do loop 
  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 
  With ActiveWorkbook 
  .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) 
  If .ProtectStructure = False And _ 
  .ProtectWindows = False Then 
  PWord1 = Chr(i) & Chr(j) & Chr(k) & Chr(l) & _ 
  Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _ 
  Chr(i4) & Chr(i5) & Chr(i6) & Chr(n) 
  MsgBox Application.Substitute(MSGPWORDFOUND1, _ 
  "", PWord1), vbInformation, HEADER 
  Exit Do 'Bypass all for...nexts 
  End If 
  End With 
  Next: Next: Next: Next: Next: Next 
  Next: Next: Next: Next: Next: Next 
  Loop Until True 
  On Error GoTo 0 
  End If 
  If WinTag And Not ShTag Then 
  MsgBox MSGONLYONE, vbInformation, HEADER 
  Exit Sub 
  End If 
  On Error Resume Next 
  For Each w1 In Worksheets 
  'Attempt clearance with PWord1 
  w1.Unprotect PWord1 
  Next w1 
  On Error GoTo 0 
  ShTag = False 
  For Each w1 In Worksheets 
  'Checks for all clear ShTag triggered to 1 if not. 
  ShTag = ShTag Or w1.ProtectContents 
  Next w1 
  If ShTag Then 
  For Each w1 In Worksheets 
  With w1 
  If .ProtectContents Then 
  On Error Resume Next 
  Do 'Dummy do loop 
  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 
  .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) 
  If Not .ProtectContents Then 
  PWord1 = Chr(i) & Chr(j) & Chr(k) & Chr(l) & _ 
  Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _ 
  Chr(i4) & Chr(i5) & Chr(i6) & Chr(n) 
  MsgBox Application.Substitute(MSGPWORDFOUND2, _ 
  "", PWord1), vbInformation, HEADER 
  'leverage finding Pword by trying on other sheets 
  For Each w2 In Worksheets 
  w2.Unprotect PWord1 
  Next w2 
  Exit Do 'Bypass all for...nexts 
  End If 
  Next: Next: Next: Next: Next: Next 
  Next: Next: Next: Next: Next: Next 
  Loop Until True 
  On Error GoTo 0 
  End If 
  End With 
  Next w1 
  End If 
  MsgBox ALLCLEAR & AUTHORS & VERSION & REPBACK, vbInformation, HEADER 
  End Sub

怎样破解EXCEL加密文件

不小心把自己EXCEL文件的密码给忘记啦，拜求高人能指点一二...谢谢！！！...

不小心把自己EXCEL文件的密码给忘记啦，拜求高人能指点一二...谢谢！！！

工具：5秒WORD-EXCEL密码破解.exe
步骤如下：
1、百度“5秒WORD-EXCEL密码破解”，点击下方的连接，下载软件，软件不是很大，直接下载下来就可以了，下载下来是一个压缩包，解压该压缩包。打开压缩包解压出来的文件夹，第二个文件就是我们的密码破解工具，双击打开工具。
2、浏览，找到我们要破解的文件，点击确定，破解就开始啦。点击移除密码。
3、弹出对话框，点击确定，当然，电脑是要能联网的，相信你能看到这篇经验，电脑应该也是能联网的。
4、解密时间要看密码复杂程度，不过应该没有太变态的密码。
5、成功破解密码，并且生成了一个新的没有密码的文件。

破解（汉语词语）

破解，拼音pò jiě，揭破，解开，解决等。