An Excel project Visual Basic for Applications (VBA) mutauro wepurogiramu unoshandiswa mukati meExcel kugadzira zvirongwa zviri nyore. Inowanzo shandiswa kushandura mabasa akaomarara kana anopedza nguva kuita otomatiki, maitiro ekuchengetedza nguva, zvichizovandudza kunaka kwemaitiro ekubika. Aya mapurojekiti eVBA, zvisinei, dzimwe nguva anogona kuchengetedzwa password, kuchengetedza zvakavanzika zvako kana kudzivirira chero kutyorwa kweiyo yekutanga kushanda script. Nekuda kweizvozvo, dzimwe nguva zvinogona kunetsa kurangarira mapassword aya, kungave nekuti vashandisi vakanganwa kana kurasikirwa pasiwedhi kana nekuda kwezvimwe zvikonzero zvakasiyana. Naizvozvo, chinyorwa ichi chinosimbisa nzira dzakasiyana siyana dzinogona kushandiswa kubvisa password kubva kuExcel VBA chirongwa.
Pane mhando mbiri dzemakesi dzaungasangana nazvo paunenge uchiedza kubvisa mapassword kubva kuExcel VBA mapurojekiti. Tichataura pamusoro pezvinhu zviviri nhanho nhanho.
Chikamu 1: Bvisa Excel VBA Project Password Pasina Kuziva Password
Kuti uite izvi, unogona kutora nzira dzinoverengeka, nhatu dzadzo dzinotevera:
Bvisa Excel VBA Project Password mune Imwe Dzvanya yeXLS/XLSM Mafaira
Pane akawanda mapurogiramu pamusika anogona kukubatsira kubvisa mapassword kubva kuExcel VBA chirongwa. Muenzaniso wakanaka ndeuyu Passper yeExcel , iyo iri nyore uye inoshanda mhinduro yekubvisa ipapo ipapo ese editing uye fomati dziviriro dzakavakwa mukati mebepa rebasa / bhuku rebasa neVBA kodhi.
Zvimwe zvezvinhu zvikuru zvePassper yeExcel ndezvi:
- VBA purojekiti password mune yako Excel workbook inogona kubviswa nekudzvanya kuri nyore .
- Guarantee a 100% kubudirira kwehuwandu .
- Chikwata chePasi chine hanya nacho kuchengetedzwa kwe yavo data . Pachave pasina kurasikirwa kwedata kana kuvuza panguva / mushure mekubvisa maitiro.
- Chirongwa chine a kugarisana kwakakura . Inotsigira .xls, .xlsx, .xlsm, .xlsb, .xltx, .xltm nemamwe mafaira akagadzirwa neMicrosoft Excel.
Kuratidza kuti zviri nyore sei kushandisa Passper yeExcel, isu takagadzirira gwara rakadzama rako. Chekutanga, iwe unofanirwa kudhawunirodha chirongwa uye kuchiisa pakombuta yako.
Danho 1. Kamwe yakaiswa, unofanira kusarudza "Bvisa zvinorambidzwa" kuita.
Danho 2. Shandisa bhatani re "Sarudza faira" kuisa password-yakachengetedzwa Excel faira. Kana iyo faira yawedzerwa kune software, ingo dzvanya pane "Delete" sarudzo yekubvisa password yekudzivirira kubva kune yako Excel sheet.
Danho 3. Mukati memasekondi, password yeprojekti yeVBA ichabviswa kubva mubhuku rako rekushanda reExcel.
Passper yeExcel Icho chirongwa chine simba uye chakavimbika. Yakagamuchira ongororo dzakanaka kubva kuvashandisi. Usazeza kuishandisa.
Bvisa Excel VBA Project Password Online
Imwe nzira yekubvisa VBA purojekiti password mune yako Excel zvinyorwa ndeye kushandisa online sevhisi inowanikwa pawebhu. Muenzaniso wakanaka werudzi urwu rwekushandisa online Hofisi VBA Password Remover. Ichi chishandiso chepamhepo chinokubatsira kubvisa dziviriro yako, asi inoda matanho akati wandei. Iyo nzira ndiyo inotevera:
Danho 1: Dzvanya "Vhura Faira" kuti uise yako VBA purojekiti password-yakachengetedzwa Excel faira.
Danho rechipiri: Dzvanya "Decrypt VBA" kuti usimbise kurodha kwegwaro idzva.
Danho rechitatu: Kana wadhaunirodha, vhura gwaro racho. Ichakuyeuchidza kuti chirongwa chine kiyi isingaite. Dzvanya "Hongu" kuti uenderere mberi.
Danho 4: Dzvanya ALT+F11 kuti uvhure VBA chirongwa. Mukati meiyo macro hwindo, haufanirwe kuwedzera purojekiti. Tevere, enda kuZvishandiso> VBA Project Properties.
Danho rechishanu: Enda kune Dziviriro tab, isa password nyowani yesarudzo yako uye siya bhokisi rekutarisa rakasarudzwa.
Danho rechitanhatu: Sevha gwaro uye uvhare VBA chirongwa.
Danho rechinomwe: Vhura bhuku rako rekushanda reExcel zvakare uye dzokorora nhanho 4.
Nhanho 8: Panguva ino iwe unofanirwa kujekesa bhokisi rekutarisa uye password minda mu "Protection" tab.
Nhanho 9: Sevha gwaro zvakare. Pasiwedhi rabviswa.
Cons yenzira iyi:
- Kuisa yako Excel faira kunotora nguva. Zvakare, hapana bhara rekugadzirisa, saka haugone kutaura kana faira rako raiswa kana kuti kwete.
- Kuisa yako Excel faira kuwebhusaiti yavo hakuna kuchengetedzeka kune yako data, kunyanya kana data rako riine hanya.
Bvisa password kubva kuExcel VBA Project Uchishandisa HEX Mharidzo
Iyo hex mupepeti inogona kuve chishandiso chinobatsira kana iwe uchida kubvisa nemaoko mapassword kubva kune yako Excel VBA chirongwa. Pane nzira mbiri dzakasiyana dzinodiwa kubvisa mapassword zvichienderana neExcel file type yekuwedzera. Usati watanga maitiro ekunyora, gara uchiyeuka kuita backup yemafaira eExcel auri kushanda nawo.
Kana iyo faira iri XLS:
Danho 1: Vhura iyo password-protected .xls faira ine hex editor uye tsvaga tambo "DPB."
Danho rechipiri: Chinja "DPB" ne "DPX".
Danho rechitatu: Sevha faira uye buda mupepeti.
Danho 4: Zvadaro, vhura faira neMicrosoft Excel. Zviziviso zvezvikanganiso zvakawanda zvichaonekwa, zvinova zvakajairika. Iva nechokwadi chekudzvanya pazviri.
Danho rechishanu: Zvino dzvanya ALT+F11 kuti uvhure VBA purojekiti hwindo uye tinya VBAProject zvivakwa kubva kuZvishandiso menyu.
Danho rechitanhatu: Pane Dziviriro tab, shandura password kune chimwe chinhu chiri nyore uye chiri nyore kurangarira.
Danho rechinomwe: Chengetedza bhuku rekushanda uye buda pahwindo.
Nhanho 8: Vhurazve bhuku rebasa reExcel uye uwane iyo VBA purojekiti hwindo nekudzvanya ALT+F11 nekuisa password yauchangobva kuchinja. Dzokorora nhanho yechitanhatu, asi panguva ino unogona kubvisa password.
Nhanho 9: Sevha bhuku rebasa uye wave neExcel faira isina password.
Kana iyo faira iri XLSM:
Pakuwedzera kwe .xlsm, imwe nhanho inodiwa pakutanga. Pazasi tinokupa iwe nhanho-nhanho gwara.
Danho 1: Chinja kuwedzera kwefaira rako re.xlsm kuita .zip. Wobva wavhura ne7Zip kana WinZip.
Danho rechipiri: Tsvaga uye kopa "xl/vbaProject.bas" kana "xl/vbaProject.bin" faira kubva pazip file. Ita shuwa kuti zip folda ichiri yakavhurika.
Danho rechitatu: Dzvanya uye vhura iyo "xl/vbaProject.bas" kana "xl/vbaProject.bin" faira uchishandisa hex editor.
Danho 4: Tsvaga tambo "DPB" woitsiva ne "DPX".
Danho rechishanu: Sevha iyo faira, uye ikopidze kuZip folda (unogona kudhonza nekudonhedza faira mufolda).
Danho rechitanhatu: Iye zvino, zip mafaera ese ari mufolda mune itsva Zip faira. Zvadaro, shandura faira rekuwedzera ku .xlsm.
Danho rechinomwe: Zvadaro, vhura .xlsm faira. Zviziviso zvakasiyana siyana zvichaonekwa. Dzvanya "Hongu" kuti uenderere mberi.
Nhanho 8: Dzvanya ALT+F11 kuti uvhure VBA chirongwa uye tinya VBAProject Properties paZvishandiso menyu.
Nhanho 9: Vhura iyo Dziviriro tebhu, uncheck "Kiya purojekiti yekuona" uye tinya OK.
Nhanho 10: Sevha .xlsm faira uye vhara hwindo
Cons yenzira iyi:
- Kune akawanda hex edhita pane webhusaiti. Kusarudza yakanaka ibasa rakaoma kana iwe usina ruzivo rwehunyanzvi.
- Vamwe vashandisi vakashuma kuti havagone kurodha hexadecimal mupepeti. Nokudaro, nzira iyi haisi nguva dzose inobatsira iwe.
Chikamu 2: Bvisa Excel VBA Project Password ine Inozivikanwa Password
Nyaya iyi iri nyore kuita uye yakafanana nehurukuro yedu yapfuura. Kuti zvive nyore kunzwisisa, maitiro anotsanangurwa pazasi:
Danho 1: Vhura bhuku rako rekushanda reExcel neMicrosoft Excel. Dzvanya Alt+F11 kuti uwane iyo VBA chirongwa.
Danho rechipiri: Enda kune Zvishandiso> VBAProject Properties. Isa password chaiyo muVBAProject Password dialog box.
Danho rechitatu: Enda kune Dziviriro tab, usatarise "Kiya purojekiti yekuona" uye dzora password mumabhokisi anotevera.
Danho 4: Dzvanya "OK" uye chengetedza kushanda. Ndizvo zvose.
Mhedziso
Inogona kunge iri basa rinotyisa kubvisa VBA purojekiti password kubva kuExcel mafaera. Zvinogara zvichikurudzirwa kushandisa sarudzo inoshanda uye iri nyore-kushandisa paunenge uchibata nemhando idzi dzemafaira. Izvi zvinochengetedza nguva yakawanda uye ndiyo yakanyanya kunaka. Edza ikozvino Passper yeExcel uye uchafadzwa zvikuru.
