欢迎光临散文网 会员登陆 & 注册

excel密码破解,服务器高速破解

2022-12-03 10:10 作者:虔诚的RMB信徒  | 我要投稿

有时候我们会遇到excel无法编辑需要输入密码的情况,那么遇到这种问题如何解决呢?

人工破解微信:jiugee8 先解密10米起


步骤如下:

1.点击“视图”,找到【宏】,点击“查看宏”

(也可以去开发工具菜单栏找到'宏')


2.先随便创建一个宏名,点击“创建”


3.创建后,会弹出一个vb界面,输入如下代码:(感谢大佬赐予代码)excel密码破解

Public Sub Password_cracking()Const DBLSPACE As String = vbNewLine & vbNewLineConst AUTHORS As String = DBLSPACE & vbNewLine & _"                      Author - jnxxhzz "Const HEADER As String = "Password_cracking"Const VERSION As String = DBLSPACE & "                      Version 1.0"Const REPBACK As String = DBLSPACE & ""Const ZHENGLI As String = DBLSPACE & ""Const ALLCLEAR As String = DBLSPACE & "All password is clear" & DBLSPACE & "Please remember to save"Const MSGNOPWORDS1 As String = "No password!"Const MSGNOPWORDS2 As String = "No password!"Const MSGTAKETIME As String = "This will take some time , please wait for a while" & DBLSPACE & "Press next to start"Const MSGPWORDFOUND1 As String = "Password is : " & DBLSPACE & "$$" & DBLSPACE & _"If the file worksheet has a different password, it will search for the next set of passwords and release"Const MSGPWORDFOUND2 As String = "Password is : " & DBLSPACE & "$$" & DBLSPACE & _"If the file worksheet has a different password, it will search for the next set of passwords and release"Const MSGONLYONE As String = ""Dim 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 BooleanApplication.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 ThenElseOn 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 & ZHENGLI, vbInformation, HEADEREnd Sub


3.之后关闭这个vb界面,打开“查看宏”,会出现“Password_cracking”,点击执行便开始破解

excel密码破解


4.出现这个就一路点击确定,就破解啦~可以愉快的编辑了,如果出现卡顿的情况,那就是excel禁用了宏,需要手动打开允许,关于这个,下期我会出一期视频更详细的讲解!请持续关注



在Excel中为文件加密后,不小心被人知道了密码,该怎么修改或者怎么解除呢?本期,小编将为大家继续介绍文件密码解除和修改操作方法。excel密码破解

本文针对零基础的同学讲解详细步骤,有基础的可以翻到后面直接看公式和方法。

具体操作如下:

1打开一个加密的工作表,弹出“密码”对话框,如下图所示。

2因有密码保护,所以这里需要输入密码(文件密码是123),输入后,单击“确定”按钮,如下图所示。excel密码破解

3执行操作后,即可打开加密文件,单击“文件”命令,如下图所示。

4进入主界面,单击“信息”命令,进入“信息”界面,如下图所示。excel密码破解

5单击“保护工作簿”按钮,如下图所示。

6弹出列表框,选择“用密码进行加密”选项,如下图所示。excel密码破解

7执行操作后,弹出“加密文档”对话框,如下图所示。

8在“密码”文本框中,删除原来的密码,如下图所示。

9此时,如果需要修改密码,可以重新输入密码,如果需要解除密码,即可直接单击“确定”按钮,如下图所示。excel密码破解

10返回“信息”界面,此时“保护工作簿”按钮右侧已恢复为白色底纹显示,表示工作表的密码保护已被解除,如下图所示。

好了,今天有关在Excel中解除或修改文件密码的方法便介绍到这,大家赶紧实际操作练习一下吧,有不懂的问题可以留言问小编呦!感谢关注Excel880,还请多多转发,持续关注我们呀!excel密码破解


excel密码破解,服务器高速破解的评论 (共 条)

分享到微博请遵守国家法律