EXCEL密码破解

最新推荐文章于 2024-08-26 11:10:38 发布
最新推荐文章于 2024-08-26 11:10:38 发布
阅读量5.2k 收藏 24
点赞数 5
文章标签： excel
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_29050599/article/details/131130997
版权

方法一：VBA代码破解

右键单击身份证校验工作表，单击查看代码，如下图所示：

然后粘贴以下VBA代码，在点击运行（F5），大功告成！

Sub 密码破解()

ActiveSheet.Protect DrawingObjects:=True, CONTENTS:=True, AllowFiltering:=True

ActiveSheet.Protect DrawingObjects:=False, CONTENTS:=True, AllowFiltering:=True

ActiveSheet.Unprotect

End Sub

其实代码还不止这个

  1. Sub RemoveShProtect()

  2. Dim i1 As Integer, i2 As Integer, i3 As Integer

  3. Dim i4 As Integer, i5 As Integer, i6 As Integer

  4. Dim i7 As Integer, i8 As Integer, i9 As Integer

  5. Dim i10 As Integer, i11 As Integer, i12 As Integer

  6. Dim t As String

  7. On Error Resume Next

  8. If ActiveSheet.ProtectContents = False Then

  9. MsgBox '该工作表没有保护密码!'

  10. Exit Sub

  11. End If

  12. t = Timer

  13. For i1 = 65 To 66: For i2 = 65 To 66: For i3 = 65 To 66

  14. For i4 = 65 To 66: For i5 = 65 To 66: For i6 = 65 To 66

  15. For i7 = 65 To 66: For i8 = 65 To 66: For i9 = 65 To 66

  16. For i10 = 65 To 66: For i11 = 65 To 66: For i12 = 32 To 126

  17. ActiveSheet.Unprotect Chr(i1) & Chr(i2) & Chr(i3) & Chr(i4) & Chr(i5) _

  18. & Chr(i6) & Chr(i7) & Chr(i8) & Chr(i9) & Chr(i10) & Chr(i11) & Chr(i12)

  19. If ActiveSheet.ProtectContents = False Then

  20. MsgBox '解除工作表保护!用时' & Format(Timer - t, '0.00') & '秒'

  21. Exit Sub

  22. End If

  23. Next: Next: Next: Next: Next: Next

  24. Next: Next: Next: Next: Next: Next

  25. End Sub

方法二：将文件后缀名修改为RAR压缩文件后打开相关文件将加密代码删除进行破解

1、我们关闭工作簿，将此工作簿重命名修改文件后缀名为“rar”

2、双击打开rar文件，找到'sheet1.xml',文件路径为“xl>>worksheets>>sheet1.xml”，因为身份证验证工作表是第一个工作表，所以选择sheet1.xml，要是第二个工作表加密就选择sheet2.xml，两个都加的话就两个文件都修改。

3、双击'sheet1.xml'并用记事本打开，使用查找功能，删除“sheetProtection”字段（<>尖括号内的内容 ）

4、将文件后缀名更改回'xlsx'，大功告成！

方法三：利用插件进行破解

前面两种方法都比较繁琐，直接使用现成的插件可以随时使用！

之前在excelhome论坛上下载了一位版主的插件，里面就有破解excel密码的功能，而且功能还很强大（几乎你能想到的都有了），该插件时免费的，具体演示如下：

点击插件如图所示的工作表保护与破解按钮

最好，大家需要插件的话可以自行到excel home论坛搜索，也可以私信我索要，后台回复“常用工具插件”即可自动获取下载链接。

关于插件的使用方法：

下载解压之后是一个xlam文件，直接双击即可使用。

还有另一种方法：

耘泽
关注
解密表格代码
08-19
表格解密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受保护的单元格密码
最新发布
子墨将的博客
03-12 785
分享一个暴力破解Excel受保护的单元格密码的方法。
【技巧】Excel加锁忘密码？一文教你破解之道！
JavaDog程序狗
08-26 4037
本文讲述了两种解决Excel文件加锁且忘记密码的有效方法。首先介绍了通过VBA代码操作解锁：只需右击工作表选择“查看代码”，复制并运行特定的VBA代码即可解锁工作表。其次，通过修改文件格式为.rar压缩文件，找到xl/worksheets目录下的sheet1.xml文件，删除其中的sheetProtection标签及内容，从而解除密码保护。这两种方法简单实用，无论是技术人员还是普通用户都能轻松上手
excel破解密码
12-12
解决excel密码问题，完美破解2003 2010 2011 2012 2013版本
Excel密码破解
我的博客
07-05 1678
专注于Excel密码破解使用教程1.主界面2.进入恢复向导3.选择攻击类型4.进一步设置密码破解向导（以暴力破解为例）5.开始密码破解下载链接建议 使用教程 1.主界面 打开工具主界面，左上角添加需要破解的Excel文件 2.进入恢复向导 添加文件后就会进入密码恢复向导，点击下一步 3.选择攻击类型 -选择密码恢复的模式： 攻击方式：用过但是感觉不太明显，在对密码一无所知的情况下，可以尝试 暴力破解：用于大概知道密码是由什么组成的，或者知道密码大概范围的时候，可以自定义选项遍历破解 [注：方向比努力
Excel破解密码工具
12-18
Excel破解密码工具！！！！！！！！！！！！！！！1、打开Excel运行VBA代码页面，将上述代码输入然后按照提示点击。2、运行所创建的宏，等待片刻，文件即破解！
excel密码破解，excel密码破解
03-22
excel密码破解，excel密码破解，excel密码破解
excel密码破解
12-18
excel密码破解（97到07）.。
Excel 密码破解工具
10-25
破解加密的excl，有多种模式纯数字，数字加字符加特殊符号等等。
excel文件密码破解 密码解除　
08-15
因为不小心或长时间不用,EXCEL文件的密码忘记时,可用此软件恢复.
Excel密码破解宏
04-09
可快速破解加密的Excel文档，亲测有效，破解时先打开加密的Excel，点击菜单栏中的宏->录制宏，将附件中的代码添加进宏中，然后执行即可
excel 破解密码的宏代码
12-03
excel中破解密码时 在宏中录入的代码
破解Excel密码
07-17
该文件可以破解Excel的工作簿密码，工作表密码和VBA工程密码
【WIN】超简单的Excel密码破解
热门推荐
Jum的博客
10-26 7万+
新开一Excel，同时按Alt+F11，进入VBA界面，点菜单上的插入，模块，在新出来的窗口粘贴一下代码： Sub crack() Dim i As Long Dim FileName As String i = 0 FileName = Application.GetOpenFilename("Excel文件（*.xls &amp; *.xlsx）,*.xls;*.xlsx", , "VBA...
Excel VBA代码密码破解
Asdnwosai的博客
11-07 2万+
VBA
EXCEL VBA工程密码破解 工作表保护破解
偶尔想看云飞的博客
07-16 1万+
Excel 破解工程保护 破解工作表保护方法
评论 33
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值