Zvinokwanisika here kupinda muchirongwa changu cheExcel VBA kana kodhi yacho yakachengetedzwa nepassword yakarasika kana yakanganwika? Uye kana zvakadaro, izvi zvingaitwa sei? Mhinduro ndeyekuti hongu. Kupwanya password yeExcel VBA hakusi basa rakaoma kana uine maturusi akakodzera. Kutaura zvazviri, kana wangova nechishandiso chakakodzera uye nzira dzakakodzera, zvinogona kuva nyore kupwanya kunyange mapassword akaomarara.
Muchinyorwa chino, tichakuratidza maitiro ekushandisa mapassword eVBA uchishandisa nzira shoma dziri nyore. Asi ngatitangei tatarisa kuti password yeVBA chii muExcel.
VBA Password—Inoshanda Sei?
VBA (Visual Basic for Applications) mutauro wepurogiramu unoshandiswa kugadzira mapurogiramu eMicrosoft Office akadai se Excel uye Kupinda ine simba rakawanda uye iri nyore kushandisa. VBA inoshandiswawo kugadzira mapurogiramu akagadzirirwa iwe pachako.
A Chirongwa cheVBA chinogona kuchengetedzwa nepassword kudzivirira kupinda pasina mvumo. Paunovhura purojekiti yeVBA muExcel spreadsheet, unogona kukumbirwa kuisa password (semufananidzo uri pazasi). Kana ukasaisa password chaiyo, hauzokwanisi kuona kana kugadzirisa kodhi yeVBA.
Maitiro Ekuvhura Password yeExcel VBA
Kune nzira dzakasiyana siyana dzinogona kushandiswa kuvhura password yeExcel VBA. Tichaongorora imwe neimwe yenzira idzi zvakadzama pazasi.
Nzira 1: Kushandisa VBA Password Reset a
"VBA Password Reset a" iplugin ine simba yeExcel yekudzoreredza password inogona kukurumidza kudzosera password ku "a" kubva kumapurojekiti mazhinji eVBA. Chishandiso ichi chinoshanda neExcel 2007 zvichikwira pakombuta yeWindows, pamwe neExcel 2016 zvichikwira paMac.
Excel VBA Password Reset a Kana yaiswa uye yagoneswa, inogona kuwanikwa kubva paribhoni yeExcel. Zvinotora matanho maviri chete kubvisa password ye macro muExcel.
Danho rekutanga. Vhura faira rebhuku rebasa rine password prompt—tinya pa “Reset VBA password – a”.
Danho rechipiri. Sarudza sarudzo yekugadzirisa password zvakare—pano tinogona kusarudza “Unprotect all sheets in active workbook” kubva pamenyu.
Uchapihwa kopi yefaira rako reExcel panzvimbo imwe chete nepayakagadzirwa pakutanga uye nepassword ye "a" VBA.
Nzira 2: Kushandisa SysTools VBA Password Remover
SysTools yakaunza application yeWindows inonzi “SysTools VBA Password Remover” yeExcel 97 nedzimwe shanduro dzichazotevera. Chirongwa ichi chichavhura mapassword eVBA mumabhuku ebasa eExcel zviri nyore pasina ruzivo rwehunyanzvi runodiwa.
Danho rekutanga. Dzvanya bhatani riri pazasi wobva wadhawunirodha chirongwa ichi.
Danho rechipiri. Kana watanga chirongwa ichi, uchaona peji rine musoro unoti “Tarisa Zvinodiwa”, patinofanira kudzvanya “Zvakanaka” kuti tienderere mberi.
Danho rechitatu. Sarudza bhuku rebasa reExcel rine zvinyorwa zvakavharidzirwa uchishandisa bhatani rekuti “Wedzera Mafaira”. Wobva wadzvanya “Reset” kuti uvhure makodhi aro ese eVBA.
Danho rechina. Iye zvino unogona kuona kuti password itsva yaiswa pafaira iri uye mamiriro acho anoti "Pass", zvinoreva kuti iyi ndiyo password yekupinda muchirongwa chako cheVBA.
Nzira 3: Chinja Extension + Hex Editor
Kuti tigadzirise kana kubvisa password kubva mubhuku rebasa reExcel tichishandisa Hex Editor, tinofanira kutanga tachengeta faira rakachengetedzwa nepassword yeVBA. Kana wachengeta faira racho, tevera matanho aya:
Danho rekutanga. Chinja extension yefaira reExcel kubva pa "xlsm" kuenda pa "zip". Izvi zvichaita kuti faira riite serinenge rakachengetedzwa neZIP.
Kune vanhu vazhinji, bhokisi rekuti “Viga ma extensions emhando dzemafaira anozivikanwa” muFolder Options rinotariswa nekutanga. Kubvisa chiratidzo mubhokisi iri kuchaita kuti ma extensions aonekwe muFile Explorer.
Danho rechipiri. Bvisa faira reZIP uchishandisa chishandiso chakaita seWinZip kana 7-Zip.
Danho rechitatu. Vhura forodha risina zipu. Mukati meforodha iyi mune forodha diki rekuti "xl" kwaunogona kuwana faira rekuti "vbaProject.bin".
Danho rechina. Vhura faira re "vbaProject.bin" nehex editor yakaita se HxD .
Danho rechishanu. Tsvaga "DPB" mukati mefaira.
Danho rechitanhatu. Chinja "DPB" kuita "DPx". Chengetedza shanduko wobva wabuda.
“B” chete ndiyo inofanira kuchinjwa kuita “x”, uye usabvisa chiratidzo chakaenzana nekutadza.
Danho rechinomwe. Dzvinya mafolda ese nemafaira kuita ZIP.
Danho rechisere. Chinja extension kubva pa "zip" kuenda pa "xlsm", wobva waivhura.
Danho rechipfumbamwe. Zvakanaka, saka uri mufaira re xlsm. Chinhu chekutanga chingangoitika ndechekuti zvikanganiso zvakawanda zvinobuda asi usazvinetse: ingodzvanya "Hongu" kuti uzvibvise.
Vhura VB editor nekudzvanya "Developer" wobva wadzvanya "Visual Basic". Wobva wadzvanya pasi pe "Tools" > "VBAProject Properties", bvisa cheki ye "Lock project for viewing".
Danho rechigumi. Vhara mupepeti wochengeta faira reExcel. Zvinogoneka kuti richakuzivisa kuti uchengetedze pane imwe nzvimbo sefaira idzva.
Danho rechi11. Vhura faira idzva. Kodhi yako yeVBA ichaonekwa pasina chikonzero chekuisa password!
*Taedza nzira iyi pafaira reExcel 2007.
Mhedziso
VBA Password yakashandiswa nevakawanda vanogadzira mapurogiramu emakombiyuta kuitira kuchengetedza kodhi yavo kuti isaonekwe kana kugadziriswa nevamwe vanhu vanozoishandisa zvisirizvo. Iyi inzira yakanaka muzviitiko zvakawanda, asi kana ukakanganwa password yako yeExcel VBA wobva wada kuona kodhi yako yepurojekiti, nzira dziri pamusoro dzichakubatsira.
Muchinyorwa chino takurukura nzira nhatu dzaungawana nadzo mukana wekushandisa VBA project yako pasina chikonzero chepassword. Kana uchida kushandisa chishandiso chekuwedzera kana kudhawunirodha a chirongwa chekubvisa password kubva kuSysTools , hazvitore nguva yakareba faira rako risati ravhurwa uye rava kuwanikwa kuti rigadziriswe zvakare.
