I-Excel macros: yintoni na kwaye isetyenziswa njani

Ukuba unoluhlu olulula lwezenzo ofuna ukuphinda amaxesha amaninzi, unokuba ne-Excel urekhode ezi zenzo kwaye uvelise i-macro equlethe ikhowudi yokuphinda.

Nje ukuba urekhode i-macro, unokuphinda uthotho lwezenzo kaninzi njengoko ufuna, ngokuqhuba irekhoda enkulu. 

Oku kusebenza kakhulu kunokuphinda ngesandla uthotho lwezenzo ngexesha ngalinye.

Ukurekhoda i-macro kufuneka uqale inkqubo yokurekhoda. Olu khetho lufumaneka kwimenyu Macro , ebekwe kwisithuba View kwiribhoni ye-Excel (okanye kwimenyu a Inzala Izixhobo kwi-Excel 2003). Olu khetho luboniswe kwimifanekiso engezantsi:

Rekhoda iimakhro kwiinguqulelo zangoku ze-Excel (2007 nasemva koko):

Emva koko uya kuboniswa ngebhokisi yencoko ethi "Record Macro". 

Le bhokisi ikuvumela ukuba ufake igama kunye nenkcazo ye-macro yakho, ukuba uyanqwena. Luluvo oluhle ukunika i-macro igama elinentsingiselo, ukuze xa ubuyela kwi-macro kamva, oku kuya kukunceda ukhumbule into eyenzayo. Nangona kunjalo, ukuba awuboneleli gama, i-Excel iya kuthiya ngokuzenzekelayo i-macro (umz. Macro1, Macro2, njl.).

Ibhokisi yencoko ethi "Record Macro" ikwakunika ithuba lokwabela isinqumli sebhodibhodi kwimacro yakho. Oku kuya kwenza ukuba i-macro ibe lula kakhulu ukuyiqhuba. Nangona kunjalo, kuya kufuneka ulumke ungabeki enye yeendibaniselwano zesitshixo sangaphambili kwi-macrodefinite of Excel (umzekelo CTRL-C). Ukuba ukhetha i-Excel ekhoyo indibaniselwano yesitshixo, iya kubhalwa ngaphezulu yi-macro yakho, kwaye wena okanye abanye abasebenzisi banokuphela ngengozi besebenzisa ikhowudi enkulu.

Nje ukuba wonwabe ngegama elikhulu kwaye (ukuba kuyimfuneko) indlela emfutshane yebhodibhodi, khetha u-Kulungile ukuqalisa ukurekhoda imacro.

Nje ukuba uqalise ukurekhoda i-macro yakho, zonke izenzo ozenzayo (ukufakwa kwedatha, ukhetho lweseli, ukufomatha iiseli, ukuskrola kwe-worksheet, njl. njl.) ziya kubhalwa kwi-macro entsha, njengekhowudi ye-VBA.

Ukongeza, njengoko urekhoda i-macro yakho, uya kubona iqhosha lokumisa ezantsi ekhohlo kwincwadi yakho yokusebenza (okanye kwi-Excel 2003, iqhosha lokumisa liya kunikezelwa kwibar yesixhobo edadayo), njengoko kubonisiwe ngezantsi:

Nje ukuba uzigqibile izenzo ofuna ukuzirekhoda, unokuyeka ukurekhoda i-macro ngokucofa iqhosha lokumisa. Ikhowudi enkulu ngoku izakugcinwa kwimodyuli ngaphakathi komhleli weVisual Basic.

'Sebenzisa izingqinisiso ezizalanayo' ukhetho

Ukuba ukhetha ukhetho Sebenzisa iimbekiselo ezizalanayo Xa urekhoda i-macro, zonke iireferensi zeeseli ngaphakathi kwe-macro ziya kuzalamana. Nangona kunjalo, ukuba ukhetho Sebenzisa iimbekiselo ezizalanayo ayikhethwanga, zonke iireferensi zeeseli eziboniswe kwikhowudi ziya kuba ziphelele (bona iposti yethu abasebenzi bereferensi).

Inketho Sebenzisa iimbekiselo ezizalanayo ifumaneka kwimenyu Macro (kwaye ifumaneka kwi-toolbar yeMacro kwi-Excel 2003). 

Ukuqhuba iimakhro ezirekhodiweyo

Xa urekhoda ii-macros, i-Excel ihlala ivelisa i-Sub procedure (kunokuba i-Function procedure). Ukuba unikeze isinqumli se-keyboard kwi-macro, le ndlela imfutshane iya kuba yeyona ndlela ilula yokuqhuba i-macro. Ngaphandle koko, i-macro inokuqhutywa ngokwenza la manyathelo alandelayo:

• Cinezela Alt + F8 (okt cofa iqhosha le-ALT kwaye ngelixa licofa, cofa u-F8) ukubonisa ibhokisi yencoko ye-'Macros';
• Kwibhokisi yencoko ethi "Macro", khetha i-macro ofuna ukuyiqhuba;
• Cofa su Baleka .

Ercole Palmeri