Maitiro ekubvisa password kubva kuExcel VBA Project [4 Nzira]

Ini ndoda kuziva nzira yekubvisa password kubva kuVBA chirongwa muExcel. Ndiani angandibatsira?

Usati watombotsvaga nzira dzekubvisa VBA password muExcel, unofanirwa kunzwisisa zvinoreva VBA. VBA ichidimbu cheVisual Basic for Applications. Inoshandiswa neakasiyana siyana eMS zvikumbiro, kunyanya MS Excel, kuwedzera mamwe maficha uye zvakare kubatsira mukuita otomatiki mabasa. Nekuda kwehunhu hwavo uye kuda kwekuchengetedza faira, vashandisi vazhinji vanovhara mapurojekiti eVBA nemapassword. Zvisinei, vanhu havana kukwana uye VBA passwords inogona kukanganwika. Chirevo chiri pachena ndechekuti haugone kuwana kana kugadzirisa yako Excel VBA macode. Kuti urove mhirizhonga iyi, unoda nzira yekupwanya password yeExcel VBA. Sezvineiwo, kune nzira dzakawanda dzekuita basa iri. Muchikamu chino, iwe uchagamuchira yakadzama gwara pamusoro 4 nzira dzekutsemura mapassword eExcel VBA.

Chikamu 1: Maitiro ekubvisa VBA Project Password muExcel Pasina Zvirongwa

Kuvhura chirongwa cheVBA muExcel chinogona kuitwa nerubatsiro rweotomatiki VBA decryption software kana nemanyorero. Kuongorora maitiro ekutsemura Excel VBA password nemaoko, kune akati wandei nzira dzakanaka dzinokwanisa kuita kuti basa riitwe. Unogona kusarudza kubva pane idzi sarudzo uye edza neako akachengetedzwa Excel faira. Pakupedzisira, imwe yeiyi sarudzo inogona kunge iri nani, zvichienderana nerudzi rwegwaro rako rakachengetedzwa uye kudiwa kuri pedyo. Usati watora mukana weidzi nzira dzemanyorero, unofanirwa kutsigira mafaera ako eExcel.

Nzira 1. Shandura faira yekuwedzera kuti uzarure Excel VBA module

Iyi nzira inosanganisira kushandura .xlsm faira rekuwedzera kune imwe fomati uye wodzokera ku .xlsm fomati mushure. Kunyangwe maitiro acho akareba, unogona kuitevera nekungwarira kuti ubvise password yako yeExcel VBA pakupedzisira. Matanho anotevera anoratidza maitiro aungaita iyo Excel VBA purojekiti password nekungochinja iyo faira rekuwedzera.

Danho 1 : Tsvaga chinangwa .xlsm faira uye shandura .xlsm faira rekuwedzera kune zip.

Danho rechipiri : Zvino vhura iyi faira kuburikidza nechero yeArchiver zvirongwa zvaunazvo. Unogona kushandisa WinRAR kana 7-Zip. Kana iwe ukaita izvi, iwe unofanirwa kukwanisa kuona inotevera chimiro chefaira rako redhairekitori.

Danho rechitatu : Enda kune XL directory sarudzo uye bvisa faira yakanyorwa "VBAProject.bin".

Danho rechina : Vhura iyo VBAProject.bin faira kuburikidza nechero hex mupepeti uye tarisa mameseji "DPB=" mukati mefaira mune hex mupepeti.

Danho rechishanu : Kana wangowana chinyorwa ichi, chingochidzima wochitsiva ne“DPX="” panzvimbo. Iye zvino chengetedza uye vhara faira rako muhex mupepeti. Inonyora VBAProject.bin yekare neiyo hex-yakagadziriswa VBAProject.bin.

Danho rechitanhatu : Dzosera faira rekuwedzera ku .xlsm wozoivhura muExcel. Mune yambiro pop-up hwindo, sarudza "Hongu" uye usateerere dzimwe sarudzo.

Danho rechinomwe : Mhanya iyo VBA mupepeti uye sarudza "Zvakanaka" kana bhokisi rebhokisi richioneka.

Nhanho yechisere : Tinya-kurudyi zita reVBA chirongwa chako wobva wasarudza zvivakwa. Sarudza iyo "Kudzivirira" tab uye bvisa mapassword aripo. Zvakare, dzima iyo "Lock Project yeKuona" cheki bhokisi uye woigonesa zvakare. Isa password yakakodzera uye isimbise. Dzvanya "OK" kuita shanduko.

Nzira 2. Bvisa Excel VBA Project Password neHex Editor

Hex Mharidzo inokupa yakanaka chikuva chekugadzirisa zvigadzirwa zvehex uye pakupedzisira kupaza password yeExcel VBA. Nenzira iyi, iwe uchagadzira dummy xls faira, isa password, uye uishandise kuwana iyo yakachengetedzwa Excel.

Danho 1 : Shandisa iyo Hex mupepeti kugadzira faira idzva reExcel (xls). Ingori nyore faira inogona kuzviita.

Danho rechipiri : Gadzira password yefaira iyi muchikamu cheVBA. Unogona kudzvanya Alt+F11 kuti uwane iyi sarudzo.

Danho rechitatu : Mushure mekugadzira iri nyore-kuyeuka-password, chengetedza iyi faira nyowani uye buda.

Danho rechina : Vhura iyi faira ichangobva kugadzirwa, asi panguva ino, vhura iyo kuburikidza nehex mupepeti. Kana yangovhurwa, tsvaga nekukopa mitsetse, inotanga nemakiyi anotevera: CMG=, DPB= uye GC=.

Danho rechishanu : Zvino vhura iyo Excel faira yauri kuda kupaza password neHex mupepeti. Namira zvinyorwa zvakakopwa mundima dzakateerana uye chengetedza shanduko. Buda mufaira.

Danho rechitanhatu : Kazhinji vhura iyo Excel faira uye shandisa iyo password password yawakagadzira iyo dummy xls faira kuti uone iyo VBA kodhi.

Nzira 3. Bvisa password kubva kuExcel VBA project ine Visual Basic Editor

Kusiyana neiyo Hex mupepeti, iyo Visual Basic Mharidzo inobvumira vashandisi kugadzirisa makodhi makodhi panzvimbo peiyo hexadecimal. Nzira yacho haina kureba kudaro. Nekudaro, iwe unofanirwa kungwarira nekuti macode anoda kutariswa kudzivirira zvikanganiso. Matanho anotevera anoratidza zvakajeka maitiro aungaita password yeExcel Macro ine Visual Basic Mharidzo.

Danho 1 : Vhura nemaoko iro bhuku rekushanda rine pepa rakachengetedzwa reExcel.

Danho rechipiri : Zvino vhura iyo Visual Basic Mharidzo uchishandisa iyo Alt+F11 kuraira. Enda kuEmbed Module uye wozoisa iyo inotevera kodhi muhwindo rekodhi rinowanikwa kurudyi.

Danho rechitatu : Buda pahwindo reVBA Edhinda uye enderera nebepa rebasa rakachengetedzwa.

Danho rechina : Enda kune Zvishandiso> Macro> Macros. Mune rondedzero inoonekwa, tinya kaviri pane "PasswordBreaker" sarudzo. Iwe unofanirwa ikozvino kukwanisa kuwana yako password-yakachengetedzwa Excel faira.

Chikamu 2: Manually zvipimo paunenge uchivhura VBA chirongwa muExcel

Kunyangwe nzira dzemanyorero dzichibatsira pakupwanya mapassword eExcel VBA, hapana pese padhuze nekukwana. Idzi nzira dzinotambudzwa nematambudziko akawanda anoita kuti ive isina kukwana kana zvasvika kune yakakosha uye yakaoma Excel mafaera. Zvinotevera ndezvimwe zvipimo zvakajairika zvemanyorerwo maitiro.

• Inoda ruzivo rwehunyanzvi : Sezvawaona, mazhinji epamusoro sarudzo anosanganisira yakawanda kodhi. Saka kana uine ruzivo rushoma rwehunyanzvi, iwe uchave nenguva yakaoma neaya manyorerwo sarudzo.
• Zvinotora nguva yakawanda : Nzira dzakawanda dzemaoko dzinosanganisira maitiro akareba. Icho chokwadi chekuti inosanganisirawo makodhi uye kufamba kune akawanda mapuratifomu inoita kuti iwedzere kunetesa uye saka vashandisi vanoiwana ichinonoka uye ichinetesa.
• Chiyero chekubudirira : Chii chakakosha, mukupedzisira, ndechekuti isu tinogona kutsemura iyo Excel VBA password kana kwete. Nehurombo, idzi sarudzo dzemanyorero dzinorekodha mitengo yebudiriro yakaderera. Naizvozvo, hazvikurudzirwe kushandisa nguva yakawanda nesimba uye wozotadza kuwana mhedzisiro yaunoda.

Izvo zvakati, kana sarudzo dzese dzikatadza kana kuti iwe waneta nekukanganisa kwavo, gare gare edza kushandisa yakakosha maapplication sePasser yeExcel kutsemura Excel VBA password otomatiki.

Chikamu 3: Nzira yekutsenga Excel VBA Password Automatically

Passper yeExcel chinhu chinoshamisa chine simba rekuvhura password yeExcel mafaera. Iyo purogiramu inovimbisa 100% chiyero chekubudirira kupaza iyo Excel VBA purojekiti password. Neyepamusoro-soro kukurumidza decryption kumhanya uye nyore kushandisa, hapana chikonzero chekukahadzika kugona kwePassper yeExcel. Izvo zvakakoshawo kuziva kuti Passper yeExcel inogona kushandiswa kutsemura gwaro rekuvhura password yeExcel mafaera.

Mamiriro akakosha ePasser yeExcel:

• Zvese zvekugadzirisa uye zvirambidzo muchirongwa chako cheVBA, pepa rebasa, kana bhuku rebasa zvinogona kutsanangurwa ipapo ipapo.
• NePasser yeExcel, kudzvanya kuri nyore kuchakubvumidza kuti ubvise kuchengetedzwa kwepassword pane yako VBA chirongwa.
• Yako data haizokanganiswe kana kukuvadzwa mushure mekushandisa chirongwa.
• Iyo purogiramu ine kuenderana kwakakura kwazvo. Mafaira ese eExcel marudzi anosanganisira .xlsm, .xlsb, .xltx, .xltm anowirirana nayo.

Passper yeExcel yakashandira mamirioni evashandisi pasi rese. Uye yakagamuchira ongororo yakanaka kubva kuvashandisi vayo. Usazeze kuzviedza ikozvino.

Edza mahara

Maitiro ekubvisa password yeVBA muExcel nePasser yeExcel

Danho 1: Tanga Passper yeExcel paPC yako uye tinya pane "Bvisa Zvirambidzo" sarudzo.

Danho rechipiri: Muhwindo idzva, tinya bhatani rekuti "Sarudza Faira" uye uteedzere mirairo iri pa-screen kuti uise password-yakachengetedzwa Excel VBA faira kune chirongwa chechirongwa.

Danho rechitatu: Kana password yakachengetedzwa faira yaiswa, tinya iyo "Delete" sarudzo yekubvisa VBA purojekiti password muExcel faira rako.

Iyo purogiramu ichabvisa otomatiki zvirambidzo mukati memasekondi. Kana yapedza, iwe unofanirwa kuona iyo yekubudirira ziviso pazasi pechidzitiro.

Mhedziso

Gwaro iri rakatsanangura zvakajeka dzimwe dzenzira dzinonzwisisika dzekutsemura mapassword eExcel VBA. Zvisinei, mamwe mafomu akakwirira kudarika mamwe nekuda kwekugona kwavo kubata mapassword eVBA akaoma, nyore kushandisa, uye kubudiswa kwekubudirira kwehuwandu. Kubva pahuwandu hweruzivo rwakapihwa pamusoro apa, hapana anogona kupokana Passper yeExcel semhinduro chaiyo yekupwanya Excel VBA purojekiti password. Yese zviyero zvekuyera zvinoisa pamberi pezvisarudzo zvemaoko. Sarudza Passer yeExcel uye gadzirisa matambudziko ako eVBA password zvachose.

Edza mahara