Yadda ake Cire Kalmar wucewa daga Aikin VBA na Excel [Hanyoyin 4]

Ina so in san yadda ake cire kalmar sirri daga aikin VBA a cikin Excel. Wa zai iya taimakona?

Kafin ko da neman hanyoyin da za a cire VBA kalmar sirri a Excel, dole ne ka fahimci ma'anar VBA. VBA gagara ce ga Kayayyakin Basic don Aikace-aikace. Ana amfani da shi ta aikace-aikacen MS daban-daban, musamman MS Excel, don ƙara wasu fasaloli da kuma taimakawa wajen sarrafa ayyukan yau da kullun. Saboda yanayin su da buƙatar tsaro na fayil, yawancin masu amfani suna ɓoye ayyukan VBA tare da kalmomin shiga. Duk da haka, mutane ba cikakke ba ne kuma ana iya manta da kalmomin shiga na VBA. Ma'anar ma'anar ita ce ba za ku iya samun dama ko gyara lambobinku na VBA na Excel ba. Don doke wannan hargitsi, kana bukatar wata hanya zuwa crack wani Excel VBA kalmar sirri. Abin farin ciki, akwai hanyoyi da yawa don cim ma wannan aikin. A cikin wannan labarin, za ka sami cikakken jagora a kan saman 4 hanyoyin da za a crack Excel VBA kalmomin shiga.

Sashe na 1: Yadda ake Cire kalmar wucewa ta aikin VBA a cikin Excel Ba tare da Shirye-shirye ba

Za a iya buɗe aikin VBA a cikin Excel tare da taimakon software na lalata VBA ta atomatik ko ta hanyar hannu. Delving cikin yadda za a crack Excel VBA kalmar sirri da hannu, akwai da dama kyau hanyoyin iya samun aikin yi. Kuna iya zaɓar daga waɗannan zaɓuɓɓukan kuma gwada tare da ingantaccen fayil ɗin Excel ɗin ku. Daga ƙarshe, ɗayan waɗannan zaɓuɓɓukan na iya zama mafi kyau, ya danganta da yanayin takaddar ka da buƙatun da ke hannunka. Kafin yin amfani da waɗannan hanyoyin da hannu, dole ne ku adana fayilolinku na Excel.

Hanyar 1. Canja tsawo fayil don buše Excel VBA module

Wannan hanyar ta ƙunshi canza tsawo na fayil .xlsm zuwa wani tsari sannan kuma komawa zuwa tsarin .xlsm daga baya. Ko da yake tsari ne tsawo, za ka iya bi shi a hankali don cire your Excel VBA kalmar sirri ƙarshe. Matakan da ke gaba suna kwatanta yadda za ku iya fasa kalmar sirrin aikin VBA ta Excel ta hanyar canza tsawo na fayil kawai.

Mataki na 1 : Nemo fayil ɗin .xlsm manufa kuma canza tsawo na fayil .xlsm zuwa zip.

Mataki na 2 : Yanzu buɗe wannan fayil ta kowane ɗayan shirye-shiryen Archiver da kuke da shi. Kuna iya amfani da WinRAR ko 7-Zip. Idan kun yi haka, ya kamata ku iya ganin tsari mai zuwa na kundin fayil ɗin ku.

Mataki na 3 : Kewaya zuwa zaɓin shugabanci na XL kuma cire fayil ɗin da aka lakafta "VBAProject.bin".

Mataki na 4 : Bude fayil ɗin VBAProject.bin ta kowane editan hex kuma duba rubutun "DPB =" a cikin fayil ɗin a cikin editan hex.

Mataki na 5 : Da zarar ka sami wannan rubutun, kawai ka goge shi kuma ka maye gurbinsa da "DPX=" maimakon. Yanzu ajiye kuma rufe fayil ɗin ku a cikin editan hex. Yana sake rubuta tsohuwar VBAProject.bin tare da sabon VBAProject.bin da aka gyara hex.

Mataki na 6 : Mayar da tsawo na fayil zuwa .xlsm sannan ka bude shi a cikin Excel. A cikin taga mai faɗakarwa, zaɓi "Ee" kuma kuyi watsi da sauran zaɓuɓɓukan.

Mataki na 7 : Gudanar da editan VBA kuma zaɓi "Ok" idan akwatin maganganu ya bayyana.

Mataki na 8 : Danna-dama sunan aikin VBA ɗin ku sannan zaɓi kaddarorin. Zaɓi shafin "Kariya" kuma share kalmomin shiga da ke akwai. Hakanan, musaki akwatin rajistan "Kulle Project don Dubawa" kuma sake kunna shi. Shigar da kalmar sirri mai dacewa kuma tabbatar da shi. Danna "Ok" don yin canje-canje.

Hanyar 2. Cire Excel VBA Project Password tare da Hex Edita

Hex Edita yana ba ku kyakkyawan dandamali don shirya samfuran hex kuma a ƙarshe fashe kalmar sirri ta VBA ta Excel. Ta wannan hanyar, zaku ƙirƙiri fayil ɗin dummy xls, saita kalmar sirri, sannan kuyi amfani da shi don shiga cikin Excel mai kariya.

Mataki na 1 : Yi amfani da editan Hex don ƙirƙirar sabon fayil na Excel (xls). Fayil mai sauƙi kawai zai iya yin shi.

Mataki na 2 : Ƙirƙiri kalmar sirri don wannan fayil a cikin sashin VBA. Kuna iya danna Alt+F11 don samun damar wannan zaɓi.

Mataki na 3 : Bayan kun ƙirƙiri kalmar sirri mai sauƙi don tunawa, adana wannan sabon fayil ɗin kuma fita.

Mataki na 4 : Buɗe wannan sabon fayil ɗin da aka ƙirƙira, amma wannan lokacin, buɗe shi ta wurin editan hex. Da zarar an buɗe, gano wuri da kwafi layin, waɗanda ke farawa da maɓallan masu zuwa: CMG=, DPB= da GC=.

Mataki na 5 : Yanzu buɗe fayil ɗin Excel wanda kuke son fasa kalmar wucewa tare da editan Hex. Manna rubutun da aka kwafi a cikin filayen kuma ajiye canje-canje. Fita fayil ɗin.

Mataki na 6 : Kullum buɗe fayil ɗin Excel kuma yi amfani da kalmar sirri iri ɗaya da kuka ƙirƙira don fayil xls dummy don duba lambar VBA.

Hanyar 3. Cire kalmar sirri daga aikin VBA na Excel tare da Editan Kayayyakin Kayayyaki

Ba kamar editan Hex ba, Editan Kayayyakin Kayayyakin Kayayyakin Kayayyakin Yana ba masu amfani damar gyara lambobin haruffa maimakon na hexadecimal. Tsarin bai daɗe haka ba. Koyaya, dole ne ku yi hankali saboda lambobin suna buƙatar kulawa don guje wa kurakurai. Matakan da ke biyowa suna nuna a sarari yadda zaku iya fashe kalmar sirri ta Macro ta Excel tare da Editan Kayayyakin Kayayyakin Kayayyakin Kayayyakin.

Mataki na 1 : Buɗe littafin aiki da hannu wanda ke ɗauke da kariyar takardar Excel.

Mataki na 2 : Yanzu buɗe Editan Kayayyakin Kaya ta amfani da umarnin Alt+F11. Jeka Module Embed sannan a liƙa lambar mai zuwa a cikin taga lambar da ke hannun dama.

Mataki na 3 : Fita taga Editan VBA kuma ci gaba da takaddun aiki mai kariya.

Mataki na 4 Je zuwa Tools > Macro > Macros. A cikin jerin da ya bayyana, danna sau biyu akan zaɓi "PasswordBreaker". Ya kamata yanzu ku sami damar shiga fayil ɗin Excel mai kare kalmar sirrinku.

Sashe na 2: Iyakokin hannu lokacin buɗe aikin VBA a cikin Excel

Ko da yake manual hanyoyin da amfani ga fatattaka Excel VBA kalmomin shiga, su ne babu inda kusa da cikakke. Waɗannan hanyoyin suna fama da matsaloli da yawa waɗanda ke sa su zama mara kyau idan ya zo ga mahimman fayilolin Excel masu rikitarwa. Wadannan su ne wasu iyakokin gama gari na hanyoyin hannu.

• Yana buƙatar ilimin fasaha : Kamar yadda kuka gani, yawancin zaɓuɓɓukan da ke sama sun ƙunshi lamba da yawa. Don haka idan kuna da ƙananan ilimin fasaha, za ku yi wahala tare da waɗannan zaɓuɓɓukan hannu.
• Yana cinye lokaci mai yawa : Yawancin hanyoyin hannu sun haɗa da tsayin matakai. Gaskiyar cewa shi ma ya ƙunshi lambobin da motsi a fadin dandamali da yawa ya sa ya zama mai ban sha'awa kuma saboda haka masu amfani za su same shi jinkirin da gajiya.
• Yawan nasara : Abin da ke da mahimmanci, a ƙarshe, shine ko za mu iya fasa kalmar wucewa ta Excel VBA ko a'a. Abin takaici, waɗannan zaɓuɓɓukan jagora suna yin rikodin mafi ƙarancin ƙimar nasara. Sabili da haka, ba shi da kyau a kashe lokaci mai yawa da kuzari sannan kuma kada ku sami sakamakon da kuke buƙata.

Wannan ya ce, idan duk zaɓuɓɓuka sun kasa ko kun gaji da gazawar su, daga baya gwada amfani da aikace-aikace na musamman kamar Passer for Excel don crack Excel VBA kalmar sirri ta atomatik.

Sashe na 3: Yadda ake Crack Excel VBA Password atomatik

Fasfo don Excel kayan aiki ne mai ƙarfi mai ƙarfi na buɗe kalmar sirri don fayilolin Excel. Shirin yana ba da tabbacin ƙimar nasara 100% don fasa kalmar sirrin aikin VBA na Excel. Tare da saurin ɓarnawar sauri da sauƙin amfani, babu wani dalili na shakkar ikon Fasfo don Excel. Hakanan yana da mahimmanci a lura cewa ana iya amfani da Fasfo don Excel don fasa takaddar buɗe kalmar sirri don fayilolin Excel.

Babban fasali na Fasfo don Excel:

• Duk ƙuntatawa da gyarawa da tsarawa a cikin aikin VBA ɗinku, takaddar aiki, ko littafin aiki ana iya yanke su nan take.
• Tare da Fasfo don Excel, danna sauƙi mai sauƙi zai ba ka damar kawar da kariyar kalmar sirri akan aikin VBA.
• Bayanan ku ba zai shafi ko lalacewa ba bayan amfani da shirin.
• Shirin yana da dacewa sosai. Duk nau'ikan fayilolin Excel da suka haɗa da .xlsm, .xlsb, .xltx, .xltm sun dace da shi.

Fasfo don Excel ya bauta wa miliyoyin masu amfani a duniya. Kuma ya sami tabbataccen sake dubawa daga masu amfani da shi. Kada ku yi shakka a gwada shi yanzu.

Gwada shi kyauta

Yadda za a cire kalmar sirri ta VBA a cikin Excel tare da Fasfo don Excel

Mataki 1: Kaddamar da Fasfo don Excel akan PC ɗin ku kuma danna kan zaɓi "Cire ƙuntatawa".

Mataki na 2: A cikin sabuwar taga, danna maɓallin "Zaɓi Fayil" kuma bi umarnin kan allo don loda fayil ɗin Excel VBA mai kariya kalmar sirri zuwa ƙirar shirin.

Mataki na 3: Lokacin da aka ɗora fayil ɗin da aka kare kalmar sirri, danna zaɓin "Share" don kawar da kalmar sirrin aikin VBA a cikin fayil ɗin Excel ɗin ku.

Shirin zai cire ƙuntatawa ta atomatik a cikin daƙiƙa. Lokacin da ya kammala, yakamata ku ga sanarwar nasara a ƙasan allon.

Kammalawa

Wannan jagorar ya bayyana a fili wasu hanyoyin da za a iya amfani da su don fasa kalmomin shiga na Excel VBA. Duk da haka, wasu siffofin sun fi wasu girma saboda ikon su na rike hadaddun kalmomin shiga na VBA, sauƙin amfani, da ƙimar nasara da aka buga. Daga yawan adadin bayanan da aka bayar a sama, babu wanda zai iya jayayya Fasfo don Excel a matsayin ainihin bayani don crack Excel VBA aikin kalmar sirri. Duk sigogin ma'auni sun sanya shi gaba da zaɓuɓɓukan hannu. Zaɓi Fasfo don Excel kuma warware matsalolin kalmar sirri na VBA har abada.

Gwada shi kyauta