Aikin Excel Visual Basic for Applications (VBA) harshe ne na shirye-shirye da ake amfani da shi a cikin Excel don haɓaka shirye-shirye masu sauƙi. Yawancin lokaci ana amfani da shi don juya ayyuka masu rikitarwa ko masu cin lokaci zuwa ayyuka na atomatik, tsarin adana lokaci, bi da bi don inganta ingantaccen tsarin bayar da rahoto. Waɗannan ayyukan VBA, duk da haka, wani lokaci ana iya kiyaye kalmar sirri, don kare sirrin ku ko don hana duk wani keta ainihin rubutun aiki. Saboda haka, wani lokaci yana iya zama da wahala a tuna waɗannan kalmomin shiga, ko dai saboda masu amfani da su sun manta ko sun rasa kalmar sirri ko don wasu dalilai daban-daban. Saboda haka, wannan labarin zai haskaka daban-daban sauki hanyoyin da za a iya amfani da su cire kalmar sirri daga Excel VBA aikin.
Akwai nau'i biyu na lokuta da za ku iya fuskanta lokacin ƙoƙarin cire kalmomin shiga daga ayyukan VBA na Excel. Za mu yi magana game da abubuwa biyu mataki-mataki.
Part 1: Cire Excel VBA Project Password Ba tare da Sanin Kalmar wucewa ba
Don yin wannan, zaku iya ɗaukar hanyoyi da yawa, uku daga cikinsu sune kamar haka:
Cire kalmar wucewa ta aikin VBA na Excel a cikin Dannawa ɗaya don Fayilolin XLS/XLSM
Akwai mahara shirye-shirye a kasuwa da za su iya taimaka maka cire kalmomin shiga daga Excel VBA aikin. Kyakkyawan misali shine Fasfo don Excel , wanda shine mafita mai sauƙi kuma mai tasiri don kawar da duk kariyar gyarawa da tsarawa da aka gina a cikin takaddun aiki / littafin aiki ta hanyar lambar VBA.
Wasu daga cikin manyan fasalulluka na Fasfo don Excel sune:
- Za a iya cire kalmar sirrin aikin VBA a cikin littafin aikin ku na Excel tare da dannawa mai sauƙi .
- Garanti a Yawan nasara 100%. .
- Ƙungiyar Fasfo ta damu da ita tsaro na su data . Ba za a sami asarar bayanai ko yoyo yayin / bayan cire tsari.
- Shirin yana da a m karfinsu . Yana goyan bayan .xls, .xlsx, .xlsm, .xlsb, .xltx, .xltm da sauran fayilolin da Microsoft Excel ya ƙirƙira.
Don kwatanta sauƙin amfani da Fasfo don Excel, mun shirya muku cikakken jagora. Da farko, dole ne ka sauke shirin kuma ka sanya shi a kan kwamfutarka.
Mataki 1. Da zarar an shigar, dole ne ka zabi "Cire ƙuntatawa" zaɓi.
Mataki 2. Yi amfani da maɓallin "Zaɓi fayil" don loda fayil ɗin Excel mai kare kalmar sirri. Da zarar an ƙara fayil ɗin zuwa software, kawai danna kan zaɓin "Share" don kawar da kariyar kalmar sirri daga takardar Excel.
Mataki 3. A cikin seconds, da VBA aikin kalmar sirri za a cire daga Excel workbook.
Fasfo don Excel Shiri ne mai ƙarfi kuma abin dogaro. Ya sami tabbataccen sake dubawa daga masu amfani. Kada ku yi shakka don amfani da shi.
Cire Kalmar wucewa ta Project VBA akan layi
Wani tsarin kula don cire kalmar sirrin aikin VBA a cikin takaddun Excel ɗinku shine yin amfani da sabis na kan layi akan yanar gizo. Kyakkyawan misali na wannan nau'in kayan aikin kan layi shine Office VBA Password Remover. Wannan kayan aikin kan layi yana taimaka muku kawar da kariyarku, amma yana buƙatar matakai da yawa. Hanyar ita ce ta gaba:
Mataki 1: Danna "Buɗe fayil" don loda aikin VBA ɗinku da kalmar sirri mai kariya ta Excel fayil.
Mataki na 2: Danna "Decrypt VBA" don tabbatar da zazzage sabuwar takaddar.
Mataki na 3: Da zarar an sauke, buɗe daftarin aiki. Zai tunatar da ku cewa aikin ya ƙunshi maɓalli mara inganci. Danna "Ee" don ci gaba.
Mataki na 4: Latsa ALT+F11 don buɗe aikin VBA. A cikin macro taga, bai kamata ku fadada aikin ba. Na gaba, je zuwa Kayan aiki> Kayan aikin VBA.
Mataki na 5: Jeka shafin Kariya, saita sabon kalmar sirri da kuka zaba sannan ku bar akwati da aka zaba.
Mataki na 6: Ajiye daftarin aiki kuma rufe aikin VBA.
Mataki na 7: Bude littafin aikin Excel ɗin ku kuma sake maimaita mataki na 4.
Mataki na 8: A wannan lokacin kana buƙatar share akwati da filayen kalmar sirri a cikin shafin "Kariya".
Mataki na 9: Ajiye takardar kuma. An cire kalmar sirri.
Fursunoni na wannan hanyar:
- Loda fayil ɗin ku na Excel zai ɗauki lokaci. Haka nan, babu sandar sarrafawa, don haka ba za ku iya sanin ko an loda fayil ɗin ku ko a'a.
- Loda fayil ɗin Excel ɗin ku zuwa gidan yanar gizon su ba shi da aminci ga bayanan ku, musamman lokacin da bayananku ke da hankali.
Cire Kalmar wucewa daga Aikin VBA na Excel Amfani da Editan HEX
Editan hex na iya zama kayan aiki mai amfani idan kuna son cire kalmomin shiga da hannu daga aikin VBA na Excel. Akwai hanyoyi daban-daban guda biyu da ake buƙata don cire kalmomin shiga dangane da nau'in fayil ɗin Excel. Kafin fara aikin jagora, koyaushe ku tuna yin ajiyar fayilolin Excel da kuke aiki da su.
Idan nau'in fayil ɗin shine XLS:
Mataki 1: Bude fayil ɗin .xls mai-kare kalmar sirri tare da editan hex kuma nemi kirtani "DPB."
Mataki na 2: Sauya "DPB" da "DPX".
Mataki na 3: Ajiye fayil ɗin kuma fita editan.
Mataki na 4: Na gaba, buɗe fayil ɗin tare da Microsoft Excel. Sanarwa na kuskure da yawa za su bayyana, wanda yake al'ada. Tabbatar danna kan su.
Mataki na 5: Yanzu danna ALT + F11 don buɗe taga aikin VBA kuma danna kan kaddarorin VBAProject daga menu na Kayan aiki.
Mataki na 6: A shafin Kariya, canza kalmar wucewa zuwa wani abu mai sauƙi da sauƙin tunawa.
Mataki na 7: Ajiye littafin aikin kuma fita daga taga.
Mataki na 8: Sake buɗe littafin aikin Excel kuma sami damar taga aikin VBA ta latsa ALT + F11 kuma shigar da kalmar wucewa da kuka canza yanzu. Maimaita mataki na 6, amma wannan lokacin zaka iya cire kalmar sirri.
Mataki na 9: Ajiye littafin aiki kuma yanzu kuna da fayil ɗin Excel ba tare da kalmar sirri ba.
Idan nau'in fayil ɗin shine XLSM:
Don kari na .xlsm, ana buƙatar ƙarin mataki a farkon. A ƙasa muna ba ku jagorar mataki-mataki.
Mataki 1: Canja tsawo na fayil ɗin .xlsm zuwa .zip. Sannan bude shi da 7Zip ko WinZip.
Mataki na 2: Nemo kuma kwafi fayil ɗin "xl/vbaProject.bas" ko "xl/vbaProject.bin" daga fayil ɗin zip. Tabbatar cewa babban fayil ɗin zip yana buɗe.
Mataki na 3: Danna kuma buɗe fayil ɗin "xl/vbaProject.bas" ko "xl/vbaProject.bin" ta amfani da editan hex.
Mataki na 4: Nemo kirtani "DPB" kuma maye gurbin shi da "DPX".
Mataki na 5: Ajiye fayil ɗin, kuma kwafa shi zuwa babban fayil ɗin Zip (zaka iya ja da sauke fayil ɗin cikin babban fayil ɗin).
Mataki na 6: Yanzu, zip duk fayilolin da ke cikin babban fayil zuwa sabon fayil ɗin Zip. Na gaba, canza tsawo na fayil zuwa .xlsm.
Mataki na 7: Na gaba, buɗe fayil ɗin .xlsm. Za a bayyana sanarwar kuskure daban-daban. Danna "Ee" don ci gaba.
Mataki na 8: Latsa ALT + F11 don buɗe aikin VBA kuma danna VBAProject Properties akan menu na Kayan aiki.
Mataki na 9: Bude shafin Kariya, cire alamar "Kulle aikin don dubawa" kuma danna Ok.
Mataki na 10: Ajiye fayil ɗin .xlsm kuma rufe taga
Fursunoni na wannan hanyar:
- Akwai masu gyara hex da yawa akan gidan yanar gizon. Zaɓin mai kyau aiki ne mai wahala idan ba ku da ilimin fasaha.
- Wasu masu amfani sun ba da rahoton cewa ba za su iya sauke editan hexadecimal ba. Don haka, wannan hanyar ba koyaushe tana da amfani a gare ku ba.
Part 2: Cire Excel VBA Project Password tare da Sanin Kalmar wucewa
Wannan shari'ar tana da sauƙin aiwatarwa kuma tana kama da tattaunawarmu ta baya. Don sauƙin fahimta, an bayyana hanyar a ƙasa:
Mataki 1: Bude littafin aikinku na Excel tare da Microsoft Excel. Latsa Alt+F11 don samun damar aikin VBA.
Mataki na 2: Je zuwa Kayan aiki> VBAProject Properties. Shigar da kalmar sirri daidai a cikin akwatin maganganu na VBAProject Password.
Mataki na 3: Je zuwa shafin Kariya, cire alamar "Kulle aikin don dubawa" kuma kashe kalmar wucewa a cikin akwatuna masu zuwa.
Mataki na 4: Danna "Ok" kuma ajiye aikin. Shi ke nan.
Kammalawa
Zai iya zama mummunan aiki don cire kalmomin shiga na aikin VBA daga fayilolin Excel. Ana ba da shawarar koyaushe don amfani da ingantaccen bayani mai sauƙi kuma mai sauƙin amfani yayin mu'amala da waɗannan nau'ikan fayiloli. Wannan yana adana lokaci mai yawa kuma shine mafi dacewa. Gwada yanzu Fasfo don Excel kuma za ku sha'awar sosai.
