para desproteger hojas ocultas.docx
TRANSCRIPT
-
8/16/2019 para desproteger hojas ocultas.docx
1/4
Public Sub AllInternalPasswords() ' Breaks worksheet and workbook structure passwords. BobMcCormick ' probably oriinator o! base code alorithm modi!ied !orco"erae ' o! workbook structure # windows passwords and !or multiplepasswords
' ' $orman %arker and & Mcimpsey *+,ec+-- (ersion /./) ' Modi!ied --0+Apr+-1 by &M2 All mss to constants3 and ' eliminate one 4it Sub (ersion /././) ' 5e"eals hashed passwords $67 oriinal passwords Const ,B8SPAC As Strin 9 "b$ew8ine : "b$ew8ine Const A;7%65S As Strin 9 ,B8SPAC : "b$ew8ine : < =Adapted !rom Bob McCormick base code by= : < =$orman %arker and & Mcimpsey= Const %A,5 As Strin 9 =AllInternalPasswords ;ser Messae= Const 5SI6$ As Strin 9 ,B8SPAC : =ersion /././ --0+Apr+-1= Const 5PBAC> As Strin 9 ,B8SPAC : =Please report !ailure = :
< =to the microso!t.public.e4cel.prorammin newsroup.= Const A88C8A5 As Strin 9 ,B8SPAC : =7he workbook should = :< =now be !ree o! all password protection3 so make sureyou2= : < ,B8SPAC : =SA I7 $6?@= : ,B8SPAC : =and also= : < ,B8SPAC : =BAC>;P@3 BAC>;P@@3 BAC>;P@@@= : < ,B8SPAC : =Also3 remember that the password was = : < =put there !or a reason. ,on't stu!! up crucial!ormulas = : < =or data.= : ,B8SPAC : =Access and use o! some data =: < =may be an o!!ense. I! in doubt3 don't.= Const MS$6P?65,S/ As Strin 9 =7here were no passwords on = :< =sheets3 or workbook structure or windows.= : A;7%65S :5SI6$ Const MS$6P?65,S As Strin 9 =7here was no protection to = :< =workbook structure or windows.= : ,B8SPAC : < =Proceedin to unprotect sheets.= : A;7%65S : 5SI6$ Const MS7A>7IM As Strin 9 =A!ter pressin 6> button this =: < =will take some time.= : ,B8SPAC : =Amount o! time = :< =depends on how many di!!erent passwords3 the = : <
=passwords3 and your computer's speci!ication.= :,B8SPAC : < =&ust be patient@ Make me a co!!ee@= : A;7%65S :5SI6$ Const MSP?65,6;$,/ As Strin 9 =ou had a ?orksheet = : < =Structure or ?indows Password set.= : ,B8SPAC : < =7he password !ound was2 = : ,B8SPAC : == : ,B8SPAC: < =$ote it down !or potential !uture use in otherworkbooks by = :
-
8/16/2019 para desproteger hojas ocultas.docx
2/4
=the same person who set this password.= : ,B8SPAC : < =$ow to check and clear other passwords.= : A;7%65S :5SI6$ Const MSP?65,6;$, As Strin 9 =ou had a ?orksheet = : < =password set.= : ,B8SPAC : =7he password !ound was2 =: < ,B8SPAC : == : ,B8SPAC : =$ote it down !or
potential = : < =!uture use in other workbooks by same person who = : < =set this password.= : ,B8SPAC : =$ow to check andclear = : < =other passwords.= : A;7%65S : 5SI6$ Const MS6$86$ As Strin 9 =6nly structure # windows = : < =protected with the password that was Dust !ound.= : < A88C8A5 : A;7%65S : 5SI6$ : 5PBAC> ,im w/ As ?orksheet3 w As ?orksheet ,im i As Inteer3 D As Inteer3 k As Inteer3 l As Inteer ,im m As Inteer3 n As Inteer3 i/ As Inteer3 i As Inteer ,im i0 As Inteer3 i1 As Inteer3 iE As Inteer3 iF As Inteer ,im P?ord/ As Strin
,im Sh7a As Boolean3 ?in7a As Boolean
Application.Screen;pdatin 9 alse ?ith Acti"e?orkbook ?in7a 9 .ProtectStructure 6r .Protect?indows nd ?ith Sh7a 9 alse or ach w/ In ?orksheets Sh7a 9 Sh7a 6r w/.ProtectContents $e4t w/ I! $ot Sh7a And $ot ?in7a 7hen MsBo4 MS$6P?65,S/3 "bIn!ormation3 %A,5 4it Sub nd I! MsBo4 MS7A>7IM3 "bIn!ormation3 %A,5 I! $ot ?in7a 7hen MsBo4 MS$6P?65,S3 "bIn!ormation3 %A,5 lse 6n rror 5esume $e4t ,o 'dummy do loop or i 9 FE 7o FF2 or D 9 FE 7o FF2 or k 9 FE 7o FF or l 9 FE 7o FF2 or m 9 FE 7o FF2 or i/ 9 FE 7o FF or i 9 FE 7o FF2 or i0 9 FE 7o FF2 or i1 9 FE 7o FF or iE 9 FE 7o FF2 or iF 9 FE 7o FF2 or n 9 0 7o /F ?ith Acti"e?orkbook .;nprotect Chr(i) : Chr(D) : Chr(k) : <
Chr(l) : Chr(m) : Chr(i/) : Chr(i) : < Chr(i0) : Chr(i1) : Chr(iE) : Chr(iF) : Chr(n) I! .ProtectStructure 9 alse And < .Protect?indows 9 alse 7hen P?ord/ 9 Chr(i) : Chr(D) : Chr(k) : Chr(l) : < Chr(m) : Chr(i/) : Chr(i) : Chr(i0) : < Chr(i1) : Chr(iE) : Chr(iF) : Chr(n) MsBo4 Application.Substitute(MSP?65,6;$,/3 < ==3 P?ord/)3 "bIn!ormation3 %A,5 4it ,o 'Bypass all !or...ne4ts
-
8/16/2019 para desproteger hojas ocultas.docx
3/4
nd I! nd ?ith $e4t2 $e4t2 $e4t2 $e4t2 $e4t2 $e4t $e4t2 $e4t2 $e4t2 $e4t2 $e4t2 $e4t 8oop ;ntil 7rue 6n rror o7o - nd I!
I! ?in7a And $ot Sh7a 7hen MsBo4 MS6$86$3 "bIn!ormation3 %A,5 4it Sub nd I! 6n rror 5esume $e4t or ach w/ In ?orksheets 'Attempt clearance with P?ord/ w/.;nprotect P?ord/ $e4t w/ 6n rror o7o - Sh7a 9 alse or ach w/ In ?orksheets 'Checks !or all clear Sh7a triered to / i! not.
Sh7a 9 Sh7a 6r w/.ProtectContents $e4t w/ I! Sh7a 7hen or ach w/ In ?orksheets ?ith w/ I! .ProtectContents 7hen 6n rror 5esume $e4t ,o ',ummy do loop or i 9 FE 7o FF2 or D 9 FE 7o FF2 or k 9 FE 7oFF or l 9 FE 7o FF2 or m 9 FE 7o FF2 or i/ 9 FE 7oFF or i 9 FE 7o FF2 or i0 9 FE 7o FF2 or i1 9 FE7o FF or iE 9 FE 7o FF2 or iF 9 FE 7o FF2 or n 9 0 7o/F .;nprotect Chr(i) : Chr(D) : Chr(k) : < Chr(l) : Chr(m) : Chr(i/) : Chr(i) : Chr(i0) : < Chr(i1) : Chr(iE) : Chr(iF) : Chr(n) I! $ot .ProtectContents 7hen P?ord/ 9 Chr(i) : Chr(D) : Chr(k) : Chr(l) : < Chr(m) : Chr(i/) : Chr(i) : Chr(i0) : < Chr(i1) : Chr(iE) : Chr(iF) : Chr(n) MsBo4 Application.Substitute(MSP?65,6;$,3 < ==3 P?ord/)3 "bIn!ormation3 %A,5 'le"erae !indin Pword by tryin on other sheets or ach w In ?orksheets
w.;nprotect P?ord/ $e4t w 4it ,o 'Bypass all !or...ne4ts nd I! $e4t2 $e4t2 $e4t2 $e4t2 $e4t2 $e4t $e4t2 $e4t2 $e4t2 $e4t2 $e4t2 $e4t 8oop ;ntil 7rue 6n rror o7o - nd I! nd ?ith
-
8/16/2019 para desproteger hojas ocultas.docx
4/4
$e4t w/ nd I! MsBo4 A88C8A5 : A;7%65S : 5SI6$ : 5PBAC>3 "bIn!ormation3%A,5nd Sub