工作簿和工作表保护密码忘了

合集下载

如何破解EXCEL工作表保护密码忘记密

如何破解EXCEL工作表保护密码忘记密码怎么办1.新建一个EXCEL工作表，而后点击另存为，讲表格保存为启用宏的工作表2.一次点击开发工具---录制新宏，在弹出的对话框内修改宏名称而后确定3.依次点击开发工具----停止录制宏，宏录制完成4.依次点击开发工具，---宏----在弹出的对话框找到我们刚才录制的宏名称而后进入VBA界面5.在VBA界面，全选里面的代码，而后删除，讲里面的代码全部删除完6.代码复制到VBA编辑窗口内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' Modified 2003-Apr-04 by JEM: All msgs to constants, and' eliminate one Exit Sub (Version' 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 2003-Apr-04" Const REPBACK As String = DBLSPACE & "Please report failure " & _ "to the 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 & 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 & 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 & 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= FalseWith ActiveWorkbookWinTag = .ProtectStructure Or .ProtectWindows End WithShTag = FalseFor Each w1 In WorksheetsShTag = ShTag OrNext w1If Not ShTag And Not WinTag ThenMsgBox MSGNOPWORDS1, vbInformation, HEADER Exit SubEnd IfMsgBox MSGTAKETIME, vbInformation, HEADERIf Not WinTag ThenMsgBox MSGNOPWORDS2, vbInformation, HEADER ElseOn Error Resume NextDo 'dummy do loopFor 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 66For 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 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 (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, HEADER Exit SubEnd IfOn Error Resume NextFor Each w1 In Worksheets'Attempt clearance with PWord1PWord1Next w1On Error GoTo 0ShTag = FalseFor Each w1 In Worksheets'Checks for all clear ShTag triggered to 1 if not. ShTag = ShTag OrNext 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 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 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 (MSGPWORDFOUND2, _"$$", PWord1), vbInformation, HEADER'leverage finding Pword by trying on other sheets For Each w2 In WorksheetsPWord1Next 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, HEADER End Sub点击保存7.点击开发工具，宏，找到我们刚才录制的宏，点击执行宏8.而后，在弹出的所有对话框上，都点击确定，都确定，1分钟后，就可以编辑了。

excel密码忘记了怎么办？这是我见过最好的解决方法

excel密码忘记了怎么办？这是我见过最好的解决方法之前给大家有讲过保护工作表的那些事儿，简单回忆一下吧，整个excel文档加密，工作表加密、部分单元格加密、excel窗口的加密。

那么我们已经加了密的文档忘记密码了如何解决呢？之前都是给大家说密码一定要自己要备份，那么肯定有人会问那万一就是忘记了怎么办呢？其实解决方法是有的。

下面小菜老师给大家说一下关于6位一下的密码如何解决？第一步：新打开一个excel文档，同时按Alt和F11，进入VBA 界面，第二步：点菜单上的插入，模块，第三步：在新出来的窗口粘贴一下代码：Sub crack()Dim i As LongDim FileName As Stringi = 0FileName = Application.GetOpenFilename("Excel文件（*.xls & *.xlsx）,*.xls;*.xlsx", , "VBA破解")FileName = Right(FileName, Len(FileName) - InStrRev(FileName, "\"))Application.ScreenUpdating = Falseline2: On Error GoT o line1Workbooks.Open FileName, , True, , iMsgBox "Password is " & iExit Subline1: i = i + 1Resume line2Application.ScreenUpdating = TrueEnd Sub注意事项：在测试的时候尽量关掉其他程序，提高速度。

想知道工作表的保护事儿吗？赶紧关注微信号“路凡教育”。

小菜老师告诉你相关的秘密。

3种方法破解工作表密码

3种⽅法破解⼯作表密码⼤家好，今天和⼤家分享“破解Excel⼯作表密码'，⼯作表密码其实很很脆弱，破解很容易，下⾯我讲解3种⽅法⼀、纯技巧破解⽅法:不适合03版本,关闭有⼯作表保护的⼯作簿-->选中⼯作簿-->右击-->重命名-->在后⾯加⼀个.Zip-->确认-->变成压缩⽂件-->双击打开压缩包-->打开xl⽂件夹-->worksheets-->找到加密的⼯作表-->把它拖到桌⾯-->打开拖出来的⼯作表,格式是xml的-->删除<sheetProtection password='CF7A' sheet='1' objects='1' scenarios='1'/>-->保存-->关闭拖出来的⼯作表,格式是xml⽂件夹,⼜把它拖回去-->关闭打开压缩包-->右击压缩包-->重命名-->把.zip删除-->确定-->打开⼯作簿-->呵呵,⼯作表密码没有了,⼤功告成.备注:如果你的电脑⾥的⽂件没有扩展名选进⾏此操作我的电脑-->⼯具-->⽂件夹选项-->查看-->去掉'隐藏已知⽂件类型的扩展名'前⾯的钩⼆、代码破解⽅法：快捷键A1t F11打开vbe编辑器→插⼊菜单→插⼊模块→把下⾯的代码复制过去→然后把光标点到代码⾥→F5运⾏⼀下→⼯作表保护就破解了。

Sub 破解⼯作表密码()For x = 1 To Sheets.CountSheets(x).Protect AllowFiltering:=TrueSheets(x).UnprotectNext xEnd Sub三、完美⼯具箱破解操作⽅法见动画具体操作⽅法：完美⼯具箱【9.7.0版】选项卡→加解密码→⼯作表解密码→多次点取消⼀直到破解。

excel工作表保护密码忘了

excel工作表保护密码忘了在日常工作中，我们经常会使用Excel进行数据处理和分析。

而在使用Excel 的过程中，我们经常会为工作表设置保护密码，以防止他人对工作表进行未经授权的修改。

然而，有时候我们可能会忘记设置的保护密码，导致无法对工作表进行修改。

那么，当我们忘记了Excel工作表的保护密码该怎么办呢？首先，我们可以尝试使用一些常见的密码来解锁工作表。

有时候，我们可能会设置一些常用的密码，比如生日、电话号码、或者是一些简单的数字组合。

所以，我们可以先尝试这些常见的密码，看是否能够成功解锁工作表。

如果使用常见密码无法解锁工作表，我们还可以尝试使用一些密码破解工具。

在互联网上有很多针对Excel密码破解的软件，我们可以下载并尝试使用这些软件来破解工作表的保护密码。

当然，在使用这些软件的过程中，我们需要注意选择正规可靠的软件，以免下载到一些带有恶意软件的程序，导致电脑受到损害。

此外，我们还可以尝试使用VBA代码来解锁Excel工作表的保护密码。

通过编写一些简单的VBA代码，我们可以尝试绕过保护密码，对工作表进行修改。

当然，这需要一定的VBA编程知识，如果我们不熟悉VBA，可以寻求一些专业人士的帮助。

如果以上方法都无法解锁Excel工作表的保护密码，我们还可以考虑使用一些第三方工具来解决这个问题。

在互联网上有一些专门针对Excel密码破解的软件，它们通常具有强大的破解能力，可以帮助我们解锁工作表的保护密码。

当然，在选择使用第三方工具时，我们需要注意选择正规可靠的软件，以免下载到一些不安全的程序。

总的来说，当我们忘记了Excel工作表的保护密码时，我们可以尝试使用一些常见密码、密码破解工具、VBA代码或者第三方工具来解决这个问题。

当然，在进行这些操作时，我们需要注意选择安全可靠的方式，以免给电脑带来安全隐患。

希望以上方法可以帮助到你，解决忘记Excel工作表保护密码的问题。

EXCEL工作表保护密码忘记,撤销保护攻略

EXCEL工作表保护密码忘记,撤销保护攻略eXCEL工作表为了保护数据被更改设置表格保护，但是有时候在无意中设置了表格保护或者保护密码忘记了无法继续修改文件，这样给工作带来不便。

那么密码忘记了怎么继续修改文件呢？编者结合实际操作为你解答。

工具/原料∙电脑∙EXCEL2007首次忘记密码撤销保护1.视图—宏—录制新宏—输入宏名如:aa（aa是可随意输入）2.停止录制，这样得到一个空宏3.同样视图—宏—查看宏—选aa（aa为之前新建的宏）—点击编辑按钮4.删除窗口中的所有字符，复制下面的内容粘贴。

一个字母、标点符号都不能少。

Option ExplicitPublic Sub AllInternalPasswords()' Breaks worksheet and workbook structure passwords. Bob McCormi ck' probably originator of base code algorithm modified for coverage' of workbook structure / windows passwords and for multiple passw ords'' 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 & VERSION Const 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 & 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 & 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 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, HEADER Exit SubEnd IfMsgBox MSGTAKETIME, vbInformation, HEADERIf Not WinTag ThenMsgBox MSGNOPWORDS2, vbInformation, HEADER ElseOn Error Resume NextDo 'dummy do loopFor 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 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 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 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, vbInformati on, HEADEREnd Sub5.关闭编辑窗口6.视图—宏—查看宏,选AllInternalPasswords，点击执行，确定两次，等2分钟，再确定。

撤销工作表保护密码忘记了怎么办

撤销工作表保护密码忘记了怎么办
1、先找到有工作表保护密码的Excel表格，然后将忘记密码的Excel文件名称后缀由.xlsx改为.rar，如果有提示可以忽略，一般不会造成什么影响。

2、用压缩文件打开忘记密码的Excel文件，然后按以下步骤进行操作：xl——worksheets——sheet1.xml（这里是将sheet1工作表设置了保护密码，可根据实际情况选择相应文件名）。

3、从压缩文件里面找到sheet1.xml文件，然后拖拽至一个方便找到的位置（因为我们要对其要进行修改）。

然后将sheet1.xml文件右击选择用记事本打开方式打开。

4、然后搜索，“protection”，把从这一段代码，全部删除掉。

5、然后再把修改后的sheet1.xml文件，选择拖拽到压缩的工作薄中，选择替换掉即可，点击确定。

6、最后一步，和第一步相反，把文件名称后缀，由“演示表格.rar”重新更改“演示表格.xlsx”。

最后打开Excel表格，所有密码都取消了。

第 1 页共1 页。

办公软件学习技巧：excel表格保护密码忘了怎么办

excel表格保护密码忘了怎么办在使用Excel的时候，都会讲excel给设置了密码，以防他人篡改或误删数据。

但时间长了，密码却遗忘了，这是该如何是好。

下面让学习啦我为你带来excel表格爱护密码忘了的解决方法。

excel密码解除步骤如下：1、打开excel，点击菜单栏的“视图”，点击二级菜单里的“宏”，选择录制宏。

2、在弹出来的方框中输入宏的名字，点击确认。

3、重复第一步的步骤，不过这次点击“停止录制”。

4、选择查看宏。

5、编辑宏。

6、在弹出来的代码框输入下面的代码。

Public Sub AllInternalPasswords()Breaks worksheet and workbook structure passwords. Bob McCormickprobably originator of base code algorithm modified for coverageof workbook structure / windows passwords and for multiplepasswordsNorman Harker and JE McGimpsey 27-Dec-2021 (Version 1.1)Modified 2021-Apr-04 by JEM: All msgs to constants, andeliminate 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 McGimpseyConst HEADER As String = AllInternalPasswords User Message Const VERSION As String = DBLSPACE Version 1.1.1 2021-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. Dont stuff up crucial formulas _or data. DBLSPACE Access and use of some data _may be an offense. If in doubt, dont.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 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 computers 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 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 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 Integer Dim i3 As Integer, i4 As Integer, i5 As Integer, i6 As Integer Dim 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 ThenMsgBox MSGNOPWORDS2, vbInformation, HEADER ElseOn 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 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 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, HEADER Exit SubEnd IfOn Error Resume NextFor Each w1 In WorksheetsAttempt clearance with PWord1w1.Unprotect PWord1Next w1On Error GoTo 0ShTag = FalseFor Each w1 In WorksheetsChecks 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 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 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, HEADERleverage 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 Subexcel表格爱护密码忘了怎么办。

破解撤销工作表保护密码的方法

破解撤销工作表保护密码的方法如果你忘记了Excel工作表的保护密码，或者不知道密码是什么，那么你可能会被拒绝编辑或修改工作表。

但是，有一些方法可以帮助你破解撤销Excel工作表的保护密码。

方法一：使用VBA代码破解工作表保护密码1. 打开Excel文件，并按下Alt + F11键进入VBA编辑器。

2. 在VBA编辑器中，选择工具>引用，然后勾选Microsoft Visual Basic for Applications扩展库。

3. 在VBA编辑器中，选择插入>模块，并复制以下代码到新模块中：Sub PasswordBreaker()'Breaks worksheet password protection.Dim i As Integer, j As Integer, k As IntegerDim l As Integer, m As Integer, n As IntegerDim i1 As Integer, i2 As Integer, i3 As IntegerDim i4 As Integer, i5 As Integer, i6 As IntegerOn Error Resume NextFor 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 66 For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126 ActiveSheet.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 ActiveSheet.ProtectContents = False ThenMsgBox 'One usable password is ' & Chr(i) & Chr(j) & _ Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)Exit SubEnd IfNext: Next: Next: Next: Next: NextNext: Next: Next: Next: Next: NextEnd Sub4. 点击运行按钮，然后在Excel工作表上右键单击并选择“查看代码”选项。

excel密码忘记了怎么解锁

excel密码忘记了怎么解锁导读：本文将介绍如何解锁忘记密码的Excel文件。

当您忘记了您的Excel密码时，可以使用两种方法进行解锁。

第一种方法是使用第三方密码恢复工具，第二种方法是使用VBA宏代码进行解锁。

下面将详细介绍这两种方法的步骤。

对于Excel密码的忘记，有两种可行的解锁方法。

第一种方法是使用第三方密码恢复工具，第二种方法是使用VBA宏代码。

下面将详细介绍这两种方法的步骤。

方法一：使用第三方密码恢复工具第一步：下载并安装密码恢复工具访问一个可信的软件下载网站，搜索并下载一个Excel密码恢复工具。

确保选择一个经过验证的工具，并确保从安全可信的来源下载。

第二步：打开密码恢复工具双击下载的文件，按照安装向导的指示进行安装，并打开密码恢复工具。

第三步：导入Excel文件在密码恢复工具中选择“导入”选项，然后选择您忘记密码的Excel文件，并点击“导入”。

第四步：选择恢复模式工具会提供不同的恢复模式，如暴力恢复、字典恢复等。

选择一个适合的恢复模式，并设置相应的选项。

第五步：开始密码恢复点击“开始”按钮，密码恢复工具将开始尝试恢复您的Excel密码。

这个过程可能需要一些时间，取决于密码的复杂性。

第六步：获得密码当密码恢复工具找到密码时，它会在屏幕上显示出来。

将找到的密码记下来，然后使用它来解锁您的Excel文件。

方法二：使用VBA宏代码第一步：打开Excel文件双击您忘记密码的Excel文件，打开它。

第二步：按下快捷键同时按下“ALT”和“F11”键，打开VBA编辑器。

第三步：插入新的模块在VBA编辑器中，选择“插入”菜单，并选择“模块”。

第四步：复制VBA代码从可信来源复制以下VBA宏代码，并在新建的模块中粘贴。

Sub PasswordBreaker()'Breaks worksheet password protection.On Error Resume NextFor Each ws In Worksheetsws.Unprotect Password:=""Next wsEnd Sub第五步：运行宏代码按下“F5”或点击“运行”按钮运行宏代码。

忘记excel密码的解决方法

忘记excel密码的解决方法
忘记Excel密码是一个常见的问题，但幸运的是有几种方法可以解决这个问题。

首先，你可以尝试使用一些基本的密码，比如你常用的密码或者与你相关的日期或数字组合。

如果你仍然无法记起密码，以下是一些更具体的解决方法：
1. 使用密码提示，在输入密码时，Excel通常会提示你设置一个密码提示。

这个提示可能会帮助你回忆起密码。

2. 使用密码恢复工具，有一些第三方工具可以帮助你恢复忘记的Excel密码。

这些工具可以通过暴力破解或其他方法来尝试解锁文件。

但请注意，使用第三方工具可能存在安全风险，因此请确保从可信赖的来源获取工具并且在使用后立即删除工具。

3. 重置密码，如果你无法通过上述方法解决问题，你可以考虑重置密码。

你可以尝试将文件另存为另一种格式或者将文件内容复制到新文档中，这样可以去除密码保护。

4. 使用Excel密码恢复服务，有一些在线服务可以帮助你恢复Excel密码。

你可以上传受保护的文件，并支付费用以获取密码。

5. 联系Microsoft支持，作为最后的手段，你可以尝试联系Microsoft支持团队寻求帮助。

他们可能有一些高级的方法来帮助
你解决问题。

总的来说，忘记Excel密码是一个令人沮丧的问题，但通常情
况下是可以解决的。

希望上述方法中的某一个能够帮助你解决问题。

工作表密码忘了？一招教你删除EXCEL工作表密码

工作表密码忘了？一招教你删除EXCEL工作表密码
大家好！刚学习到一个新的实用技能-删除EXCEL保护密码，所以迫不及待来跟大家分享。

一、痛点概括1、日常工作中，为了让别人不能随意更改工作表，经常会有设置保护密码的时候，如果工作表太多，自己都会记不住；2、别人下发的工作表，想学习函数公式，或者重新修订，有密码保护，不能修改。

二、步骤演示1、如图，我们的工作表已经保护，无法更改和修订；2、关闭当前工作簿，修改后缀名为.RAR；3、双击修改后的文件-找到Sheet1.xml，我的路径是xl-worksheets-sheet1.xml，大家应该差不多；4、复制或者拖动一份到压缩文件外，右键-选择记事本-打开；5、在打开的记事本中，查找：PROTECTION,并删除包含这一词汇的整句语句；（以这两个符号开头和结尾）6、保存记事本文档，并拖动或者复制到原压缩文件中，替换；7、修改文档为.xlsx格式，打开EXCEL，此时已经可以自由编辑。

注意：2003版不适用、EXCEL打开密码不适用。

Excel密码保护保护您的工作簿和工作表

Excel密码保护保护您的工作簿和工作表在日常的工作中，我们经常使用Excel来处理各种数据和信息。

有些时候，我们会有一些重要的数据或者敏感信息需要保护起来，以防止未经授权的人员访问或篡改。

在Excel中，我们可以通过密码保护来保护我们的工作簿和工作表，确保数据的安全性。

本文将介绍如何使用Excel的密码保护功能。

一、密码保护工作簿1. 打开Excel并选择要保护的工作簿。

2. 点击“文件”选项卡，在下拉菜单中选择“信息”。

3. 在“信息”窗口中，找到“保护工作簿”选项，点击“加密密码”。

4. 在弹出的对话框中，输入您要设置的密码，并点击“确定”按钮。

5. 在确认密码的对话框中，再次输入您设置的密码，并点击“确定”按钮。

6. 接下来，您可以选择将工作簿只读共享，或者允许特定用户进行编辑。

选择适合您需求的选项，并设置相关权限。

7. 点击“确定”按钮，完成对工作簿的密码保护设置。

二、密码保护工作表有时候，我们只需要保护工作簿中的某个工作表，而不是整个工作簿。

下面是如何密码保护工作表的步骤。

1. 打开要保护的工作簿，并选择要保护的工作表。

2. 点击“开始”选项卡，在“格式”组中选择“保护工作表”。

3. 在弹出的对话框中，输入您要设置的密码，并点击“确定”。

4. 在确认密码的对话框中，再次输入您设置的密码，并点击“确定”。

5. 接下来，您可以选择允许特定用户编辑选定的区域，或者保护整个工作表，禁止进行任何更改。

6. 点击“确定”按钮，完成对工作表的密码保护设置。

三、解除密码保护如果您不再需要密码保护，或者忘记了密码，可以通过以下步骤解除密码保护。

1. 打开要解除密码保护的工作簿或工作表。

2. 点击“文件”选项卡，在下拉菜单中选择“信息”。

3. 在“信息”窗口中，找到“保护工作簿”或“保护工作表”选项，分别选择“加密密码”或“保护工作表”。

4. 在弹出的对话框中，将密码框保持为空，然后点击“确定”按钮。

5. 输入之前设置的密码，并点击“确定”。

wpsexcel表格忘记工作表保护密码怎么办？

wpsexcel表格忘记⼯作表保护密码怎么办？wps/excel考勤表格忘记修改⼯作表保护默认密码怎么办？考勤⼯作表密码破解？
在我们的⽇常⽣活中，⽤到密码的地⽅很多，同样在我们的⼯作中，同样也会⽤到！特别是⼯
作中，由于经常性的换⼈，交接不好，导致好多⼯作表的密码等你接⼿的时候都不知道，想编
辑⼜编辑不了，怎么办呢？好烦躁。

下⾯我们以考勤打卡记录为例来讲⼀下忘记⼯作表保护密码怎么样撤销⼯作表保护？
1. 打开清除密码系统
2. 启动宏（默认启⽤的则忽略此步骤）
3. 点击按钮“清除密码”
4. 选择你要清除密码的⽂件，需要是.xls 或者.xlsx 格式
5. 如出现输⼊密码的提⽰框，点击“取消”按钮，⼀直出现就⼀直点
6. 出现提⽰，则密码清除完成。

亲测清除密码有效率基本达到99.999%，需要清除密码系统的可以私我哦！6.6。

Excel工作表保护密码忘记之解决办法

工作表保护密码破解（图解）1、新建一个EXCEL文件“BOOK1”，在工具栏空白位置，任意右击，选择Visual Basic项，弹出Visual Basic工具栏：2、在Visual Basic工具栏中，点击“录制”按钮，弹出“录制新宏”对话框，选择“个人宏工作簿”：3、选择“个人宏工作簿”后按确定，弹出如下“暂停”按钮，点击停止：4、在Visual Basic工具栏中，点击“编辑”按钮：5、点击“编辑”按钮后，弹出如下图的编辑界面：找到“VBAProject（PERSONAL.XLS）－模块－模块1（也可能是模块N-其他数字）”双击模块1－将右边代码容清空6、复制“工作保护密码破解”代码到右边框中，点保存，然后关闭“BOOK1”7、运行需要解密的“EXCEL文件”，在Visual Basic工具栏中，点击“运行”按钮8、点击“运行”按钮后，弹出“宏”对话框，点击运行“PERSONAL.XLS!工作保护密码破解”这个宏9、运行“PERSONAL.XLS!工作保护密码破解”这个宏后，如下图示意就可以解除工作表的密码保护了（这个图，如果工作表中有多组不同密码，每解开一组，就会提示一次，也就说可能会出现几次）工作表保护密码破解(代码）=========请复制以下容=============Public Sub 工作表保护密码破解() Const DBLSPACE As String = vbNewLine & vbNewLine Const AUTHORS As String = DBLSPACE & vbNewLine & _ "作者:McCormick JE McGimpsey " Const HEADER As String = "工作表保护密码破解" Const VERSION As String = DBLSPACE & "版本Version 1.1.1" Const REPBACK As String = DBLSPACE & "" Const ZHENGLI As String = DBLSPACE & " hfhzi3—戊冥整理" Const ALLCLEAR As String = DBLSPACE & "该工作簿中的工作表密码保护已全部解除!!" & DBLSPACE & "请记得另保存" _ & DBLSPACE & "注意：不要用在不当地方，要尊重他人的劳动成果！" Const MSGNOPWORDS1 As String = "该文件工作表中没有加密" Const MSGNOPWORDS2 As String = "该文件工作表中没有加密2" Const MSGTAKETIME As String = "解密需花费一定时间,请耐心等候!" & DBLSPACE & "按确定开始破解!" Const MSGPWORDFOUND1 As String = "密码重新组合为:" & DBLSPACE & "$$" & DBLSPACE & _ "如果该文件工作表有不同密码,将搜索下一组密码并修改清除" Const MSGPWORDFOUND2 As String = "密码重新组合为:" & DBLSPACE & "$$" & DBLSPACE & _ "如果该文件工作表有不同密码,将搜索下一组密码并解除" Const MSGONLYONE As String = "确保为唯一的?" 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 IntegerDim 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 ElseOn 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 IfIf WinTag And Not ShTag ThenMsgBox MSGONLYONE, vbInformation, HEADER Exit Sub End If On Error Resume NextFor 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 IfEnd With Next w1 End If MsgBox ALLCLEAR & AUTHORS & VERSION & REPBACK & ZHENGLI, vbInformation, HEADEREnd Sub =========================================================。

excel表格密码破解的方法

Excel表格密码破解的方法一、概述Excel表格是一款广泛使用的电子表格程序，它的安全性和隐私保护至关重要。

然而，有时候我们会忘记自己设置的Excel表格密码，或者需要破解别人设置的密码。

本文将对Excel表格密码破解的方法进行详细介绍，希望对大家有所帮助。

二、查看Excel表格的密码保护方式在尝试破解Excel表格密码之前，我们首先需要了解Excel表格的密码保护方式。

Excel表格的密码保护主要分为两种：文档开放密码和工作表保护密码。

文档开放密码用于限制用户打开Excel文档，而工作表保护密码则是用于限制其编辑或者查看内容。

我们需要查看Excel表格使用了哪种密码保护方式，以便有针对性地进行破解。

三、常见的Excel表格密码破解工具1. Excel密码破解大师Excel密码破解大师是目前比较流行的一款Excel表格密码破解工具，它可以帮助用户快速破解各种类型的Excel表格密码。

用户只需简单操作，即可轻松完成密码破解。

该工具操作简单，界面友好，适合各类用户使用。

2. Passper for ExcelPassper for Excel是一款专业的Excel表格密码破解软件，它可以帮助用户恢复忘记的Excel打开密码和修改密码。

该软件兼容各种版本的Excel文档，能够高效、安全地进行密码破解。

用户只需按照软件提示进行操作，即可完成密码破解。

3. iSunshare Excel密码破解iSunshare Excel密码破解是一款专业的Excel表格密码破解工具，它支持多种密码破解方式，包括暴力破解、字典破解和智能破解等。

用户可以根据自己的需求选择合适的破解方式，高效地破解Excel表格密码。

四、Excel表格密码破解的具体步骤1. 准备破解工具用户需要下载并安装一款专业的Excel表格密码破解工具，如Excel密码破解大师、Passper for Excel或iSunshare Excel密码破解等。

EXCEL忘记密码怎么办EXCEL工作表怎么清除密码

E X C E L忘记密码怎么办E X C E L工作表怎么清除密码集团标准化办公室：[VV986T-J682P28-JP266L8-68PNN]如何破解EXCEL工作表保护密码1.工具---宏----录制新宏---输入名字如:hh2. 3停止录制(这样得到一个空宏)3. 4工具---宏----宏,选hh,点编辑按钮选择“个人宏工作簿”后按确定，弹出如下“暂停”按钮，点击停止：1.点击“运行”按钮后，弹出“宏”对话框，2.点击运行“!工作保护密码破解”这个宏3.99、运行“!工作保护密码破解”这个宏后，如下图示意就可以解除工作表的密码保护了4.10（这个图，如果工作表中有多组不同密码，每解开一组，就会提示一次，也就说可能会出现几次）5.11工作表保护密码破解(代码）=========请复制以下内容=============Public Sub 工作表保护密码破解()Const DBLSPACE As String = vbNewLine & vbNewLine Const AUTHORS As String = DBLSPACE & vbNewLine & _ "作者:McCormick JE McGimpsey "Const HEADER As String = "工作表保护密码破解"Const VERSION As String = DBLSPACE & "版本 Version " Const REPBACK As String = DBLSPACE & ""Const ZHENGLI As String = DBLSPACE & " hfhzi3—戊冥整理"Const ALLCLEAR As String = DBLSPACE & "该工作簿中的工作表密码保护已全部解除!!" & DBLSPACE & "请记得另保存" _& DBLSPACE & "注意：不要用在不当地方，要尊重他人的劳动成果！"Const MSGNOPWORDS1 As String = "该文件工作表中没有加密"Const MSGNOPWORDS2 As String = "该文件工作表中没有加密2"Const MSGTAKETIME As String = "解密需花费一定时间,请耐心等候!" & DBLSPACE & "按确定开始破解!"Const MSGPWORDFOUND1 As String = "密码重新组合为:" & DBLSPACE & "$$" & DBLSPACE & _"如果该文件工作表有不同密码,将搜索下一组密码并修改清除"Const MSGPWORDFOUND2 As String = "密码重新组合为:" & DBLSPACE & "$$" & DBLSPACE & _"如果该文件工作表有不同密码,将搜索下一组密码并解除"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 Boolean= FalseWith ActiveWorkbookWinTag = .ProtectStructure Or .ProtectWindowsEnd WithShTag = FalseFor Each w1 In WorksheetsShTag = ShTag OrNext 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 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 66For 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 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 (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 PWord1PWord1Next w1On Error GoTo 0ShTag = FalseFor Each w1 In Worksheets'Checks for all clear ShTag triggered to 1 if not. ShTag = ShTag OrNext 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 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 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 (MSGPWORDFOUND2, _"$$", PWord1), vbInformation, HEADER'leverage finding Pword by trying on other sheetsFor Each w2 In WorksheetsPWord1Next 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, vbInfo rmation, HEADEREnd Sub。

忘记了EXCEL表格中“保护工作簿”和“保护工作表”的密码,该怎么办？

忘记了EXCEL表格中“保护工作簿”和“保护工作表”的密码，该怎么办？“保护工作簿”和“保护工作表”是EXCEL中常用的两个功能。

“保护工作簿”能够隐藏不想被别人看到的SHEET，而“保护工作表”则能使单元格不被编辑，当在审阅中设置了这两个选项后，就不能解除隐藏或编辑被保护的单元格了。

如果忘记了这两个密码，就很悲催了，如果要修改的话，可能就得重做了。

下面进入解决办法。

这篇文章不是教大家破解EXCEL的打开密码，而是解决“保护工作簿”和“保护工作表”的密码被遗忘的问题。

首先你得能够打开这个EXCEL文件，如果有密码保护不能打开，这个方法是无效的！但是有一点，需要提前声明：本文的方法仅仅是针对自己的文件忘记密码而作出的补救措施，千万千万不能用在别人的文件上！大家记住，作人作事都应守住自己的底线，技术可以学到，但是绝对不能用在不该用的地方！！！请谨记！！！我们直接进入操作方法，接着往下看。

首先要打开查看文件的扩展名（如果有人不懂怎么开请在下面留言，我会回复，或下次开一篇文章来讲）；把忘记密码的文件扩展名改为rar，比如“人员表.xlsx”改成“人员表.rar”，这时文件的图标会变成压缩文件的样子；双击这个文件，前提是你电脑上安装有压缩软件（winrar或好压）；这时会在压缩软件里打开这个文件；打开xl文件夹，如上图。

如果设置了“保护工作簿”，找到workbook.xml文件，把它拖到桌面上；右键点workbook.xml，打开方式，记事本（或notepad）；点“编辑”-“查找”，输入protect，查找到一个结果；如上图，选中<workbookProtection ... />这部分代码，中间的...表示有一串代码，只看两个<>符号，删除，保存后关闭文件。

把这个文件拖回原位置提示要添加进压缩文件，确定如果设置了“保护工作表”，继续往下面看：继续打开worksheets文件夹，里面会显示sheet*.xml的文件，其实就是EXCEL中的SHEET；用刚才5-7的方法，把这几个文件拖到桌面上，分别用记事本打开；查找protect，如果有如下代码，<sheetProtection.../>，和上面一样，删除。

excel表格保护密码忘了怎么办

excel表格保护密码忘了怎么办在使用Excel的时候，都会讲excel给设置了密码，以防他人篡改或误删数据。

但时间长了，密码却忘记了，这是该如何是好。

下面让为你带来excel表格保护密码忘了的解决方法。

excel密码破解步骤如下：打开受密码保护的工作表工具---宏----录制新宏---输入名字如:hh停止录制(这样得到一个空宏)工具---宏----宏,选hh,点编辑按钮删除窗口中的所有字符,替换为下面的内容: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 & 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 makesure 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 Integer Dim i3 As Integer, i4 As Integer, i5 As Integer, i6 As IntegerDim PWord1 As StringDim ShT ag As Boolean, WinTag As Boolean Application.ScreenUpdating = FalseWith ActiveWorkbookWinTag = .ProtectStructure Or .ProtectWindows End WithShT ag = FalseFor Each w1 In WorksheetsShT ag = ShTag Or w1.ProtectContentsNext w1If Not ShTag And Not WinTag ThenMsgBox MSGNOPWORDS1, vbInformation, HEADER Exit SubEnd IfMsgBox MSGTAKETIME, vbInformation, HEADERIf Not WinT ag ThenMsgBox MSGNOPWORDS2, vbInformation, HEADER ElseOn Error Resume NextDo 'dummy do loopFor 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 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 ShT ag ThenMsgBox MSGONLYONE, vbInformation, HEADER Exit SubEnd IfOn Error Resume NextFor Each w1 In Worksheets'Attempt clearance with PWord1w1.Unprotect PWord1Next w1On Error GoTo 0ShT ag = FalseFor Each w1 In Worksheets'Checks for all clear ShTag triggered to 1 if not. ShT ag = ShTag Or w1.ProtectContentsNext w1If ShT ag 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关闭编辑窗口，工具---宏-----运行,等1分钟,再确定.OK,没有密码了关于excel密码破解的。