Yuav ua li cas tshem Password ntawm Excel VBA Project [4 Txoj Kev]

Kuv xav paub yuav ua li cas tshem tus password los ntawm VBA qhov project hauv Excel. Leej twg tuaj yeem pab kuv?

Ua ntej txawm nrhiav txoj hauv kev los tshem tawm VBA lo lus zais hauv Excel, koj yuav tsum nkag siab lub ntsiab lus ntawm VBA. VBA yog ib qho luv luv rau Visual Basic rau Daim Ntawv Thov. Nws yog siv los ntawm ntau yam MS daim ntawv thov, tshwj xeeb tshaj yog MS Excel, ntxiv ib co nta thiab kuj pab nyob rau hauv automating niaj hnub ua hauj lwm. Vim lawv qhov xwm txheej thiab xav tau kev ruaj ntseg cov ntaub ntawv, feem ntau cov neeg siv encrypt VBA tej yaam num nrog passwords. Txawm li cas los xij, tib neeg tsis zoo tag nrho thiab VBA passwords tuaj yeem hnov ​​​​qab. Qhov cuam tshuam pom tseeb yog tias koj tsis tuaj yeem nkag lossis hloov kho koj cov lej Excel VBA. Txhawm rau tuav qhov kev ntxhov siab no, koj xav tau txoj hauv kev txhawm rau txhawm rau Excel VBA lo lus zais. Hmoov zoo, muaj ntau txoj hauv kev los ua kom tiav txoj haujlwm no. Hauv tsab xov xwm no, koj yuav tau txais cov lus qhia ntxaws ntxaws rau saum 4 txoj hauv kev txhawm rau txhawm rau Excel VBA passwords.

Part 1: Yuav ua li cas tshem VBA Project Password nyob rau hauv Excel tsis muaj cov kev pab cuam

Kev xauv lub VBA qhov project hauv Excel tuaj yeem ua tiav nrog kev pab los ntawm VBA decryption software tsis siv neeg lossis los ntawm phau ntawv txhais tau tias. Delving rau hauv yuav ua li cas tawg Excel VBA lo lus zais manually, muaj ntau txoj hauv kev zoo uas muaj peev xwm ua tiav txoj haujlwm. Koj tuaj yeem xaiv los ntawm cov kev xaiv no thiab sim nrog koj cov ntaub ntawv Excel tiv thaiv. Thaum kawg, ib qho ntawm cov kev xaiv no yuav zoo dua, nyob ntawm seb koj cov ntaub ntawv tiv thaiv thiab qhov xav tau ntawm tes. Ua ntej siv cov txheej txheem phau ntawv no, koj yuav tsum rov qab koj cov ntaub ntawv Excel.

Txoj Kev 1. Hloov cov ntaub ntawv txuas ntxiv kom qhib Excel VBA module

Txoj kev no suav nrog hloov .xlsm cov ntaub ntawv txuas ntxiv mus rau lwm hom ntawv thiab rov qab mus rau .xlsm hom tom qab. Txawm hais tias tus txheej txheem ntev, koj tuaj yeem ua raws li nws ua tib zoo tshem koj Excel VBA lo lus zais thaum kawg. Cov kauj ruam hauv qab no qhia txog yuav ua li cas koj tuaj yeem tawg Excel VBA qhov project password los ntawm kev hloov cov ntaub ntawv txuas ntxiv.

Kauj ruam 1 : Nrhiav lub hom phiaj .xlsm cov ntaub ntawv thiab hloov .xlsm cov ntaub ntawv txuas mus rau zip.

Kauj ruam 2 : Tam sim no qhib cov ntaub ntawv no los ntawm ib qho ntawm cov kev pab cuam Archiver koj muaj. Koj tuaj yeem siv WinRAR lossis 7-Zip. Yog tias koj ua li no, koj yuav tsum tuaj yeem pom cov qauv hauv qab no ntawm koj cov ntaub ntawv teev npe.

Kauj ruam 3 : Nkag mus rau XL directory xaiv thiab rho tawm cov ntaub ntawv sau npe "VBAProject.bin".

Kauj ruam 4 : Qhib VBAProject.bin cov ntaub ntawv los ntawm ib qho hex editor thiab kos cov ntawv "DPB=" hauv cov ntaub ntawv hauv hex editor.

Kauj ruam 5 : Thaum koj pom cov ntawv no, tsuas yog rho tawm thiab hloov nws nrog "DPX =" hloov. Tam sim no txuag thiab kaw koj cov ntaub ntawv hauv hex editor. Overwrites tus qub VBAProject.bin nrog tus tshiab hex-edited VBAProject.bin.

Kauj ruam 6 : Rov qab cov ntaub ntawv txuas ntxiv mus rau .xlsm thiab tom qab ntawd qhib nws hauv Excel. Hauv lub qhov rais pop-up ceeb toom, xaiv "Yes" thiab tsis quav ntsej lwm txoj kev xaiv.

Kauj ruam 7 : Khiav lub VBA editor thiab xaiv "OK" yog tias lub dialog box tshwm.

Kauj ruam 8 : Txoj cai-nias lub npe ntawm koj qhov project VBA thiab tom qab ntawd xaiv cov khoom. Xaiv "Kev Tiv Thaiv" tab thiab tshem tawm cov passwords uas twb muaj lawm. Tsis tas li ntawd, lov tes taw "Lov Project rau Saib" checkbox thiab qhib nws dua. Sau tus password uas tsim nyog thiab paub meej tias nws. Nyem "OK" kom hloov pauv.

Txoj Kev 2. Tshem tawm Excel VBA Project Password nrog Hex Editor

Hex Editor muab lub platform zoo rau koj los kho cov khoom hex thiab thaum kawg tawg Excel VBA lo lus zais. Hauv txoj kev no, koj yuav tsim cov ntaub ntawv dummy xls, teeb tus password, thiab siv nws nkag mus rau Excel tiv thaiv.

Kauj ruam 1 : Siv Hex editor los tsim cov ntaub ntawv Excel (xls) tshiab. Tsuas yog cov ntaub ntawv yooj yim tuaj yeem ua tau.

Kauj ruam 2 : Tsim tus password rau cov ntaub ntawv no hauv ntu VBA. Koj tuaj yeem nias Alt + F11 kom nkag mus rau qhov kev xaiv no.

Kauj ruam 3 : Tom qab koj tau tsim ib qho yooj yim-rau-nco tus password, txuag cov ntaub ntawv tshiab no thiab tawm.

Kauj ruam 4 : Qhib cov ntaub ntawv tsim tshiab no, tab sis lub sijhawm no, qhib nws los ntawm hex editor. Thaum qhib, nrhiav thiab luam cov kab, uas pib nrog cov yawm sij hauv qab no: CMG =, DPB = thiab GC = .

Kauj ruam 5 : Tam sim no qhib Excel cov ntaub ntawv uas koj xav kom tawg tus password nrog Hex editor. Muab cov ntawv theej rau hauv cov teb thiab khaws cov kev hloov pauv. Tawm hauv cov ntaub ntawv.

Kauj ruam 6 : Feem ntau qhib Excel cov ntaub ntawv thiab siv tib lo lus zais uas koj tsim rau dummy xls cov ntaub ntawv los saib VBA code.

Txoj Kev 3. Tshem tawm lo lus zais los ntawm Excel VBA qhov project nrog Visual Basic Editor

Tsis zoo li Hex editor, Visual Basic Editor tso cai rau cov neeg siv los hloov cov cim cim tsis yog hexadecimal sawv daws yuav. Cov txheej txheem tsis ntev li ntawd. Txawm li cas los xij, koj yuav tsum tau ceev faj vim tias cov lej yuav tsum tau saib xyuas kom tsis txhob ua yuam kev. Cov kauj ruam hauv qab no qhia meej meej tias koj tuaj yeem tawg Excel Macro lo lus zais nrog Visual Basic Editor.

Kauj ruam 1 : Qhib phau ntawv ua haujlwm uas muaj cov ntawv Excel tiv thaiv.

Kauj ruam 2 : Tam sim no qhib Visual Basic Editor siv Alt + F11 hais kom ua. Mus rau Embed Module thiab tom qab ntawd muab cov lej hauv qab no rau hauv lub qhov rai code muaj nyob rau sab xis.

Kauj ruam 3 : Tawm ntawm VBA Editor qhov rai thiab txuas ntxiv nrog cov ntawv ua haujlwm tiv thaiv.

Kauj ruam 4 : Mus rau Cov Cuab Yeej> Macro> Macros. Hauv cov npe uas tshwm, nyem ob npaug rau ntawm qhov "PasswordBreaker" xaiv. Tam sim no koj yuav tsum nkag mus rau koj cov ntaub ntawv Excel tiv thaiv tus password.

Ntu 2: Phau ntawv txwv kev txwv thaum qhib VBA qhov project hauv Excel

Txawm hais tias phau ntawv txoj kev muaj txiaj ntsig zoo rau kev tawg Excel VBA passwords, lawv tsis nyob ze qhov zoo tshaj plaws. Cov txheej txheem no tau plagued nrog ntau yam teeb meem uas ua rau lawv tsis zoo thaum nws los txog rau cov ntaub ntawv Excel tseem ceeb thiab nyuaj. Cov hauv qab no yog qee qhov kev txwv ntau ntawm cov txheej txheem phau ntawv.

• Yuav tsum muaj kev txawj ntse : Raws li koj tau pom, feem ntau ntawm cov kev xaiv saum toj no suav nrog ntau tus lej. Yog li yog tias koj muaj kev paub me ntsis, koj yuav muaj lub sijhawm nyuaj nrog cov kev xaiv phau ntawv no.
• Nws siv sijhawm ntau : Ntau txoj hauv kev los ntawm phau ntawv muaj cov txheej txheem ntev. Qhov tseeb tias nws kuj muaj cov lej thiab kev txav mus los ntawm ntau lub platform ua rau nws nyuaj dua thiab yog li cov neeg siv yuav pom nws qeeb thiab nkees.
• Kev vam meej : Dab tsi tseem ceeb, thaum kawg, yog seb peb puas tuaj yeem tawg Excel VBA lo lus zais lossis tsis tau. Hmoov tsis zoo, cov kev xaiv phau ntawv no sau cov kev ua tiav qis tshaj plaws. Yog li ntawd, nws tsis pom zoo kom siv sijhawm ntau thiab lub zog thiab tom qab ntawd tsis tau txais qhov txiaj ntsig koj xav tau.

Uas tau hais tias, yog tias txhua qhov kev xaiv ua tsis tiav lossis koj nkees ntawm lawv qhov tsis txaus, tom qab ntawd sim siv cov ntawv thov tshwj xeeb xws li Passper rau Excel txhawm rau txhawm rau Excel VBA lo lus zais cia.

Part 3: Yuav ua li cas Crack Excel VBA Password Automatically

Passper rau Excel yog ib qho zoo kawg nkaus password qhib lub cuab yeej rau Excel cov ntaub ntawv. Qhov kev zov me nyuam lav 100% kev ua tiav ntawm kev tawg Excel VBA qhov project password. Nrog lub super ceev decryption ceev thiab yooj yim ntawm kev siv, tsis muaj laj thawj tsis ntseeg lub peev xwm ntawm Passper rau Excel. Nws tseem ceeb heev uas yuav tsum nco ntsoov tias Passper rau Excel tuaj yeem siv los tawg cov ntaub ntawv qhib lo lus zais rau Excel cov ntaub ntawv.

Cov yam ntxwv tseem ceeb ntawm Passper rau Excel:

• Tag nrho cov kev txwv kho thiab formatting hauv koj qhov project VBA, ntawv ua haujlwm, lossis phau ntawv ua haujlwm tuaj yeem txiav txim siab tam sim ntawd.
• Nrog Passper rau Excel, ib qho yooj yim nyem yuav tso cai rau koj tshem tawm cov password tiv thaiv ntawm koj qhov project VBA.
• Koj cov ntaub ntawv yuav tsis raug cuam tshuam lossis puas tom qab siv qhov program.
• Qhov kev zov me nyuam muaj kev sib raug zoo heev. Txhua hom ntaub ntawv Excel suav nrog .xlsm, .xlsb, .xltx, .xltm yog sib xws nrog nws.

Passper rau Excel tau pab ntau lab tus neeg siv thoob ntiaj teb. Thiab nws tau txais kev tshuaj xyuas zoo los ntawm nws cov neeg siv. Tsis txhob yig mus sim tam sim no.

Sim nws dawb

Yuav ua li cas tshem tawm VBA lo lus zais hauv Excel nrog Passper rau Excel

Kauj ruam 1: Tua tawm Passper rau Excel ntawm koj lub PC thiab nyem rau ntawm "Tshem tawm Cov Kev Txwv" xaiv.

Kauj ruam 2: Hauv lub qhov rais tshiab, nyem lub pob "Xaiv cov ntaub ntawv" thiab ua raws li cov lus qhia ntawm lub vijtsam txhawm rau rub tus password tiv thaiv Excel VBA cov ntaub ntawv mus rau qhov program interface.

Kauj Ruam 3: Thaum cov ntaub ntawv tiv thaiv lo lus zais raug rub tawm, nias qhov "Delete" kev xaiv kom tshem tawm VBA qhov project password hauv koj cov ntaub ntawv Excel.

Qhov kev zov me nyuam yuav tshem tawm cov kev txwv tsis pub dhau lub vib nas this. Thaum nws ua tiav, koj yuav tsum pom qhov kev ceeb toom ua tiav nyob rau hauv qab ntawm qhov screen.

Xaus

Cov lus qhia no tau piav qhia meej meej txog qee txoj hauv kev ua kom tawg Excel VBA passwords. Txawm li cas los xij, qee cov ntaub ntawv muaj txiaj ntsig zoo dua li lwm tus vim lawv muaj peev xwm tswj hwm VBA cov passwords nyuaj, yooj yim siv, thiab tshaj tawm cov txiaj ntsig tau zoo. Los ntawm cov ntaub ntawv loj uas tau muab los saum toj no, tsis muaj leej twg tuaj yeem sib cav Passper rau Excel raws li qhov kev daws teeb meem tiag tiag kom tawg Excel VBA qhov project password. Tag nrho cov ntsuas ntsuas muab nws ua ntej ntawm phau ntawv xaiv. Xaiv Passper rau Excel thiab daws koj cov teeb meem VBA lo lus zais mus ib txhis.

Sim nws dawb