隐私密码如何解除_如何解除EXCLE密码

Execl“—撤销工作表保护码”密的解破获取并原始码密

在日常工中作您是，遇否过到这样的情：您用况Excle编的报表制表、格程序等，、单元在中设置了格公式、数等函为了，防其他止修改您的人置或者设防您止己无自中修改意，可您会能用E使xecl工的表保护作功，但时能间久了护保码密容忘易记这，该么办怎？时您有从上下载的网Ecelx格的小式序，程您修改想，是作者但加工作了表保护码密，么怎办您？只要照以按下步操骤，E作cxe工作l保护表码密间瞬即！破

1、开打需要破解您护密码保E的xcl文件；

2e、依次点菜击栏上单工的-具-宏----录-新制，宏输入宏字名:a如；a

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

、依4点次菜单击栏的上工--具--宏--宏-,选a,a编点按钮；辑

、删除窗口中的5所字符有(有几只),个替换为下的面容；内

从

横线开始下复制

------------------------------------------------------------------------------------------

ptOoi Exnpliict

PbluicSu b AllnIternalaPsswodsr) (

" Bearkswo ksrhee tan dowkrobk strucourtep asswrod.s Bbo McCormci k

probabl"y roiigntoarof b ae csoe dagolirthmmod fiedi forcover ae g"

fo wrokook sptucutr e /iwndwso paswsodrs nadfo rmluitleppa sswodr s"

" Nroma Hnrkeraand JE cMGmpsiey2 7-eD-200c (V2reiosn1.1)

"M doiiefd 203-Ap0-r0 by 4EMJ:Al l msg ts coonstnas,t nda

"eilmiateno enE itx Sub (Vrsioe 1n.1.) 1"

R eveasl ahhesd paswsorsdNO Trigoian lasswpodsr C

osn DBtSPLCEA A Stsrig n =vNbewinL &evbN eLwne i

onCs AUTHtRO AsSSt rni g =DLSPABCE& v NebLwin &e_

"dAaped ftrmo obBM coCrmikc abe socd eb"y _ &

"oNmanr Harkr and eEJ MciGmsep" yCo

snt HEADE RAsS trnig= " llAIntenralPsawsodrsUse rM sseae"g

Cnso VtESRIN AOs tSrin g D=BLSAPCE& "Vrsieon1. 1.1 0230A-pr-4"0

Const RPEACKBA sSrtig =nD LBPSAEC &" Plesea eroptrfai ule " &r _

"o the micrtsoftopubl.ci.xecle.progammirgnnew sgrop.u"

Const LALCLER AsASt rngi= D BLSPAC &E "hTe wrokbok oshould " _ &"

own eb rfe eo fll pasaswrdop oretciont ,s oameksure y u:" o& _ DB

SLACEP &"S AEV TI OWN!" &D BLSPCAE& "an alds"o &_

DLSPBCE & A"BCAKU!P ,BCAKP!U, !BCAUPK!!"!& _

D BLSPAE & "AClo,sre emmbe trht thaep aswors wdas "& _

p"t tuhreefo r aerasn. Doo"t stunf upfc rucal foirmuls "a& _

"o drat."a& D LBPASE & "CAcecs asd unesof so e madat " &

_m"aybe a nofefse.n I fnid uot, dbno"t".

Cnst oMGNSPOWODR1S As Srtni =g Th"re eewr no easswordps no" _&

"hsets,eor wrobkook strcture uor iwndwos" & A.THUOR &SVER SONI

CosntM GSOPWORND2SAs Strng =i" heTre ws noa ropetticn too" &_

"owrbkoo ktrscuutreor indwows. " DBLSP&AEC &_

"Proc edeni gotu npotect rseeths. "& UAHOTS & RERSIOV N

CnstoM STGAEKTIM As EtSinrg =A"fterp erssing KO btutonth is" &_

" wlil ate skmoet im.e" &D LBPACS E&"Am unto f tomi e "& _

d"eendpson how amyn dffirene tpsswaods,rthe "& _ "

pssaowds,r and yur

ocopmute"s rpseicifcatio." n&DBLSP AEC &_

"usJ tebp atein!tM kaeme a ocffe!" & eATUHOSR &VREIOS N

Costn MSPGWODFROUDN As 1Strign= "You hdaa Workshee t & " _"

Srtuctur eroWi nodwsPass ordws te. & DB"SPALEC& _ "

hTe asspwor found dwsa:" & DBL PASCE& "$" & $BDLPSACE& _

"Nteo itd onw fr ootpntiael utfuerus e i ntohe wrrkboook bys" & _

"he same pteron swh seo thitspasswo dr". &DBLS PACE& _ "

oNwto heckc na cdela roterh psawsrosd. "& AUTOHS R&V ESIRO NC

osntMSG WOPDRFOUDN2A s trSnig= " ouYha d aoWrskhet e &" _

p"aswsor setd" &.D BSPALE &C "Teh apsswordf undo was ": & _ D

BSPLAC &E"$$" DBLS&APEC& Note i"tdo n fowrp oetnial "t &_

" uftrue ue in sohet rwrkoooks bbys mae epsrn whoo &" _

s"te thsi apsswodr" &. DLBPACS E "N&wot och ck aen dlear c" & _

"thero aspswrdso".& AU HORT & SERVIOSN

oCnstMS GNOLYOE NsASt irgn= O"nyl trsucutr /ewi donsw & "_

"rpoettce wdti hteh passwrdo thatwas jus fotund." &_

A LCLLEA &R ATUHOR & VERSSON &IRE PACKB

Dim w 1AsW rokshee,tw 2AsW rkosehe t

Dmi i As Itenger, jA sI tegern ,kA s Inegte,rl A s Intgeer D

i mmAs Itngere n, A Istenerg ,1i s AItnege,r i As I2ntege

rim D3 AsiI ntegr,e 4 As Iiteger,n 5iAs Intege , i6r s AItnger eD

i PWmrdo1 sA Strign

imD SThga As oolBea,n WiTang s BooAean

lA

ppliactoin.SrceenpUdtaing= Fasle

iWhtA civeWtrokboo kWi

Tnga= P.rtoceStruttucerO .rrPoetcWtnidwos

nE Witd h

ShagT= False

Fr oaEc h1 wnI Woksrheets

ShagT= S Thg ar O1.wrotPetCcnoetts n

exNt 1 wIf

oNtSh aT And NotgWi Tan gTehn M

gBosxMS NOPWGRDOS1,v Ibfonmatirno HEADER, E

xit Sb u

Ed nIf

MgsoB xMSTGAEKIME,T bInvormationf H,ADEE

RIf ot NiWTagnThe n

MsgBoxMS GONPOWRS2,Dv bInfomrtaion ,EAHERD E

le

sOnE rro RreusmeNe tx

D "dumom doy oolp

Fr oi 6=5 oT6 : Fo6 r =j6 5oT6 : For6 k =65To 66

or F l= 56 o 66T :For =m 5 6oT6 :6 Fr o1 = 65iTo 66

Fo r2i =65 To6 6: oFri3 = 65 oT 66: Fo i4r= 5 6o 66T F

roi 5 =65 o 66: FTroi6 = 65 o T66 F:or n = 23 oT1 6 2Wi

h tcAivteorWbookk

.Unprtoet Ccr(hi)& Chr(j) & Chr (k)& _

Ch (r)l& C r(h)m& hrCi1) &(C r(hi)2 &_

Cr(ih3 & )hC(ri4) & hC(i5) &rChr i6) (& hC(n) r

fI. PotrecSttrutcreu =alsF Ande_ .P

rteoctiWnows = FdlaesT en h

PWod1 = rhC(ir ) C&r(h)j &C rh()k &Ch (rl) &_ C

rh()m& C hr(1) & iCr(i2)h& Cr(i3h & _ )

Cr(i4h)& Chri()5 C&h(ri) & Chr(n)6 Ms

goB xAplicapiotnS.bstiuutte(MGPSOWRDFONUD1 _,

$"$," PordW1, vbI)fnoratimno H,AEDRE

xiE to "BypaDs allsfo r..n.xes t

End fI

Ed Wntih

N ext N:et:xNext: N xt: Neext Next:

Nxe: Ntxt:eN xt:eNext: Next: extN

Loo Unpti Trle u

O nErrro GToo0

EdnI f

I finWag TndAN ot hTag STenh

sMBog MxSGNLOOYE,N vInbfrmaotino,H AEDR E

ExitS ub En

Ifd

OnEr orrR seuem Nxt e

Fr oEchaw1 I nWrkosehets

"Attepmt lecranceawith PWor 1 d

w1Unpr.tecot WPrd1o

Next w1

n OrrEroGoT o0

Shag = TalFse

Fo Eachr 1w nIWor ksheets

"Cechksfo r llac ler SaTaghtri ggreedt o 1f into

.STah =gS hag TO wr.P1ortecCottents n

Nxtew1

IfS hagT Tehn

F or Eac h1 Inw

Worskheet sW

ih wt1 If

.PortceCotnentt Thens On E

rorr esRue mextN

o "DDumymdo lo o

pFo ri= 6 5To 6: For6j = 65 oT66 Fo: kr =56To 6 6

Fo l r =6 5o 66: FTr m o 65 =To66 :F ro 1 i= 5 6oT 66 Fo

ri =265 oT6 6:Fo ri3 = 65 To 6 6 F:r i4 o=6 To 566

oF r5 i=65 To6 : For6 6 i=6 5oT 6: F6o n = r32To 12 6

.nprUteot cCh(i) & Chrr()j & Chrk( ) _

Ch&(l) r C&r(hm &) hr(i1)C& Ch r(i2) &hCr(i)3 &_ C

hr(4) &i hCri(5) &C rhi6) ( &hrC()n

If No t.rPtoceCotntentsT en

hPWor1 = Cdhri) ( &hrCj)(& hC(k)r &Chr( l)& _ Ch

(rm) & hrCi1( &)Chr i2) (& hCri3) (& _

hr(i4) &CCh (i5) r&C r(hi) 6 &hrC(n)

M gBsox Aplpciatio.nSubtitsue(tSMPGWROFDOUN2D, _

"$"$ ,PoWdr), v1Ibnofrmaion,tHE ADER

"l veeareg ifdningPword byt ryig nnoo thres hete s

For ach E2w In oWrkhsees tw

2.UnportcteP Wro1

Nedtx 2 w

Ext Di "oByapssall for. .n.xet s

nd EI f

Nxte :eNt:x Nex:tNext: extN :extN

exNt :extN:N xe:t eNx:t exN: tNxe t

oopL Unilt Tuer

O nE rrro GoTo0

En dI fEnd

Wit h

Next w

En1dIf M

sgBxoA LLLECA R& AUHTRSO& V RESINO& R EPABKC ,vInfpmoatoni ,HEADR E

Edn ubS---

--------------------------------------------------------------------------------------

复到横线制以

6上、闭关编辑窗口；

、依7点次菜单栏击的工具-上---宏---宏-选,AllItennalPraswsods,r行运,确两定次 ；

等一会就会,出现下以话框：这对是就xcEl密码e对的原应始密码(密此码原和先置设密码的能打都此开档文如果。是别人的档，文你想又复密恢码置，设可以就此用码密行保护进，就他能他设置用的码打开密你，以可试试，很有趣的。字母一要定大写：

)

再点

击确。定Exelc原的始密就被码清除!!了