Pulojekiti ya Excel Visual Basic for Applications (VBA) ndi chilankhulo chogwiritsa ntchito mkati mwa Excel kupanga mapulogalamu osavuta. Nthawi zambiri amagwiritsidwa ntchito kusandutsa ntchito zovuta kapena zowononga nthawi kukhala njira zodzichitira zokha, zopulumutsa nthawi, ndikuwongolera njira yoperekera malipoti. Mapulojekiti a VBA awa, komabe, nthawi zina amatha kutetezedwa mawu achinsinsi, kuteteza zinsinsi zanu kapena kupewa kuphwanya chilichonse cholembedwa choyambirira. Chifukwa chake, nthawi zina zimakhala zovuta kukumbukira mawu achinsinsiwa, mwina chifukwa ogwiritsa ntchito ayiwala kapena ataya mawu achinsinsi kapena pazifukwa zina zosiyanasiyana. Chifukwa chake, nkhaniyi iwunikira njira zingapo zosavuta zomwe zingagwiritsidwe ntchito kuchotsa mawu achinsinsi ku projekiti ya Excel VBA.
Pali mitundu iwiri yamilandu yomwe mungakumane nayo mukafuna kuchotsa mawu achinsinsi pama projekiti a Excel VBA. Tikambirana za zinthu zonsezi sitepe ndi sitepe.
Gawo 1: Chotsani Kupambana VBA Project Achinsinsi Popanda Kudziwa Achinsinsi
Kuti muchite izi, mutha kutenga njira zingapo, zitatu mwazo ndi izi:
Chotsani Excel VBA Project Password mu Dinani Kumodzi kwa Mafayilo a XLS/XLSM
Pali mapulogalamu angapo pamsika omwe angakuthandizeni kuchotsa mawu achinsinsi ku projekiti ya Excel VBA. Chitsanzo chabwino ndi ichi Passper kwa Excel , yomwe ndi njira yosavuta komanso yothandiza kuti muchotse nthawi yomweyo zotetezedwa zonse zosintha ndi masanjidwe zomwe zimamangidwa mkati mwa pepala/buku logwirira ntchito ndi kachidindo ya VBA.
Zina mwazinthu zazikulu za Passper ya Excel ndi:
- Mawu achinsinsi a polojekiti ya VBA mu buku lanu la Excel akhoza kuchotsedwa ndikudina kosavuta .
- Chitsimikizo a 100% kupambana .
- Gulu la Passer limasamala chitetezo cha zawo deta . Sipadzakhala kutaya deta kapena kutayikira pa / pambuyo kuchotsa ndondomeko.
- Pulogalamuyi ili ndi a kuyanjana kwakukulu . Imathandizira .xls, .xlsx, .xlsm, .xlsb, .xltx, .xltm ndi mafayilo ena opangidwa ndi Microsoft Excel.
Kuti tiwonetse kusavuta kugwiritsa ntchito Passper ya Excel, takonzerani kalozera watsatanetsatane. Choyamba, muyenera kukopera pulogalamuyo ndi kukhazikitsa pa kompyuta.
Gawo 1. Kamodzi anaika, muyenera kusankha "Chotsani zoletsa" njira.
Gawo 2. Gwiritsani ntchito batani la "Sankhani fayilo" kuti mukweze fayilo ya Excel yotetezedwa ndi achinsinsi. Fayiloyo ikawonjezedwa ku pulogalamuyo, ingodinani pa "Chotsani" kuti muchotse chitetezo chachinsinsi pa pepala lanu la Excel.
Khwerero 3. M'masekondi pang'ono, mawu achinsinsi a projekiti ya VBA adzachotsedwa mu buku lanu la Excel.
Passper kwa Excel Ndi pulogalamu yamphamvu komanso yodalirika. Yalandira ndemanga zabwino kuchokera kwa ogwiritsa ntchito. Musazengereze kuzigwiritsa ntchito.
Chotsani Excel VBA Project Password Online
Njira ina yochotsera mawu achinsinsi a polojekiti ya VBA muzolemba zanu za Excel ndikugwiritsa ntchito intaneti yomwe ikupezeka pa intaneti. Chitsanzo chabwino cha chida chamtunduwu pa intaneti ndi Office VBA Password Remover. Chida ichi pa intaneti chimakuthandizani kuchotsa chitetezo chanu, koma chimafunikira njira zingapo. Ndondomekoyi ndi iyi:
Gawo 1: Dinani "Tsegulani Fayilo" kuti mukweze fayilo yanu yachinsinsi ya VBA yotetezedwa ndi Excel.
Gawo 2: Dinani "Decrypt VBA" kuti mutsimikizire kutsitsa kwa chikalata chatsopanocho.
Gawo 3: Mukatsitsa, tsegulani chikalatacho. Ikukumbutsani kuti polojekitiyi ili ndi kiyi yolakwika. Dinani "Inde" kuti mupitirize.
Gawo 4: Dinani ALT+F11 kuti mutsegule polojekiti ya VBA. Pazenera lalikulu, simuyenera kuwonjezera pulojekitiyi. Kenako, pitani ku Zida> VBA Project Properties.
Gawo 5: Pitani ku tabu ya Chitetezo, ikani mawu achinsinsi omwe mwasankha ndikusiya bokosi losankhidwa.
Gawo 6: Sungani chikalatacho ndikutseka polojekiti ya VBA.
Gawo 7: Tsegulani buku lanu lantchito la Excel kachiwiri ndikubwereza gawo 4.
Gawo 8: Nthawi ino muyenera kuchotsa cheke ndi mawu achinsinsi pa tabu "Chitetezo".
Gawo 9: Sungani chikalata kachiwiri. Mawu achinsinsi achotsedwa.
Kuipa kwa njira iyi:
- Kutsitsa fayilo yanu ya Excel kudzatenga nthawi. Komanso, palibe bar processing, kotero inu simungakhoze kudziwa ngati wapamwamba zidakwezedwa kapena ayi.
- Kuyika fayilo yanu ya Excel patsamba lawo sikuli kotetezeka ku data yanu, makamaka ngati deta yanu ili yovuta.
Chotsani Mawu Achinsinsi ku Excel VBA Project Pogwiritsa Ntchito HEX Editor
Mkonzi wa hex akhoza kukhala chida chothandiza ngati mukufuna kuchotsa pamanja mawu achinsinsi pa projekiti yanu ya Excel VBA. Pali njira ziwiri zosiyana zomwe zikufunika kuti muchotse mawu achinsinsi kutengera mtundu wa fayilo ya Excel. Musanayambe ndondomekoyi, nthawi zonse muzikumbukira kusunga mafayilo a Excel omwe mukugwira nawo ntchito.
Ngati mtundu wa fayilo ndi XLS:
Gawo 1: Tsegulani fayilo ya .xls yotetezedwa ndi mawu achinsinsi ndi hex editor ndikuyang'ana chingwe "DPB."
Gawo 2: Sinthani "DPB" ndi "DPX".
Gawo 3: Sungani fayilo ndikutuluka mkonzi.
Gawo 4: Kenako, tsegulani fayiloyo ndi Microsoft Excel. Zidziwitso zolakwika zingapo zidzawonekera, zomwe ndizabwinobwino. Onetsetsani kuti alemba pa iwo.
Gawo 5: Tsopano dinani ALT+F11 kuti mutsegule zenera la polojekiti ya VBA ndikudina VBAProject katundu kuchokera ku Zida menyu.
Gawo 6: Patsamba la Chitetezo, sinthani mawu achinsinsi kukhala chinthu chosavuta komanso chosavuta kukumbukira.
Gawo 7: Sungani bukhu la ntchito ndikutuluka pawindo.
Gawo 8: Tsegulaninso buku lantchito la Excel ndikupeza zenera la polojekiti ya VBA pokanikiza ALT+F11 ndikulowetsa mawu achinsinsi omwe mwasintha kumene. Bwerezani sitepe 6, koma nthawi ino mutha kuchotsa mawu achinsinsi.
Gawo 9: Sungani bukuli ndipo tsopano muli ndi fayilo ya Excel yopanda mawu achinsinsi.
Ngati mtundu wa fayilo ndi XLSM:
Pazowonjezera za .xlsm, sitepe yowonjezera ikufunika poyambira. Pansipa tikukupatsirani kalozera watsatane-tsatane.
Gawo 1: Sinthani kuwonjezera kwa fayilo yanu ya .xlsm kukhala .zip. Kenako tsegulani ndi 7Zip kapena WinZip.
Gawo 2: Pezani ndi kukopera "xl/vbaProject.bas" kapena "xl/vbaProject.bin" wapamwamba kuchokera pa zip file. Onetsetsani kuti zip foda ikadali yotseguka.
Gawo 3: Dinani ndi kutsegula fayilo ya "xl/vbaProject.bas" kapena "xl/vbaProject.bin" pogwiritsa ntchito hex editor.
Gawo 4: Pezani chingwe "DPB" ndikusintha "DPX".
Gawo 5: Sungani fayiloyo, ndikuyikoperanso ku chikwatu cha Zip (mutha kukoka ndikuponya fayiloyo mufoda).
Gawo 6: Tsopano, sungani mafayilo onse mufoda kukhala fayilo yatsopano ya Zip. Kenako, sinthani fayilo yowonjezera kukhala .xlsm.
Gawo 7: Kenako, tsegulani fayilo ya .xlsm. Zidziwitso zolakwika zosiyanasiyana zidzawonekera. Dinani "Inde" kuti mupitirize.
Gawo 8: Dinani ALT+F11 kuti mutsegule polojekiti ya VBA ndikudina VBAProject Properties pa Zida menyu.
Gawo 9: Tsegulani tabu ya Chitetezo, sankhani "Lock project kuti muwonere" ndikusindikiza OK.
Gawo 10: Sungani fayilo ya .xlsm ndikutseka zenera
Kuipa kwa njira iyi:
- Pali okonza ambiri a hex patsamba. Kusankha yabwino ndi ntchito yovuta ngati mulibe chidziwitso chaukadaulo.
- Ogwiritsa ntchito ena adanenanso kuti sangathe kutsitsa mkonzi wa hexadecimal. Choncho, njira imeneyi si nthawi zonse zothandiza kwa inu.
Gawo 2: Chotsani Kupambana VBA Project Achinsinsi ndi Lodziwika Achinsinsi
Mlanduwu ndiwosavuta kuchita ndipo ndi wofanana ndi zomwe takambirana m'mbuyomu. Kuti mumvetsetse bwino, ndondomekoyi ikufotokozedwa pansipa:
Gawo 1: Tsegulani buku lanu lantchito la Excel ndi Microsoft Excel. Dinani Alt+F11 kuti mupeze pulojekiti ya VBA.
Gawo 2: Pitani ku Zida> VBAProject Properties. Lowetsani mawu achinsinsi olondola mu bokosi la VBAProject Password dialog.
Gawo 3: Pitani ku tabu ya Chitetezo, sankhani "Lock project kuti muwonere" ndikuletsa mawu achinsinsi m'mabokosi otsatirawa.
Gawo 4: Dinani "Chabwino" ndi kusunga ntchito. Ndizomwezo.
Mapeto
Itha kukhala ntchito yowopsa kuchotsa mapasiwedi a projekiti ya VBA ku mafayilo a Excel. Nthawi zonse tikulimbikitsidwa kugwiritsa ntchito njira yabwino komanso yosavuta kugwiritsa ntchito polimbana ndi mafayilo amtunduwu. Izi zimapulumutsa nthawi yambiri ndipo ndizosavuta kwambiri. Yesani tsopano Passper kwa Excel ndipo mudzasangalatsidwa kwambiri.
