如何能破解EXCEL工作表保护密码忘记密码怎么办

《如何能破解EXCEL工作表保护密码忘记密码怎么办》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、实用标准如何破解EXCEL工作表保护密码忘记密码怎么办1.新建一个EXCEL工作表，而后点击另存为，讲表格保存为启用宏的工作表2.一次点击开发工具---录制新宏，在弹出的对话框内修改宏名称而后确定文档大全实用标准1.依次点击开发工具----停止录制宏，宏录制完成2.依次点击开发工具，---宏----在弹出的对话框找到我们刚才录制的宏名称而后进入VBA界面3.在VBA界面，全选里面的代码，而后删除，讲里面的代码全部删除完文档大全实用标准1.代码复制到VBA编辑窗口内PublicSubAllInternalPasswords() 'Bre

2、aksworksheetandworkbookstructurepasswords.BobMcCormick 'probablyoriginatorofbasecodealgorithmmodifiedforcoverage 'ofworkbookstructure/windowspasswordsandformultiplepasswords ' 'NormanHarkerandJEMcGimpsey27-Dec-2002(Version1.1) 'Modified2003-Apr-04byJEM:Allmsgstoconstant

3、s,and 'eliminateoneExitSub(Version1.1.1) 'RevealshashedpasswordsNOToriginalpasswords ConstDBLSPACEAsString=vbNewLine&vbNewLine ConstAUTHORSAsString=DBLSPACE&vbNewLine&_ "AdaptedfromBobMcCormickbasecodeby"&_ "NormanHarkerandJEMcGimpsey" ConstHEADERAsString="AllInternalPa

4、sswordsUserMessage" ConstVERSIONAsString=DBLSPACE&"Version1.1.12003-Apr-04" 文档大全实用标准ConstREPBACKAsString=DBLSPACE&"Pleasereportfailure"&_ "tothemicrosoft.public.excel.programmingnewsgroup." ConstALLCLEARAsString=DBLSPACE&"Theworkbookshould"&_ "nowbefreeofallpasswordprot

5、ection,somakesureyou:"&_ DBLSPACE&"SAVEITNOW!"&DBLSPACE&"andalso"&_ DBLSPACE&"BACKUP!,BACKUP!!,BACKUP!!!"&_ DBLSPACE&"Also,rememberthatthepasswordwas"&_ "putthereforareason.Don'tstuffupcrucialformulas"&_ "ordata."&DBLSPACE&"Accessanduseofsomedata"&_ "maybeanoffense.Ifin

6、doubt,don't." ConstMSGNOPWORDS1AsString="Therewerenopasswordson"&_ "sheets,orworkbookstructureorwindows."&AUTHORS&VERSION ConstMSGNOPWORDS2AsString="Therewasnoprotectionto"&_ "workbookstructureorwindows."&DBLSPACE&_ "Proceedingtounprotectsheets."&AUTHORS&VERSION ConstMS

7、GTAKETIMEAsString="AfterpressingOKbuttonthis"&_ "willtakesometime."&DBLSPACE&"Amountoftime"&_ "dependsonhowmanydifferentpasswords,the"&_ "passwords,andyourcomputer'sspecification."&DBLSPACE&_ "Justbepatient!Makemeacoffee!"&AUTHORS&VERSION ConstMSGPWORDFOUND1AsString="Yo

8、uhadaWorksheet"&_ "StructureorWindowsPasswordset."&DBLSPACE&_ "Thepasswordfoundwas:"&DBLSPACE&"$$"&DBLSPACE&_