Kodhi yeVBA yaunonyora ndiyo moyo nemweya wespredishiti yako. Kuchengetedza kodhi yeVBA chinhu chinofanira kuitwa kuti kodhi yako isabirwe kana kushandiswa iwe usingazive. Chinyorwa chino chichataura nezvenzira dzakasiyana dzekuchengetedza kodhi yako yeVBA kuitira kuti iwe chete ugone kuiwana zviri nyore.
Sei Uchifanira Kufunga Nezvekuchengetedza VBA Code?
VBA mutauro mukuru unogona kushandiswa kugadzira mabasa kana zviito zvinoitwa otomatiki muExcel, Word, PowerPoint. Pane zvikonzero zvakati wandei zvekuti uchengetedze kodhi yako yeVBA:
- Kudzivirira kodhi yako yeVBA kuti isachinjwe netsaona. VBA code chishandiso chine simba kune vashandisi veExcel, asi chinogonawo kukonzera kushushikana kune avo vasingaishandise. Kana ukasachengetedza VBA nepassword, vamwe vanoshandisa bhuku rako rebasa vanogona kuwana kodhi yacho voichinja vasingazive zvavari kuita. Haudi kugadzirisa kodhi yako yeVBA nekuti inogona kurwadza—zvingatora maawa kuti uzive kuti sei uye wobva watora nguva yakareba!
- Kuchengetedza pfuma yako yepfungwa. VBA code inogona kubatsira zvikuru kune mamwe makambani. Kana mumwe munhu akapinda muspredishiti yako okopa mashandiro aunoshandisa, anogona kuitora sebasa rake ega oitengesa kumakambani akawanda. Chengetedza source code yako inokosha nematanho ekuchengetedza. Usaite kuti zvive nyore kuti chero ani zvake aba kana kukopa.
- Kuzvidzivirira kubva kuvanhu vanoshandisa basa rako. Kana uine kodhi yeVBA inokosha iri kuita kuti basa rako rive nyore kana kuti rishande zvakanaka, saka ungangoda kuichengetedza kuti ishandiswe iwe pachako chete.
Zvakakosha kuziva kuti kune nzira dzakasiyana-siyana dzekuchengetedza kodhi yako yeVBA, asi hadzisi dzese dzinochengetedza kodhi yako nenzira imwechete. Zviri kwauri uye zvaunofunga kuti zvakakunakira.
#1 Chengetedza Kodhi yeVBA yePassword mukati meExcel Uchishandisa VBAProject Tool
Chikamu chino chinotsanangura mashandisiro aungaita marongero ekudzivirira mapurojekiti eVBA kuchengetedza kodhi yako yeVBA kubva kumeso ekutsvinyirwa uye kukanganiswa kwemaoko pane imwe nhanho.
- Chengetedzo: Isina kusimba; Kune zvishandiso zvakaita se VBA Password Remover iyo inogona kushandiswa kuvhura password mumaminitsi mashoma;
- Dambudziko: Nyore;
- Mutengo: Mahara;
Danho rekutanga. Sarudza "Visual Basic" kubva kumenyu ye "Developer" muExcel.
Danho rechipiri. Kuti uvhare purojekiti yako yeVBA, tinya "Zvishandiso" mubhawa wobva wasarudza "VBAProject Properties".
Mushure mekudzvanya pane chinhu ichi chemenyu, unofanira kuona bhokisi rehurukuro rinotevera:
Tabhu rekuti “General” rinosarudzwa nehurongwa hwekutanga, asi tinya pane tab rekuti “Protection”.
Danho rechitatu. Sarudza "Kiya purojekiti yekuona" wobva wanyora password yako kaviri mumabhokisi ese ari maviri wodzvanya "Zvakanaka".
Danho rechina. Chengetedza wovhurazve faira reExcel. Uchakwanisa kuona kana kuchengetedzwa kwepassword yeVBA kwakagoneswa nemazvo nekudzvanya kaviri purojekiti yako yeVBA. Kana ukachengetedza purojekiti yako yeVBA nepassword, zvinodzivirira chero munhu kuti asaigadzirise netsaona.
#2 Shandisa VBA Obfuscation Kudzivirira Macro Code Yako
VBA obfuscation hunyanzvi hwekuita kuti kodhi yako yeVBA isaverengeke asi ichiri kushanda. Inoshandura macros ako aripo nemazinga akasiyana-siyana ebfuscation izvo zvinoita kuti zviome kunzwisisa pfungwa dziripo. Advanced VBA obfuscators inoshandisa nzira dzakasiyana-siyana dzebfuscation, zvichiita kuti kuteverwa kwereverse nekudzoka kuve kwakaoma zvikuru.
- Chengetedzo: Pakati nepakati; Mumwe munhu acharamba achikwanisa kutora nguva uye kushandisa zviwanikwa zvakakwana kuti adzore kodhi yacho;
- Dambudziko: Pakati nepakati; Zvichienderana nedanho;
- Mutengo: VBA Obfuscator Yemahara /Premium;
Unogona kushandisa VBA obfuscation pamwe chete nenzira ye #1, iyo yekutanga kuvhara module wobva waisa password. Ndapota yeuka kuti obfuscation haidzoreki, saka chengetedza faira rekutanga usati waenderera mberi. Yeukawo kuti kodhi yakavharika haigone kuvimbiswa kuti ichaitwa pasina zvikanganiso. Ndapota iedze zvakanaka usati waiburitsa. Shandisa chikamu chimwe chete cheprojekiti kuti uvhare. Mushure mekunge bvunzo yekutanga ye obfuscation yabudirira, enda kune yechipiri.
#3 Shandura VBA Code kuita Dynamic-Link Library (DLL)
Makomputa akadai seVisual C++ neVisual Basic anogadzira maapplication akaoma kuvhura. Izvi zvinokonzerwa nekuti kodhi yacho inounganidzwa kuita mafaira anogoneka kana mafaira e library library ane dynamic link. Saka tinogonawo kuunganidza kodhi yeVBA kuita faira re library library rine dynamic link tozoishandisa muExcel.
- Chengetedzo: Yakakwirira;
- Dambudziko: Pakati nepakati;
- Mutengo: Mahara;
Nzira iyi yekudzivirira inokurudzirwa zvikuru, asi haina vimbiso yakakwana. Kuti udzidze maitiro ekuunganidza, ona mirairo iri paVbaCompiler.com: Matanho gumi ekuunganidza kodhi yeVBA muWindows DLL yemuno .
#4 Shandura VBA kuita C kana C++
Kushandura macros ako kuita C kana C++ kwakaoma kuashandura kuita mainjiniya kupfuura VBA. Kana uchida kuchengetedza kodhi yako, iyi ndiyo nzira yakanakisisa.
- Chengetedzo: Yepamusoro-soro; Hazvigoneki kuwana kodhi yacho usina kodzero; Asi zvakare, haina vimbiso yakakwana;
- Dambudziko: Rakaoma uye rinotora nguva; Nekuti VBA neC/C++ mitauro yakasiyana, zvinonetsa zvikuru sezvo uchifanira kushanda nesimba.
Mhedziso
Kushandisa macros inzira yakanaka yekuvandudza mashandiro epamusoro. Zvinosuwisa kuti izvi zvinoisa kodhi yako panjodzi yekubiwa kana kukopwa nevamwe. Chinyorwa chinokurukura nzira dzaungashandisa kudzivirira vamwe vashandisi kuti vasaba kana kukanganisa kodhi yako yeVBA. Ndapota cherechedza kuti dziviriro dzekodhi yeVBA hadzina dziviriro, asi dzinopa dziviriro kubva kune vanorwisa vasingatarisirwi.
