Iprojekthi ye-Excel iVisual Basic for Applications (VBA) lulwimi lweprogram olusetyenziswa ngaphakathi kwe-Excel ukuphuhlisa iinkqubo ezilula. Ngokuqhelekileyo isetyenziselwa ukuguqula imisebenzi enzima okanye echitha ixesha ibe yinkqubo ezenzekelayo, egcina ixesha, ekuphuculeni umgangatho wenkqubo yokunika ingxelo. Ezi projekthi ze-VBA, nangona kunjalo, ngamanye amaxesha zinokukhuselwa ngegama eliyimfihlo, ukukhusela ubumfihlo bakho okanye ukuthintela nakuphi na ukwaphulwa kweskripthi sokuqala esisebenzayo. Ngenxa yoko, ngamanye amaxesha kunokuba nzima ukukhumbula la magama agqithisiweyo, mhlawumbi ngenxa yokuba abasebenzisi balibele okanye balahlekelwe igama eliyimfihlo okanye ngenxa yezizathu ezahlukeneyo. Ke ngoko, eli nqaku liza kuqaqambisa iindlela ezahlukeneyo ezilula ezinokusetyenziswa ukususa igama lokugqitha kwiprojekthi ye-Excel VBA.
Kukho iindidi ezimbini zeemeko onokudibana nazo xa uzama ukususa amagama ayimfihlo kwiiprojekthi ze-Excel VBA. Siza kuthetha ngezinto zombini inyathelo ngenyathelo.
Icandelo 1: Susa i-Excel VBA Password yeProjekthi Ngaphandle kokwazi igama eliyimfihlo
Ukwenza oku, unokuthatha iindlela ezininzi, ezintathu kuzo zezi zilandelayo:
Susa i-Excel VBA Password yeProjekthi kwiNqakrazo enye yeeFayile ze-XLS/XLSM
Kukho iinkqubo ezininzi kwimarike ezinokukunceda ukususa amagama ayimfihlo kwiprojekthi ye-Excel VBA. Umzekelo omhle ngulo Ipasile le-Excel , Isisombululo esilula nesisebenzayo sokulahla ngokukhawuleza zonke izikhuselo zokuhlela kunye nokufomatha eyakhelwe ngaphakathi kwiphepha lomsebenzi / incwadi yokusebenzela ngekhowudi ye-VBA.
Ezinye zeempawu eziphambili zePassper ye-Excel zezi:
- Iphasiwedi yeprojekthi ye-VBA kwincwadi yakho yokusebenza ye-Excel inokususwa ngonqakrazo olulula .
- Isiqinisekiso a 100% izinga lempumelelo .
- Iqela lePass liyakhathala ukhuseleko lwe zabo idatha . Akuyi kubakho ilahleko yedatha okanye ukuvuza ngexesha / emva kwenkqubo yokususa.
- Inkqubo ine a ukuhambelana okubanzi . Ixhasa .xls, .xlsx, .xlsm, .xlsb, .xltx, .xltm kunye nezinye iifayile ezenziwe nguMicrosoft Excel.
Ukubonisa indlela ekulula ngayo ukusebenzisa iPasser ye-Excel, sikulungiselele isikhokelo esineenkcukacha. Okokuqala, kufuneka ukhuphele inkqubo kwaye uyifake kwikhompyuter yakho.
Inyathelo 1. Xa sele ifakiwe, kufuneka ukhethe "Susa izithintelo" ukhetho.
Inyathelo 2. Sebenzisa iqhosha elithi "Khetha ifayile" ukufaka ifayile ye-Excel ekhuselweyo. Nje ukuba ifayile yongezwe kwisoftware, cofa ngokulula ku "Cima" ukhetho lokususa ukhuseleko lokugqitha kwiphepha lakho le-Excel.
Inyathelo 3. Ngemizuzwana nje, igama eliyimfihlo leprojekthi ye-VBA liya kususwa kwincwadi yakho yokusebenza ye-Excel.
Ipasile le-Excel Yinkqubo enamandla kwaye ethembekileyo. Ifumene uphononongo oluhle kubasebenzisi. Ungalibazisi ukuyisebenzisa.
Susa i-Excel VBA Password yeProjekthi kwi-Intanethi
Enye indlela yokususa igama lokugqitha leprojekthi ye-VBA kumaxwebhu akho e-Excel kukusebenzisa inkonzo ye-intanethi ekhoyo kwiwebhu. Umzekelo omhle wolu hlobo lwesixhobo se-intanethi yi-Office VBA Password Remover. Esi sixhobo se-intanethi sikunceda ukuba ulahle ukhuseleko lwakho, kodwa sifuna amanyathelo amaninzi. Inkqubo yile ilandelayo:
Inyathelo loku-1: Cofa "Vula iFayile" ukuze ulayishe ifayile yakho ye-VBA yeprojekthi ekhuselweyo ye-Excel.
Inyathelo lesi-2: Cofa u-"Decrypt VBA" ukuze uqinisekise ukukhutshelwa koxwebhu olutsha.
Inyathelo lesi-3: Wakuba ukhutshiwe, vula uxwebhu. Iza kukukhumbuza ukuba iprojekthi iqulethe isitshixo esingasebenziyo. Cofa u-"Ewe" ukuze uqhubeke.
Inyathelo lesi-4: Cofa i-ALT+F11 ukuvula iprojekthi ye-VBA. Ngaphakathi kwefestile enkulu, akufanele ukwandise iprojekthi. Emva koko, yiya kwiZixhobo> IiPropati zeProjekthi yeVBA.
Inyathelo lesi-5: Yiya kwithebhu yoKhuselo, seta igama eligqithisiweyo elitsha olikhethileyo kwaye ushiye ibhokisi yokukhangela ekhethiweyo.
Inyathelo lesi-6: Gcina uxwebhu kwaye uvale iprojekthi ye-VBA.
Inyathelo lesi-7: Vula incwadi yakho ye-Excel kwakhona kwaye uphinda inyathelo lesi-4.
Inyathelo lesi-8: Ngeli xesha kufuneka ucime ibhokisi yokukhangela kunye neendawo zokugqitha kwithebhu ethi "Ukhuseleko".
Inyathelo 9: Gcina uxwebhu kwakhona. Igama lokugqithisa lisusiwe.
Iingxaki zale ndlela:
- Ukulayisha ifayile yakho ye-Excel kuya kuthatha ixesha. Kwakhona, akukho bar yokucwangcisa, ngoko awukwazi ukuxelela ukuba ifayile yakho ilayishiwe okanye hayi.
- Ukulayisha ifayile yakho ye-Excel kwiwebhusayithi yabo akukhuselekanga kwidatha yakho, ngakumbi xa idatha yakho ibuthathaka.
Susa igama lokugqithisa kwiProjekthi ye-Excel VBA usebenzisa i-HEX Editor
Umhleli we-hex unokuba sisixhobo esiluncedo ukuba ufuna ukususa ngesandla amagama ayimfihlo kwiprojekthi yakho ye-Excel VBA. Kukho iindlela ezimbini ezahlukeneyo ezifunekayo ukususa amagama ayimfihlo asekwe kuhlobo lwefayile ye-Excel. Ngaphambi kokuqala inkqubo yesandla, hlala ukhumbula ukwenza ugcino lweefayile ze-Excel osebenza nazo.
Ukuba uhlobo lwefayile yi-XLS:
Inyathelo loku-1: Vula ifayile yegama eliyimfihlo ekhuselweyo .xls ngomhleli wehex kwaye ujonge umtya "DPB."
Inyathelo lesi-2: Buyisela u-“DPB” nge-“DPX”.
Inyathelo lesi-3: Gcina ifayile kwaye uphume kumhleli.
Inyathelo lesi-4: Okulandelayo, vula ifayile ngeMicrosoft Excel. Izaziso zeempazamo ezininzi ziya kuvela, nto leyo eqhelekileyo. Qiniseka ukuba ucofa kuzo.
Inyathelo lesi-5: Ngoku cinezela i-ALT+F11 ukuvula iwindow yeprojekthi yeVBA kwaye ucofe kwiipropathi zeVBAProject kwimenyu yeZixhobo.
Inyathelo lesi-6: Kwithebhu yoKhuselo, tshintsha igama lokugqitha liye kwinto elula nekulula ukuyikhumbula.
Inyathelo lesi-7: Gcina incwadi yomsebenzi kwaye uphume efestileni.
Inyathelo lesi-8: Phinda uvule incwadi yokusebenza ye-Excel kwaye ufikelele kwifestile yeprojekthi ye-VBA ngokucofa i-ALT+F11 kwaye ungenise igama eligqithisiweyo osanda kulitshintsha. Phinda inyathelo lesi-6, kodwa ngeli xesha unako ukususa igama eligqithisiweyo.
Inyathelo 9: Gcina incwadi yomsebenzi kwaye ngoku unefayile ye-Excel ngaphandle kwegama lokugqitha.
Ukuba uhlobo lwefayile yi-XLSM:
Kwizandiso ze-.xlsm, inyathelo elongezelelweyo liyafuneka ekuqaleni. Ngezantsi sikunikeza isikhokelo senyathelo ngenyathelo.
Inyathelo loku-1: Guqula ulwandiso lwefayile yakho ye-xlsm ukuya kwi-.zip. Emva koko vula nge7Zip okanye WinZip.
Inyathelo lesi-2: Fumana kwaye ukopishe ifayile "xl/vbaProject.bas" okanye "xl/vbaProject.bin" kwifayile ye-zip. Qinisekisa ukuba isiqulathi seefayili se-zip sisavuliwe.
Inyathelo lesi-3: Cofa kwaye uvule "xl/vbaProject.bas" okanye "xl/vbaProject.bin" ifayile usebenzisa umhleli we-hex.
Inyathelo lesi-4: Fumana umtya "DPB" kwaye ubeke endaweni yawo "DPX".
Inyathelo lesi-5: Gcina ifayile, kwaye uyikopishe kwakhona kwifolda yeZip (ungatsala kwaye ulahle ifayile kwifolda).
Inyathelo lesi-6: Ngoku, zip zonke iifayile kwifolda kwifayile entsha yeZip. Okulandelayo, tshintsha ulwandiso lwefayile ukuya ku .xlsm.
Inyathelo lesi-7: Okulandelayo, vula ifayile ye-xlsm. Izaziso zeempazamo ezahlukeneyo ziya kuvela. Cofa u-"Ewe" ukuze uqhubeke.
Inyathelo lesi-8: Cinezela i-ALT+F11 ukuvula iprojekthi ye-VBA kwaye ucofe iiPropati zeVBAProject kwimenyu yeZixhobo.
Inyathelo 9: Vula ithebhu yoKhuselo, sukukhangela "Tshixa iprojekthi yokujonga" kwaye ucinezele u-Kulungile.
Inyathelo 10: Gcina ifayile ye.xlsm kwaye uvale ifestile
Iingxaki zale ndlela:
- Baninzi abahleli be-hex kwiwebhusayithi. Ukukhetha okulungileyo ngumsebenzi onzima ukuba awunalo ulwazi lobugcisa.
- Abanye abasebenzisi baxele ukuba abanakukhuphela umhleli we-hexadecimal. Ngoko ke, le ndlela ayisoloko iluncedo kuwe.
Icandelo 2: Susa i-Excel VBA Password yeProjekthi enegama lokugqithisa elaziwayo
Eli tyala lilula ukwenza kwaye liyafana nengxoxo yethu yangaphambili. Ukuze kube lula ukuqonda, inkqubo ichazwe ngezantsi:
Inyathelo loku-1: Vula incwadi yakho yokusebenza ye-Excel ngeMicrosoft Excel. Cofa u-Alt+F11 ukufikelela kwiprojekthi ye-VBA.
Inyathelo lesi-2: Yiya kwiZixhobo> IiPropati zeVBAProject. Ngenisa igama eligqithisiweyo elichanekileyo kwibhokisi yencoko yababini ye-VBAProject Password.
Inyathelo lesi-3: Yiya kwithebhu yoKhuselo, ungachongi "Tshixa iprojekthi yokujonga" kwaye ukhubaze igama eligqithisiweyo kwiibhokisi ezilandelayo.
Inyathelo lesi-4: Cofa "Kulungile" kwaye ugcine umsebenzi. Kuko konke.
Ukuqukumbela
Inokuba ngumsebenzi owoyikekayo ukususa amagama ayimfihlo eprojekthi ye-VBA kwiifayile ze-Excel. Kuhlala kucetyiswa ukuba kusetyenziswe isisombululo esisebenzayo kwaye kulula ukuyisebenzisa xa ujongene nezi ntlobo zeefayile. Oku konga ixesha elininzi kwaye yeyona nto iluncedo. Zama ngoku Ipasile le-Excel kwaye uya kumangaliswa kakhulu.
