Macros kayan aiki ne don ƙirƙirar ƙungiyoyi a Microsoft Excel, wanda zai iya rage lokacin da ake ɗauka don kammala ayyukan ta hanyar sarrafa tsari. Amma a lokaci guda, macros sune tushen yanayin rauni wanda maharan zasu iya amfani dasu. Sabili da haka, mai amfani a kashin kansa dole ne ya yanke shawarar amfani da wannan fasalin a wani yanayi, ko a'a. Misali, idan bai tabbatar da amincin fayil din da ake bude ba, zai fi kyau kar ayi amfani da macros, saboda zasu iya haifar da cutar kwamfuta da lambar cuta. Ganin wannan, masu haɓakawa sun ba da dama ga mai amfani don yanke shawarar batun kunnawa da kashe kayan macros.
Samu da kuma kashe musros ta hanyar menu na haɓaka
Za mu ba da babbar mahimmanci ga hanya don kunnawa da kuma lalata macros a cikin mafi mashahuri da kuma sigar shirin na yau - Excel 2010. To, bari muyi magana da sauri game da yadda ake yin wannan a cikin sauran sigogin aikace-aikacen.
Kuna iya kunna ko kashe macros a cikin Microsoft Excel ta hanyar menu na haɓakawa. Amma, matsalar ita ce ta ainihi wannan menu ba shi da lafiya. Don kunna shi, je zuwa "Fayil" shafin. Bayan haka, danna kan kayan "Sigogi".
A cikin sigogi na taga wanda zai buɗe, jeka "Sape ɗin tef". A hannun dama na taga wannan sashin, duba akwatin kusa da abun "Mai tasowa". Latsa maɓallin "Ok".
Bayan haka, shafin "Mai haɓaka" ya bayyana akan kintinkiri.
Je zuwa shafin "Mai haɓaka". A cikin ɓangaren dama na tef ɗin shine "toshe katun" Macros ". Don kunna ko kashe macros, danna maɓallin "Macro Tsaro".
Cibiyar Tsaro ta Tsaro tana buɗewa a cikin ɓangaren "Macros". Don kunna macros, juya canji zuwa matsayin "Ba da damar dukkan macros". Gaskiya ne, mai haɓakawa baya bada shawarar wannan matakin don dalilan tsaro. Don haka, duk abin da aka yi shi ne kashin kansa da haɗarin ku. Latsa maɓallin "Ok", wanda ke cikin ƙananan kusurwar dama na taga.
Hakanan an lalata Macros a wannan taga. Amma, akwai zaɓuɓɓuka masu rufewa uku, ɗayan wanda dole ne mai amfani ya zaɓa daidai da matakin haɗarin:
- Musaki duk macros ba tare da sanarwa ba;
- Musaki duk macros tare da sanarwa;
- A kashe duk macros sai dai macro da aka sanya hannu cikin digotally.
A cikin batun na ƙarshe, macros da za a sanya hannu a cikin lambobi zai iya yin ayyuka. Kar a manta danna maballin "Ok".
Samu da kashewa macros ta hanyar sigogi
Akwai kuma wata hanyar da za'a kunna da kuma kashe macros. Da farko dai, je sashin "Fayiloli", sannan a can ne muke danna maballin "Zaɓuɓɓuka", kamar yadda akan yanayin kunna menu na mai haɓakawa, kamar yadda muka tattauna a sama. Amma, a cikin sigogi na taga wanda zai buɗe, ba za mu shiga cikin abun “Ribbon Saitin” ba, amma zuwa wurin “Cibiyar Kula da Tsaro”. Danna maballin "Saiti na cibiyar kula da tsaro."
Wannan taga na Trust ɗin yana buɗewa, wanda muke shiga cikin menu na haɓakawa. Muna zuwa sashin "Macro Saiti", kuma a can muna kunna ko musaki macros kamar yadda muka yi a baya.
Kunna ko kashe macros a cikin wasu sigogin Excel
A cikin wasu juzu'in na Excel, hanya don lalata macros ya ɗan bambanta da na bayanan algorithm ɗin da ke sama.
A cikin sabo, amma ƙaramar juzu'a ce ta 2013 2013, duk da wasu bambance-bambance a cikin dubawar aikace-aikacen, hanya don kunnawa da kashe macros yana bin tsarin ɗaya kamar yadda aka bayyana a sama, amma a sigogin farko sun bambanta da ɗan kaɗan.
Domin kunna ko kashe macros a cikin Excel 2007, dole ne ka danna alamar Microsoft Office kai tsaye a saman kusurwar hagu na taga, sannan ka danna maballin "Zaɓuɓɓuka" a kasan shafin da yake buɗe. Na gaba, taga Cibiyar Kula da Tsaro yana buɗewa, kuma matakai na gaba don kunnawa da kashe macros kusan babu bambanci da waɗanda aka ambata na Excel 2010.
A fasalin na Excel 2007, ya isa a sauƙaƙe zuwa gaba ɗaya ta cikin abubuwan menu "kayan aikin", "Macro" da "Tsaro". Bayan haka, taga zai buɗe wanda kake buƙatar zaɓar ɗayan matakan tsaro na macro: "Mafi Girma", "Maɗaukaki", "Matsakaici" da "ƙananan". Waɗannan sigogi sun dace da abubuwan babban macro na sigogin ƙarshe.
Kamar yadda kake gani, ba da damar macros a cikin sababbin juzu'ai na Excel mafi rikitarwa fiye da yadda aka yi a cikin sigogin aikace-aikacen da suka gabata. Wannan ya faru ne saboda manufar mai haɓakawa don inganta tsaron mai amfani. Don haka, macros za a iya haɗa shi ta hanyar mai amfani ko "less“ ci gaba ”wanda zai iya kimanta haƙiƙar haɗari daga ayyukan da aka ɗauka.
