Le tutorial igubungela ukusebenzisa irekhodi enkulu ukwenza i-macro elula kwi- Excel . Irekhoda enkulu isebenza ngokurekhoda zonke ii-keystrokes kunye nokuchofoza kwe mouse. I-macro eyenziwe kule khokelo iya kusetyenziswa inamba yokwenza ifomathi kwisihloko somsebenzi.
Kwi-Excel ka-2007 kunye no-2010, yonke imiyalelo enxulumene ne-macro ifumaneka kwiTebhu yonjiniyela yerbhoni . Ngokuqhelekileyo, le tibhu kufuneka idibaniswe kwi-Ribbon ukwenzela ukuba ufikelele kwimimiselo emininzi. Izihloko ezivezwe yilo khokelo ziquka:
- Ukongeza ithebhu yonjiniyela
- Ukuqala i-Excel macro recorder
- Izinketho zokurekhoda ze-Excel macro
- Ukurekhoda i-macro
- Ukuqalisa i-macro
- Iimpazamo zeMacro / Ukuhlela i-macro
01 ngo-06
Ukongeza ithebhu yonjiniyela
- Cofa kwifayile yefayile yedbhoni ukuvula imenyu yefayile.
- Cofa kwiNketho kwimenyu ukuvula ibhokisi yencoko yebhokisi ye - Excel .
- Cofa kwi-window ye- Ribbon kwifowuni yesandla sokunxele ukuze ubuke iinketho ezikhoyo kwiwindow yekunene kwibhokisi yencoko.
- Ngaphantsi kweCandelo eliPhezulu leTabs leenketho, iifestile ihlola inketho yoMqhubi .
- Chofoza OK.
- Ithebhu yonxibelelwano kufuneka ibonakale kwi-Ribbon kwi-Excel 2010.
Ukongeza ithebhu yonjiniyela kwi-Excel 2007
- Kwi-Excel 2007, cofa kwi- Office iqhosha lokuvula imenyu ehlayo.
- Cofa kwiqhosha le-Excel Options ephantsi kwe menu ukuvula ibhokisi yencoko yebhokisi ye- Excel .
- Cofa kwiNyulo eDumeleyo phezulu kwiphepha lesandla sobunxele sebhokisi yencoko yababini.
- Cofa kwi- Show Developer Tab kwi-ribhoni ewindini elisekunene lebhokisi yencoko yababini.
- Chofoza OK.
- Ithebhu yonxibelelwano kufuneka ibonakale kwi-ribbon ngoku.
02 we-06
Ukongeza Isihloko Sobugcisa / I-Excel Macro Recorder
Ngaphambi kokuba siqale ukurekhoda i-macro yethu, kufuneka sidibanise isihloko seshidi esiya kufometha.
Ekubeni isihloko sephepha ngalinye siqhelekile kwi-sheetworksheet, asifuni ukufaka isihloko kwi-macro. Ngoko ke siya kuyongeza kwiphepha lokusebenzela, ngaphambi kokuqala irekhodi enkulu.
- Cofa kwi-cell A1 kwiphepha lokusebenzela.
- Thayipha isihloko: I- Cookie IiNcwadi zoThengiselo ngo-Juni 2008 .
- Cinezela ukhiye wokungena kwikhibhodi.
I-Excel Macro Recorder
Indlela elula yokudala i-macro kwi-Excel kukusebenzisa irekhodi enkulu. Ukwenza njalo:
- Cofa kwiTeb Developers .
- Cofa kwiRekodi ye-Macro kwibhrabhoni ukuvula ibhokisi yencoko ye- Record Macro .
03 we-06
Izinketho ze-Macro Recorder
Kukho iindlela ezine zokugqiba kule bhokisi yencoko:
- Igama leMacro - unike igama lakho elichazayo. Igama kufuneka liqale ngeleta kunye neendawo azivunyelwe. Kuphela iileta, iinombolo kunye nomlinganisi wokugqwesa ovumelekileyo.
- Iqhosha lokunciphisa - (ukhetho) gcwalisa ileta, inombolo, okanye ezinye iilwimi kwindawo ekhoyo. Oku kuya kukuvumela ukuba usebenze i-macro ngokubamba phantsi iqhosha le CTRL kwaye ucinezela ileta ekhethiweyo kwibhodibhodi.
- Gcina i macro
- Khetha:
- Le ncwadi
- I-macro iyatholakala kuphela kule fayili.
- Intsha yokusebenzela
- Olu khetho luvula ifayile entsha ye-Excel. I-macro iyatholakala kuphela kule fayile entsha.
- Incwadi yokusebenzela yamacrosoft.
- Olu khetho ludala ifayile efihliweyo ye- Personal.xls egcina ii-macros zakho kwaye yenza ukuba zifumaneke kuzo zonke iifayile ze-Excel.
- Inkcazo - (ukhetho) faka inkcazelo ye-macro.
Kule Tutorial
- Hlela okukhethwa kukho kwibhokisi yencoko ye- Record Macro ukuze ufanise nalawo mfanekiso ongentla.
- Musa ukucofa i-OK - kodwa-bonani ngezantsi.
- Ukucofa iqhosha le-OK kwibhokisi yencoko ye- Macro iqalisa ukurekhoda i-macro oyifumene.
- Njengoko kukhankanywe ngaphambili, irekhoda enkulu isebenza ngokurekhoda zonke iifayile kunye nokuchofoza kwe mouse.
- Ukudala i- format_titles macro iquka ukucofa kwiindlela ezininzi zefomathi kwithebhu yasekhaya yerbhoni kunye ne mouse xa i-recorder enkulu isebenza.
- Yiya kwisinyathelo esilandelayo ngaphambi kokuba uqale irekhodi le-macro.
04 we-06
Ukurekhoda ii-Macro Steps
- Cofa iqhosha le-OK kwibhokisi yencoko ye- Macro yokurekhoda ukuqala irekhoda enkulu.
- Cofa kwiThebhu yasekhaya yerbhoni.
- Khanyisa iiseli A1 ukuya kwi-F1 kwiphepha lokusebenzela.
- Cofa kwi-icon ye- Merge kunye neZiko ukubeka isihloko phakathi kweeseli A1 no-F1.
- Cofa kwi-icon ye- Fill Color (ibukeka ngathi upende uyakwazi) ukuvula uluhlu lokuhla kwebala lokugcwala.
- Khetha iBlue, i-Accent 1 ukusuka kuloluhlu ukuguqula umbala wangasemva weeseli ezikhethiweyo.
- Cofa kwi icon ye- Font Color (yileta enkulu "A") ukuvula uluhlu lokunciphisa umbala wefonti.
- Khetha Uluhlu oluvela kwiluhlu ukuguqulela umbhalo kumaseli akhethiweyo ukuba abe mhlophe.
- Cofa kwi icon ye Font Size (ngasentla itekisi ingabonakalisa uphawu) ukuvula uluhlu lokuhlaselwa kobukhulu befonti.
- Khetha 16 ukusuka kwoluhlu ukutshintsha ubungakanani bombhalo kwiiseli ezikhethiweyo ukuya kumanqaku angama-16.
- Cofa kwiTebhu yonjiniyela yerbhoni.
- Cofa iqhosha lokurekhoda ye-Stop kwi-Ribbon ukuyeka ukurekhoda okubanzi.
- Kule ngongoma, isihloko sakho somsebenzi sifana nesihloko kumfanekiso ongentla.
05 ka 06
Ukuqalisa iMacro
Ukuqhuba i-macro oyibhalileyo:
- Cofa kwiTebhu ye - Sheet2 kwiphepha le- spreadsheet .
- Cofa kwi-cell A1 kwiphepha lokusebenzela.
- Thayipha isihloko: I- Cookie Shop Shop kuJulayi 2008 .
- Cinezela ukhiye wokungena kwikhibhodi.
- Cofa kwiTebhu yonjiniyela yerbhoni.
- Cofa iqhosha le- Macros kwibhandi ukuze ukhuphe ibhokisi yencoko ye- Macro .
- Cofa kwi format_titles macro kwiwindow yegama le- Macro .
- Cofa iqhosha le Run .
- Amanyathelo omsebenzi kufuneka asebenze ngokuzenzekelayo kwaye afake amanyathelo afomathi afanayo asetyenziswa kwisihloko kwiphepha 1.
- Kule ngongoma, isihloko esikwiphepha 2 sephepha kufuneka sifane nesihloko kwiphepha lokusebenzela 1.
06 we-06
Iimpazamo zeMacro / Ukuhlela iMacro
Iimpazamo zeMacro
Ukuba i-macro yakho ayizange yenze njengoko ilindeleke, indlela elula, eyona ndlela ilula kakhulu kukulandela amanyathelo okufundiswa kwakhona kwaye urekhode kwakhona i-macro.
Ukuhlela / Isinyathelo kwi-Macro
I-Excel macro ibhaliwe kwiilwimi zoLwimi lweValual Basic Applications (VBA).
Ukuchofoza kwi- Hlela okanye Isinyathelo Kwiibhokisi kwibhokisi yencoko ye-Macro iqalisa umhleli we-VBA (bona umfanekiso ophezulu).
Ukusebenzisa umhleli we-VBA kunye nokugubungela ulwimi lweprogram ye-VBA kungaphaya kobuchule beli khokelo.