Ka taea te uru ki roto i taku kaupapa Excel VBA mēnā kei te tiakina te waehere e te kupuhipa ngaro, kua wareware rānei? Ā, mēnā koinā, me pēhea tēnei? Ko te whakautu he āe. Ehara i te mahi uaua te wawahi i te kupuhipa Excel VBA mēnā kei a koe ngā taputapu tika. Inaa, ina kua whai taputapu me te tikanga tika koe, ka tino ngāwari te wawahi i ngā kupuhipa uaua.
I roto i tēnei tuhinga, ka whakaaturia e mātou ki a koe me pēhea te taumanutia o ngā kupuhipa VBA mā te whakamahi i ētahi tikanga māmā. Engari, me titiro tuatahi tātou ki te kupuhipa VBA i roto i te Excel.
Kupuhipa VBA—Me Pēhea te Mahi?
Ko te VBA (Visual Basic for Applications) he reo hōtaka e whakamahia ana hei hanga i ngā tono Microsoft Office pēnei i Excel me Uru he kaha ake, he māmā ake hoki te whakamahi. Ka whakamahia hoki te VBA hei waihanga i ngā taupānga ritenga.
He Ka taea te tiaki i te kaupapa VBA mā te kupuhipa hei ārai i te urunga kore mana. Ina whakatuwhera koe i tētahi kaupapa VBA i roto i te ripanga tātaitai Excel, ka tonoa pea koe kia whakauru i te kupuhipa (pēnei i te ahua e whakaaturia ana i raro nei). Ki te kore koe e whakauru i te kupuhipa tika, e kore e taea e koe te tiro, te whakatika rānei i te waehere VBA.
Me pēhea te pakaru i tētahi Kupuhipa VBA a Excel
He maha ngā tikanga rerekē ka taea te whakamahi hei wawahi i tētahi kupuhipa Excel VBA. Ka tirohia e tātou ia o ēnei tikanga i raro nei.
Tikanga 1: Te whakamahi Tautuhi Kupuhipa VBA
Ko te "VBA Password Reset a" he monomai whakaora kupuhipa Excel kaha e taea ai te tautuhi anō i te kupuhipa ki te "a" mai i te nuinga o ngā kaupapa VBA. Ka hototahi tēnei taputapu ki te Excel 2007 me runga ake i runga i te rorohiko Windows, me te Excel 2016 me runga ake i runga i te Mac.
Te Excel Tautuhi Kupuhipa VBA Ka taea te uru atu ki te tāpiri-ake, ina tāutahia, ā, ina whakahohea, mai i te rīpene Excel. E rua noa ngā mahi hei tango i te kupuhipa makaro i roto i te Excel.
Hipanga 1. Whakatuwheratia te kōnae pukapuka mahi me te tohu kupuhipa—pāwhiritia te "Tautuhi anō i te kupuhipa VBA – a".
Hipanga 2. Tīpakohia he kōwhiringa hei tautuhi anō i te kupuhipa—i konei ka tīpakohia e tātou te "Tangohia ngā rau katoa i roto i te pukapuka mahi hohe" mai i te tahua.
Ka hoatu ki a koe tētahi tārua o tō kōnae Excel ki te wāhi kotahi i hangaia ai, ā, me te kupuhipa VBA "a".
Tikanga 2: Te whakamahi Tango Kupuhipa VBA a SysTools
I whakaurua mai e SysTools tētahi taupānga Windows e kīia nei ko "SysTools VBA Password Remover" mō ngā putanga Excel 97 me ngā putanga o muri mai. Ka taea e tēnei hōtaka te wahi ngāwari i ngā kupuhipa VBA i roto i ngā pukapuka mahi Excel, me te kore e hiahiatia he mōhiotanga hangarau.
Hipanga 1. Pāwhiritia te pātene i raro nei, ka tikiake i tēnei hōtaka.
Hipanga 2. Kia tīmata te hōtaka, ka kite koe i tētahi whārangi me te taitara "Tirohia ngā whakaritenga o mua", me pāwhiri koe i te pātene "OK" hei haere tonu.
Hipanga 3. Tīpakohia te pukapuka mahi Excel me ngā ihirangi kua whakamunatia mā te whakamahi i te pātene "Tāpiri Kōnae". Kātahi ka pāwhiri i te "Tautuhi Anō" hei iriti i ana waehere VBA katoa.
Hipanga 4. Ka kite koe kua whakatakotoria he kupuhipa hou mō tēnei kōnae, ā, ko te tūnga e kī ana "Pass", ko te tikanga koinei te kupuhipa hei uru atu ki tō kaupapa VBA.
Tikanga 3: Hurihia te Toronga + te Etita Hex
Hei tautuhi anō, hei tango rānei i tētahi kupuhipa mai i tētahi pukapuka mahi Excel mā te whakamahi i te Hex Editor, me tārua tuatahi tātou i te kōnae kua tiakina e te kupuhipa VBA. Kia oti te tārua i te kōnae, whai i ēnei mahi:
Hipanga 1. Hurihia te toronga kōnae Excel mai i te "xlsm" ki te "zip". Mā tēnei ka puta te āhua o te kōnae he pūranga ZIP.
Mō te tini o te tangata, ka tohua te pouaka "Hunaia ngā toronga mō ngā momo kōnae e mōhiotia ana" i roto i ngā Kōwhiringa Kōpaki i te taunoa. Mā te tango i te tohu i tēnei pouaka ka kitea ngā toronga i roto i te Kōnae Explorer.
Hipanga 2. Tangohia te kōnae ZIP mā te whakamahi i tētahi taputapu pēnei i a WinZip, 7-Zip rānei.
Hipanga 3. Whakatuwheratia te kōpaki kua wetewetehia. Kei roto i tēnei he kōpaki iti "xl" kei reira te kōnae "vbaProject.bin".
Hipanga 4. Whakatuwheratia te kōnae “vbaProject.bin” mā te whakamahi i tētahi ētita hex pēnei i HxD .
Hipanga 5. Kimihia te kupu “DPB” i roto i te kōnae.
Hipanga 6. Hurihia inaianei te "DPB" ki te "DPx". Tiakina ngā huringa ka puta.
Ko “B” anake me huri ki “x”, kaua hoki e tangohia te tohu ōrite mā te hē.
Hipanga 7. Kōpeketia ngā kōpaki me ngā kōnae katoa ki tētahi kōnae ZIP.
Hipanga 8. Hurihia te toronga mai i te "zip" ki te "xlsm", kātahi ka whakatuwheratia.
Hipanga 9. Āe, kei roto koe i te kōnae xlsm. Ko te mea tuatahi ka puta ko te maha o ngā hapa e puta ake ana engari kaua e manukanuka: pēhi noa i te "Āe" hei whakakore i aua hapa.
Whakatuwheratia te ētita VB mā te pāwhiri i te "Developer" kātahi ko te "Visual Basic". Kātahi, i raro i te "Tools" > "VBAProject Properties", tangohia te tohu mō te "Lock project for viewing".
Hipanga 10. Katia te ētita ka tiaki i te kōnae Excel. Tērā pea ka whakamōhio atu koe kia tiakina koe ki tētahi atu wāhi hei kōnae hou.
Hipanga 11. Whakatuwheratia te kōnae hou. Ka kitea tō waehere VBA inaianei, kāore he hiahia ki te whakauru i tētahi kupuhipa!
*Kua whakamatauria e mātou tēnei tikanga i runga i tētahi kōnae Excel 2007.
Whakamutunga
Kua whakamahia te Kupuhipa VBA e te tini o ngā kaiwhakawhanake hei tiaki i tā rātou waehere kei kitea, kei whakatikahia rānei e ētahi atu tāngata ka whakamahi hē i tēnei. He tikanga pai tēnei i te nuinga o te wā, engari ki te wareware koe i tō kupuhipa Excel VBA, ā, me kite koe i te waehere o tō kaupapa, ka āwhina ēnei tikanga i a koe.
I roto i tēnei tuhinga kua hipokina e mātou ngā huarahi e toru e taea ai e koe te uru atu ki tō kaupapa VBA me te kore e hiahiatia he kupuhipa. Ahakoa e hiahia ana koe ki te whakamahi i tētahi taputapu tāpiri tikiake rānei i tētahi hōtaka tango kupuhipa mai i SysTools , kāore e roa ka tuwhera anō tō kōnae, ā, ka taea te whakatika anō.
