IMacros iyithuluzi lokwakha amaqembu eMicrosoft Excel, enganciphisa kakhulu isikhathi esithathayo ukuqeda imisebenzi ngokwenza inqubo ezenzakalelayo. Kepha ngasikhathi sinye, ama-macros angumthombo wobungozi obungasetshenziswa abahlaseli. Ngakho-ke, umsebenzisi osengozini yakhe kufanele anqume ukusebenzisa lesi sici esimweni esithile, noma cha. Isibonelo, uma engenaso isiqiniseko sokwethenjwa kwefayela elivuliwe, kungcono ukungasebenzisi ama-macros, ngoba angenza ukuthi ikhompyutha itheleleke ngekhodi enobungozi. Ngokunikezwe lokhu, abathuthukisi banikeze ithuba lomsebenzisi lokuthatha isinqumo sokwenza amandla nokukhubaza ama-macros.
Ukunika amandla nokukhubaza ama-macros ngokusebenzisa imenyu kanjiniyela
Sizogxila kakhulu kwinqubo yokunika amandla nokukhubaza ama-macro kuhlelo oludumile nolusakazekile lohlelo namuhla - Excel 2010. Ngemuva kwalokho, ake sixoxe masisha ngokwazi ukuthi ungakwenza kanjani lokhu kwezinye izinhlobo zohlelo lokusebenza.
Ungavumela noma ukhubaze ama-macros ku-Microsoft Excel ngemenyu kanjiniyela. Kepha, inkinga ukuthi ngokuzenzakalelayo le menyu ikhutshaziwe. Ukuze uyinike amandla, iya kuthebhu "yefayela". Okulandelayo, chofoza entweni "Yamapharamitha".
Ewindini lemingcele elivulayo, iya kusigaba se- "Tape izilungiselelo". Engxenyeni engakwesokudla yewindi lalesi sigaba, hlola ibhokisi eliseduze kwento ethi "kanjiniyela". Chofoza inkinobho ethi "Kulungile".
Ngemuva kwalokho, ithebhu "Yonjiniyela" ivela ku-riboni.
Iya kuthebhu "kanjiniyela". Engxenyeni engakwesokudla kwetheyiphu kuvimba izilungiselelo ze- "Macros". Ukuze unike amandla noma ukhubaze ama-macros, chofoza inkinobho ethi "Macro Security".
Iwindi Lokulondeka Kwezokuphepha livula engxenyeni ethi "Macros". Ukuze unike amandla ama-macros, shintshela switch ku "Nika amandla wonke ama-macros" isikhundla. Kuliqiniso, unjiniyela asincomi lesi senzo ngezinhloso zokuphepha. Ngakho-ke, konke kwenziwa ngokwengozi nangengozi yakho. Chofoza inkinobho "OK", etholakala ekhoneni elingezansi kwesokudla kwewindi.
AmaMacros akhubazekile ewindini elifanayo. Kepha, kunezindlela ezintathu zokuvala, enye yazo umsebenzisi okufanele azikhethe ngokuya ngezinga elilindelekile lobungozi:
- Khubaza wonke ama-macros ngaphandle kwesaziso;
- Khubaza wonke ama-macros ngesaziso;
- Khubaza wonke ama-macros ngaphandle kwama-macros asayiniwe ngokwedijithali.
Endabeni yokugcina, ama-macros azosayinwa ngokwedijithali azokwazi ukwenza imisebenzi. Ungakhohlwa uchofoze inkinobho ethi "Kulungile".
Ukunika amandla nokukhubaza ama-macros ngokusebenzisa amapharamitha wohlelo
Kukhona enye indlela yokuvumela nokukhubaza ama-macros. Okokuqala, siya engxenyeni ethi "Ifayela", bese sichofoza inkinobho ethi "Izinketho", njengasesimweni sokuvula imenyu kanjiniyela, njengoba sixoxe ngenhla. Kepha, ewindini lemingcele elivulayo, ngeke siye entweni ethi “Ribbon izilungiselelo”, kodwa entweni ye- “Security Center Center”. Chofoza inkinobho "Izilungiselelo zesikhungo sokulawula ukuphepha."
Iwindows efanayo yeSikhungo Sokwethemba iyavula, esiya kuyo ngemenyu kanjiniyela. Saya engxenyeni ethi "Izilungiselelo zeMacro", futhi lapho sivumela noma sikhubaza ama-macro ngendlela efanayo esenze ngayo okokugcina.
Vula noma vala ama-macros kwezinye izinhlobo ze-Excel
Kwezinye izinhlobo ze-Excel, inqubo yokukhubaza ama-macros ngandlela-thile ihlukile kune-algorithm engenhla.
Kuhlobo olusha, kepha olujwayelekile kakhulu lwe-Excel 2013, ngaphandle komehluko othile kuhlelo lokusebenza, inqubo yokunika amandla nokukhubaza i-macros ilandela i-algorithm efanayo njengoba kuchaziwe ngenhla, kepha ezinguqulweni zangaphambili zihlukile kancane.
Ukuze unike amandla noma ukhubaze ama-macros ku-Excel 2007, kufanele uchofoze ngokushesha uphawu lweMicrosoft Office ekhoneni eliphezulu kwesobunxele lewindi, bese uqhafaza inkinobho ethi "Izinketho" ezansi kwekhasi elivulayo. Okulandelayo, iwindi lokuvikeleka kwesikhungo sezokuphepha liyavuleka, kanti nezinyathelo ezilandelayo zokunika amandla nokukhubaza ama-macros empeleni azifani nalezo ezichazwe nge-Excel 2010.
Kuhlobo lwe-Excel 2007, kwanele ukumane uhambe ngokulandelana kwezinto zemenyu "Amathuluzi", "Macro" no "Security". Ngemuva kwalokho kuzovuleka iwindi lapho kufanele ukhethe khona elinye lamazinga okuphepha macro: "Phezulu kakhulu", "Phezulu", "Medium" ne "Low". Lawa parameter ahambelana nezinto ze-parro macro zezinguqulo zakamuva.
Njengoba ukwazi ukubona, ukunika amandla ama-macros ezinguqulo zakamuva ze-Excel kuyinkimbinkimbi kakhulu ukwedlula njengoba bekunguhlobo langaphambilini lwesicelo. Lokhu kungenxa yenqubomgomo kanjiniyela yokwandisa ukuphepha kwabasebenzisi. Ngakho-ke, ama-macros angafakwa kuphela umsebenzisi noma "ongaphezulu" ongaphezulu kakhulu noma ongakwazi ukuhlola ubungozi ezenzweni ezithathiwe.
