Yuav ua li cas tshem tus password los ntawm Excel VBA qhov project nrog / tsis muaj lo lus zais
Excel project Visual Basic for Applications (VBA) yog ib hom lus programming siv hauv Excel los tsim cov kev pab cuam yooj yim. Nws feem ntau yog siv los tig cov hauj lwm nyuaj lossis siv sij hawm mus rau hauv cov txheej txheem automated, txuag lub sij hawm, tig los txhim kho cov txheej txheem tshaj tawm. Cov haujlwm VBA no, txawm li cas los xij, qee zaum tuaj yeem tiv thaiv tus password, tiv thaiv koj tus kheej lossis tiv thaiv kev ua txhaum cai ntawm cov ntawv ua haujlwm qub. Yog li ntawd, qee zaum nws tuaj yeem nyuaj rau nco ntsoov cov passwords no, vim tias cov neeg siv tsis nco qab lossis poob tus password lossis rau ntau yam laj thawj. Yog li, tsab xov xwm no yuav qhia txog ntau txoj hauv kev yooj yim uas tuaj yeem siv los tshem tawm lo lus zais ntawm Excel VBA qhov project.
Muaj ob hom xwm txheej uas koj yuav ntsib thaum sim tshem cov passwords ntawm Excel VBA cov haujlwm. Peb yuav tham txog ob qho tib si ib kauj ruam.
Part 1: Tshem tawm Excel VBA Project Password yam tsis paub tus password
Txhawm rau ua qhov no, koj tuaj yeem siv ob peb txoj hauv kev, peb ntawm cov hauv qab no:
Tshem tawm Excel VBA Project Password hauv Ib Nyem rau XLS/XLSM Cov Ntaub Ntawv
Muaj ntau ntau cov kev pab cuam hauv kev ua lag luam uas tuaj yeem pab koj tshem tawm cov passwords ntawm Excel VBA qhov project. Ib qho piv txwv zoo yog Passper rau Excel , uas yog ib qho yooj yim thiab muaj txiaj ntsig kev daws teeb meem tam sim ntawd tshem tawm tag nrho cov kev kho thiab kev tiv thaiv formatting tsim hauv daim ntawv ua haujlwm / phau ntawv ua haujlwm los ntawm VBA code.
Qee qhov tseem ceeb ntawm Passper rau Excel yog:
- VBA qhov project password hauv koj phau ntawv ua haujlwm Excel tuaj yeem raug tshem tawm nrog ib tug yooj yim nias .
- Guarantee a 100% kev vam meej .
- Pab neeg Passper mob siab rau kev ruaj ntseg ntawm lawv cov ntaub ntawv . Yuav tsis muaj cov ntaub ntawv poob lossis xau thaum / tom qab cov txheej txheem tshem tawm.
- Qhov program muaj a dav compatibility . Txhawb .xls, .xlsx, .xlsm, .xlsb, .xltx, .xltm thiab lwm yam ntaub ntawv tsim los ntawm Microsoft Excel.
Txhawm rau qhia seb nws yooj yim npaum li cas los siv Passper rau Excel, peb tau npaj cov lus qhia ntxaws rau koj. Ua ntej tshaj plaws, koj yuav tsum rub tawm qhov program thiab nruab nws hauv koj lub computer.
Kauj ruam 1. Thaum ntsia, koj yuav tsum xaiv qhov "Tshem tawm kev txwv" kev xaiv.
Kauj ruam 2. Siv "Xaiv ib cov ntaub ntawv" khawm upload cov ntaub ntawv Excel tiv thaiv lo lus zais. Thaum cov ntaub ntawv ntxiv rau hauv software, tsuas yog nyem rau ntawm qhov "Delete" kev xaiv kom tshem tawm cov password tiv thaiv los ntawm koj daim ntawv Excel.
Kauj ruam 3. Tsis pub dhau lub vib nas this, VBA qhov project password yuav raug tshem tawm ntawm koj phau ntawv ua haujlwm Excel.
Passper rau Excel Nws yog ib qho kev pab cuam muaj zog thiab txhim khu kev qha. Nws tau txais kev tshuaj xyuas zoo los ntawm cov neeg siv. Tsis txhob yig tau siv nws.
Tshem tawm Excel VBA Project Password Online
Lwm txoj hauv kev los tshem tawm VBA qhov project password hauv koj cov ntaub ntawv Excel yog siv cov kev pabcuam online muaj nyob hauv lub vev xaib. Ib qho piv txwv zoo ntawm cov cuab yeej online no yog Office VBA Password Remover. Cov cuab yeej online no pab koj tshem tawm koj txoj kev tiv thaiv, tab sis yuav tsum tau ua ntau kauj ruam. Cov txheej txheem yog cov hauv qab no:
Kauj ruam 1: Nyem "Qhib Cov Ntaub Ntawv" txhawm rau rub koj VBA qhov project password tiv thaiv Excel cov ntaub ntawv.
Kauj ruam 2: Nyem "Decrypt VBA" kom paub meej tias rub tawm cov ntaub ntawv tshiab.
Kauj Ruam 3: Thaum downloaded, qhib cov ntaub ntawv. Nws yuav ceeb toom rau koj tias qhov project muaj tus yuam sij tsis raug. Nyem "Yes" mus txuas ntxiv.
Kauj Ruam 4: Nias ALT + F11 los qhib VBA qhov project. Nyob rau hauv lub qhov rais macro, koj yuav tsum tsis txhob nthuav qhov project. Tom ntej no, mus rau Cov Cuab Yeej> VBA Project Properties.
Kauj ruam 5: Mus rau Kev Tiv Thaiv tab, teeb tsa tus password tshiab uas koj xaiv thiab tawm hauv lub thawv xaiv.
Kauj Ruam 6: Txuag cov ntaub ntawv thiab kaw qhov project VBA.
Kauj Ruam 7: Qhib koj phau ntawv ua haujlwm Excel dua thiab rov ua kauj ruam 4.
Kauj Ruam 8: Lub sij hawm no koj yuav tsum tau tshem lub checkbox thiab password teb nyob rau hauv lub "Kev Tiv Thaiv" tab.
Kauj Ruam 9: Txuag cov ntaub ntawv dua. Tus password raug tshem tawm.
Cons ntawm txoj kev no:
- Uploading koj cov ntaub ntawv Excel yuav siv sij hawm. Tsis tas li ntawd, tsis muaj kev ua haujlwm bar, yog li koj tsis tuaj yeem qhia tias koj cov ntaub ntawv tau raug upload lossis tsis tau.
- Upload koj cov ntaub ntawv Excel rau lawv lub vev xaib tsis muaj kev nyab xeeb rau koj cov ntaub ntawv, tshwj xeeb tshaj yog thaum koj cov ntaub ntawv nkag siab.
Tshem Password los ntawm Excel VBA Project Siv HEX Editor
Lub hex editor tuaj yeem yog lub cuab yeej muaj txiaj ntsig yog tias koj xav tau manually tshem cov passwords ntawm koj qhov project Excel VBA. Muaj ob txoj hauv kev sib txawv uas yuav tsum tau tshem tawm cov passwords raws li Excel cov ntaub ntawv txuas ntxiv. Ua ntej pib txheej txheem phau ntawv, nco ntsoov ua ib qho thaub qab ntawm Excel cov ntaub ntawv koj ua haujlwm nrog.
Yog tias hom ntaub ntawv yog XLS:
Kauj ruam 1: Qhib cov ntaub ntawv lo lus zais-tiv thaiv .xls nrog hex editor thiab nrhiav txoj hlua "DPB."
Kauj ruam 2: Hloov "DPB" nrog "DPX".
Kauj Ruam 3: Txuag cov ntaub ntawv thiab tawm hauv lub editor.
Kauj Ruam 4: Tom ntej no, qhib cov ntaub ntawv nrog Microsoft Excel. Ntau qhov kev ceeb toom yuam kev yuav tshwm sim, uas yog qhov qub. Nco ntsoov nias rau ntawm lawv.
Kauj ruam 5: Tam sim no nias ALT + F11 los qhib VBA qhov project qhov rai thiab nyem rau ntawm VBAProject cov khoom los ntawm cov cuab yeej ntawv qhia zaub mov.
Kauj Ruam 6: Ntawm Kev Tiv Thaiv tab, hloov tus password rau qee yam yooj yim thiab nco ntsoov.
Kauj Ruam 7: Txuag phau ntawv ua haujlwm thiab tawm ntawm qhov rais.
Kauj Ruam 8: Rov qhib Excel phau ntawv ua haujlwm thiab nkag mus rau VBA qhov project qhov rai los ntawm nias ALT + F11 thiab nkag mus rau tus password koj nyuam qhuav hloov. Rov ua kauj ruam 6, tab sis lub sijhawm no koj tuaj yeem tshem tus password.
Kauj Ruam 9: Txuag phau ntawv ua haujlwm thiab tam sim no koj muaj cov ntaub ntawv Excel yam tsis muaj lo lus zais.
Yog tias hom ntaub ntawv yog XLSM:
Rau .xlsm txuas ntxiv, yuav tsum muaj ib kauj ruam ntxiv thaum pib. Hauv qab no peb muab koj cov lus qhia step-by-step.
Kauj ruam 1: Hloov qhov txuas ntxiv ntawm koj cov ntaub ntawv .xlsm rau .zip. Tom qab ntawd qhib nws nrog 7Zip lossis WinZip.
Kauj ruam 2: Nrhiav thiab luam cov ntaub ntawv “xl/vbaProject.bas” lossis “xl/vbaProject.bin” los ntawm cov ntaub ntawv zip. Xyuas kom tseeb tias lub zip nplaub tshev tseem qhib.
Kauj Ruam 3: Nyem thiab qhib "xl/vbaProject.bas" lossis "xl/vbaProject.bin" cov ntaub ntawv siv tus kho hex.
Kauj Ruam 4: Nrhiav txoj hlua "DPB" thiab hloov nws nrog "DPX".
Kauj ruam 5: Txuag cov ntaub ntawv, thiab luam rov qab mus rau Zip nplaub tshev (koj tuaj yeem luag thiab xa cov ntaub ntawv mus rau hauv nplaub tshev).
Kauj Ruam 6: Tam sim no, zip tag nrho cov ntaub ntawv hauv daim nplaub tshev rau hauv cov ntaub ntawv Zip tshiab. Tom ntej no, hloov cov ntaub ntawv txuas ntxiv mus rau .xlsm.
Kauj Ruam 7: Tom ntej no, qhib cov ntaub ntawv .xlsm. Ntau yam kev ceeb toom yuam kev yuav tshwm sim. Nyem "Yes" mus txuas ntxiv.
Kauj Ruam 8: Nias ALT + F11 kom qhib VBA qhov project thiab nyem VBAProject Properties ntawm cov cuab yeej ntawv qhia zaub mov.
Kauj Ruam 9: Qhib qhov Kev Tiv Thaiv tab, uncheck "Lock project rau saib" thiab nias OK.
Kauj ruam 10: Txuag cov ntaub ntawv .xlsm thiab kaw lub qhov rais
Cons ntawm txoj kev no:
- Muaj ntau hex editors ntawm lub vev xaib. Xaiv qhov zoo yog ib txoj haujlwm nyuaj yog tias koj tsis muaj kev paub txog kev paub.
- Qee cov neeg siv tau tshaj tawm tias lawv tsis tuaj yeem rub tawm tus lej hexadecimal editor. Yog li ntawd, txoj kev no tsis yog ib txwm muaj txiaj ntsig rau koj.
Part 2: Tshem tawm Excel VBA Project Password nrog Paub Password
Cov ntaub ntawv no yooj yim dua rau kev coj ua thiab zoo ib yam li peb cov kev sib tham yav dhau los. Kom nkag siab yooj yim, cov txheej txheem tau piav qhia hauv qab no:
Kauj ruam 1: Qhib koj phau ntawv ua haujlwm Excel nrog Microsoft Excel. Nias Alt + F11 kom nkag mus rau VBA qhov project.
Kauj ruam 2: Mus rau Cov Cuab Yeej> VBAProject Properties. Sau tus password kom raug hauv VBAProject Password dialog box.
Kauj Ruam 3: Mus rau ntawm Kev Tiv Thaiv tab, uncheck "Lock project rau saib" thiab lov tes taw tus password hauv cov thawv hauv qab no.
Kauj Ruam 4: Nyem "OK" thiab txuag cov haujlwm. Yog tag nrho.
Xaus
Nws tuaj yeem yog txoj haujlwm txaus ntshai kom tshem tawm VBA qhov project passwords los ntawm Excel cov ntaub ntawv. Nws yog ib txwm pom zoo kom siv cov kev daws teeb meem zoo thiab siv tau yooj yim thaum cuam tshuam nrog cov ntaub ntawv no. Qhov no txuag tau ntau lub sijhawm thiab yog qhov yooj yim tshaj plaws. Sim tam sim no Passper rau Excel thiab koj yuav zoo siab heev.
