???
?excel是辦公軟件microsoftoffice的組件之一，win7正式版系統電腦在工作中使用excel工作表的時候，一些重要的文件我們都會給它設置上密碼。但是時間久了，容易把密碼忘記了，那么有什么辦法可以破解excel工作表密碼呢？接下去我們一起分享電腦破解excel工作表密碼的方法。
?
具體方法如下：
1、打開excel工作表；
2、然后在excel表中找到【視圖】；
3、點開【宏】；
4、然后選擇【錄制宏】；
5、接著會彈出一個窗口，點擊【確定】；
6、在此點開【宏】，點擊【停止錄制】；
7、然后再點擊【宏】，彈出窗口點擊【編輯】；
8、然后點擊【模板1】，并清空右邊紅框里的代碼；
9、然后把破解代碼復制粘貼進入空白處；
10、然后在打開【查看宏】，點擊執行破解代碼；
11、會彈出一個框，是英文的，看不懂沒關系，點擊確定，解密需要一段時間；
破解代碼:
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 \̶

為什么有的云服務器很便宜呢
動態壁紙音樂怎么設置 動態壁紙有聲音嗎
edm怎么做
不錯的云服務器代理網站平臺
【蚌埠網站建設】網站建設哪方面最重要的呢？
云服務器和域名購買
mx記錄未生效-域名及賬戶問題
西部數碼云服務器里的建站系統