I-Macros iyithuluzi lokudala imiyalo e-Microsoft Excel enganciphisa kakhulu isikhathi sokuqedela imisebenzi ngokuzenzakalela inqubo. Kodwa ngesikhathi esifanayo, ama-macros angumthombo wobungozi obungasetshenziswa yizihlaseli. Ngakho-ke, umsebenzisi engozini yakhe futhi engozini kufanele anqume ukusebenzisa lesi sici esimweni esithile noma cha. Isibonelo, uma engaqiniseki ngokuthembeka kwefayela evuliwe, kungcono ukuthi ungasebenzisi ama-macros, ngoba angabangela ikhompiyutha ukuba iphathwe ngekhodi enonya. Njengoba kunikezwe lokhu, abathuthukisi banikeze ithuba lomsebenzisi ukunquma umbuzo wokuvumela nokukhubaza ama-macros.
Vumela noma ukhubaza ama-macros kumenyu yonjiniyela
Sizogxila enkambisweni yokuvumela nokukhubaza ama-macros ethandwa kakhulu futhi adumile kwenguqulo yanamuhla yalolu hlelo - i-Excel 2010. Khona-ke, sizokhuluma ngokushelela ngendlela yokwenza lokhu kwezinye izinguqulo zesicelo.
Unganika amandla noma ukhubaza ama-macros ku-Microsoft Excel ngokusebenzisa imenyu yonjiniyela. Kodwa, inkinga ukuthi ngokuzenzakalelayo le menyu ikhutshaziwe. Ukuze uyinike amandla, iya kuthebhu ethi "Ifayela". Okulandelayo, chofoza into "Izinketho".
Ewindini yemingcele evulwayo, iya kusigaba se "Tape Settings". Ngakwesokudla kwefasitela kwalesi sigaba, hlola ibhokisi eceleni kwento "Developer". Chofoza inkinobho ethi "Kulungile".
Ngemuva kwalokho, ithebhu ye- "Developer" ivela ku-ribbon.
Iya kuthebhu "Developer". Ngakwesokudla kakhulu kwe-tape yibhokisi lezinhlelo ze-Macros. Ukuze unike amandla noma ukhubaza ama-macros, chofoza inkinobho "ye-Macro Security".
Iwindi yeSikhungo Sokulawula Ukuphepha sivula esigabeni se-Macros. Ukuze unike amandla ama-macros, hambisa ukushintshela ku-"Vumela wonke amandla we-macros". Noma kunjalo, unjiniyela akasincoma ukwenza lesi senzo ngezizathu zokuphepha. Ngakho, konke kwenziwa ngengozi yakho siqu futhi kuyingozi. Chofoza inkinobho ethi "Kulungile", etholakala ekhoneni elingaphansi kwesokudla kwewindi.
I-Macros nayo ikhutshaziwe ewindini elifanayo. Kodwa, kunezinketho ezintathu zokuvala, okunye okumele umsebenzisi akhethe ngokuvumelana nezinga elibhekele ingozi:
- Khubaza zonke ama-macros ngaphandle kwesaziso;
- Khubaza wonke ama-macros ngesaziso;
- Khubaza zonke ama-macros ngaphandle kwama-macros asayinwe ngamakhodi.
Esikhathini esilandelayo, ama-macros azoba nesignesha yedijithali azokwazi ukwenza imisebenzi. Ungakhohlwa ukucindezela inkinobho ethi "Kulungile".
Nika amandla noma khubaza ama-macros ngezilungiselelo zohlelo
Kukhona enye indlela yokunika amandla futhi ukhubaza ama-macros. Okokuqala, hamba kusigaba "Ifayela", bese uchofoza inkinobho ethi "Parameters", njengokungathi kufakwa imenyu yonjiniyela, esiyikhulume ngenhla. Kodwa, efasiteleni lemingcele evulekayo, asiya ku "Into yezilungiselelo zeTayipi", kodwa ku-"Isikhungo Sokuphathwa Kwezokuphepha". Chofoza ku-"Isilungiselelo Sokulawula Isikhungo Sezokuphepha".
Ifasitela elifanayo le-Control Control Center livula, esasihamba nge-menu yonjiniyela. Iya esigabeni "Izilungiselelo ze-Macro", futhi lapho kunika amandla noma kukhubaza ama-macros ngendlela efanayo nangesikhathi esedlule.
Vumela noma ukhubaza ama-macros kwezinye izinguqulo ze-Excel
Kwezinye izinguqulo ze-Excel, inqubo yokukhubaza ama-macros ihluke ngokungafani ne-algorithm engenhla.
Ku-version entsha, kodwa engavamile kakhulu ye-Excel 2013, naphezu kokungaboni ngaso isikhombimsebenzisi sohlelo lokusebenza, inqubo yokuvumela nokukhubaza ama-macros kulandela i-algorithm efanayo echazwe ngenhla, kodwa izinguqulo zangaphambili zihlukile ngokuhlukile.
Ukuze unike amandla noma ukhubaza ama-macros ku-Excel 2007, udinga nje ukuchofoza kwi-logo ye-Microsoft Office engxenyeni engenhla kwesokunxele ewindini, bese ubheke phansi kwekhasi elivula, chofoza inkinobho ethi "Izinketho". Okulandelayo, iwindi le-Control Control Center livula, futhi izinyathelo ezengeziwe zokunika amandla nokukhubaza ama-macros ziyafana nokuchazwa ku-Excel 2010.
Ku-Excel 2007, kwanele nje ukuhamba ngokusebenzisa izinto zemenyu "Amathuluzi", "Macro" no "Ukuphepha". Emva kwalokho, ifasitela lizovula lapho okudingayo ukhethe elinye lamazinga wokuvikela okuphezulu: "Okuphakeme kakhulu", "Okuphezulu", "Okuphakathi" nelithi "Okuphansi". Lezi ziminganiso zihambisana nama-macros wezinguqulo zakamuva.
Njengoba ubona, ukufaka ama-macros kuzihumusho zakamuva ze-Excel kunzima kakhulu kunalokho okwakushiwo izinguqulo zangaphambilini zesicelo. Lokhu kubangelwa inqubomgomo yonjiniyela ukuze kwandiswe izinga lokuphepha lomsebenzisi. Ngakho-ke, ama-macros anganikwa amandla kuphela ngumsebenzisi ongaphezulu noma ngaphansi "othuthukile" okwazi ukuhlola ngeso lengqondo izingozi ezenzweni ezenziwe.
