操作excel保护密码破解(绝对经典)

破解无线路由密码  时间:2021-04-20  阅读:()

exc e l保護密碼破解(絕對經典)

如果你的E xce l文件設置了保護密碼而遺忘了 ,那麼請依照下面的步驟來操作.簡 ,也許會有奇跡出現. .不需要多麼高難度的操作和專業的軟件支持 單.方便.費時一般最多兩分鐘 (建議:操作前把原文件COPY一份)

方法:

打开文件

工具---宏----录制新宏---输入名字如 :aa

停止录制(这样得到一个空宏 )

工具---宏----宏,选aa,点编辑按钮

删除窗口中的所有字符 (只有几个),替换为下面的内容 :(复制吧)

关闭编辑窗口

工具---宏-----宏,选Al l I nternalPasswords,运行,确定两次,等2分钟,再确定.OK,没有密码了! !内容如下

Publ ic Sub Al l InternalPasswords()

'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 Harkerand JE McGimpsey27-Dec-2002(Version 1 .1 )

'Modified 2003-Apr-04 by JEM:Al l msgs to constants,and

'el iminate one ExitSub(Version 1 .1 .1)

'Reveals hashed passwords NOT original passwords

Const DBLSPACE As String=vbNewLine&vbNewLine

ConstAUTHORS As String=DBLSPACE&vbNewLine&_

"Adapted from Bob McCormick base code by"&_

"Norman Harkerand JE McGimpsey"

Const HEADER As String="Al l InternalPasswords User Message"

ConstVERSION As String=DBLSPACE&"Version 1 .1 .1 2003-Apr-

04"Const REPBACK As String=DBLSPACE&"Please report fai lure"

&_"to the microsoft.publ ic.excel .programming newsgroup."

ConstALLCLEAR As String=DBLSPACE&"The workbook should"&

_"now be free of al l 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"&

_"maybe 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 tounprotectsheets."&AUTHORS&VERSION

Const MSGTAKETIME As String="After pressing OK button this"&_"wi l l take some time."&DBLSPACE&"Amount of time"&_"dependson 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 orWindows Password set."&DBLSPACE&

_

"The password found was: "&DBLSPACE&"$$"&DBLSPACE&_"Note it down for potential future use in otherworkbooks by"&_"the same person who set this password."&DBLSPACE&_

"Nowto 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 otherworkbooks 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 thatwas justfound."&_

ALLCLEAR&AUTHORS&VERSION&REPBACK

Dim w1 As Worksheet,w2 As Worksheet

Dim i As Integer, j As Integer,kAs 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,WinTagAs Boolean

Appl ication.ScreenUpdating=False

With ActiveWorkbook

WinTag=.ProtectStructure Or .ProtectWindowsEnd With

ShTag=False

For Each w1 InWorksheets

ShTag=ShTag Or w1 .ProtectContents

Nextw1

If Not ShTag And NotWinTag Then

MsgBox MSGNOPWORDS1 ,vbInformation,HEADERExit Sub

End If

MsgBox MSGTAKETIME,vbInformation,HEADERIf NotWinTag Then

MsgBox MSGNOPWORDS2,vbInformation,HEADERElse

On Error Resume Next

Do'dummydo loop

For i=65 To 66:Forj=65 To 66:Fork=65 To 66For l=65To 66:Form=65To66:For i1 =65To66For 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

.UnprotectChr(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

PWo rd 1 =C h r(i)&C h r(j)&C h r(k)&C h r(l)&_

Chr(m)&Chr(i1 )&Chr(i2)&Chr(i3)&_

Chr(i4)&Chr(i5)&Chr(i6)&Chr(n)

MsgBox Appl ication.Substitute(MSGPWORDFOUND1,_"$$",PWord 1 ),vbI nformation,HEADER

Exit Do'Bypass al l for. . .nexts

End If

End With

Next:Next:Next:Next:Next:Next

Next:Next:Next:Next:Next:Next

Loop Unti l True

On ErrorGoTo 0

End If

If WinTag And Not ShTag Then

MsgBox MSGONLYONE,vbInformation,HEADERExit Sub

End If

On Error Resume Next

For Each w1 InWorksheets

'Attempt clearance with PWord1w1 .Unprotect PWord1

Nextw1

On ErrorGoTo 0

ShTag=False

For Each w1 InWorksheets

'Checks for al l clear ShTag triggered to 1 if not.ShTag=ShTag Or w1 .ProtectContents

Nextw1

If ShTag Then

For Each w1 InWorksheets

With w1

If .ProtectContents Then

On Error Resume Next

Do'Dummydo loop

For i=65 To 66:Forj=65 To 66:Fork=65 To 66For l=65To 66:Form=65To66:For i1 =65To66For i2=65 To 66:For i3=65 To 66:For i4=65 To 66For i5=65To 66:For i6=65To 66:Forn=32To 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

PWo rd 1 =C h r(i)&C h r(j)&C h r(k)&C h r(l)&_

Chr(m)&Chr(i1 )&Chr(i2)&Chr(i3)&_

Chr(i4)&Chr(i5)&Chr(i6)&Chr(n)

MsgBox Appl ication.Substitute(MSGPWORDFOUND2,_

"$$",PWord 1 ),vbI nformation,HEADER

' leverage finding Pword bytrying on othersheets

For Each w2 InWorksheetsw2.Unprotect PWord1

Nextw2

Exit Do'Bypass al l for. . .nexts

End If

Next:Next:Next:Next:Next:Next

Next:Next:Next:Next:Next:Next

Loop Unti l True

On ErrorGoTo 0

End If

End With

Nextw1

End If

MsgBox ALLCLEAR&AUTHORS&VERSION&REPBACK,vbInformation,HEADEREnd Sub

傲游主机38.4元起,韩国CN2/荷兰VPS全场8折vps香港高防

傲游主机怎么样?傲游主机是一家成立于2010年的老牌国外VPS服务商,在澳大利亚及美国均注册公司,是由在澳洲留学的害羞哥、主机论坛知名版主组长等大佬创建,拥有多家海外直连线路机房资源,提供基于VPS主机和独立服务器租用等,其中VPS基于KVM或者XEN架构,可选机房包括中国香港、美国洛杉矶、韩国、日本、德国、荷兰等,均为CN2或者国内直连优秀线路。傲游主机提供8折优惠码:haixiuge,适用于全...

轻云互联22元/月,美国硅谷、圣何塞CN2GIA云服务器,香港沙田cn2建站vps仅25元/月

轻云互联怎么样?轻云互联,广州轻云网络科技有限公司旗下品牌,2018年5月成立以来,轻云互联以性价比的价格一直为提供个人,中大小型企业/团队云上解决方案。本次轻云互联送上的是美国圣何塞cn2 vps(免费50G集群防御)及香港沙田cn2 vps(免费10G集群防御)促销活动,促销产品均为cn2直连中国大陆线路、采用kvm虚拟技术架构及静态内存。目前,轻云互联推出美国硅谷、圣何塞CN2GIA云服务器...

10gbiz($2.36/月),香港/洛杉矶CN2 GIA线路VPS,香港/日本独立服务器

10gbiz发布了9月优惠方案,针对VPS、独立服务器、站群服务器、高防服务器等均提供了一系列优惠方面,其中香港/洛杉矶CN2 GIA线路VPS主机4折优惠继续,优惠后最低每月仅2.36美元起;日本/香港独立服务器提供特价款首月1.5折27.43美元起;站群/G口服务器首月半价,高防服务器永久8.5折等。这是一家成立于2020年的主机商,提供包括独立服务器租用和VPS主机等产品,数据中心包括美国洛...

破解无线路由密码为你推荐
档案管理系统常见问题及解决办法三星iphonej^=iáíá=fq~=OQJOU==aJPPNMO=m~dê~ó=preloadedbaidu支持ipad重庆网通中国联通重庆分公司的公司简介eacceleratorCentOS5.2下安装eAccelerator,怎么都装不上iexplore.exe应用程序错误iexplore.exe应用程序错误win10445端口win的22端口和23端口作用分别是什么 ?css下拉菜单html+css下拉菜单怎么制作
google镜像 星星海 asp.net主机 宕机监控 网站监控 免费ddos防火墙 免费ftp站点 linux空间 网站卫士 江苏双线服务器 无限流量 万网空间管理 web服务器是什么 免费赚q币 cloudflare let 网络安装 泥瓦工 qq登陆空间 六维空间登陆首页 更多