Macros ndi chida chokhazikitsa malamulo mu Microsoft Excel omwe angathe kuchepetsa nthawi yambiri kuti amalize ntchito mwa kupanga zochita. Koma nthawi yomweyo, macros ndi gwero la chiopsezo chomwe chingagwiritsidwe ntchito ndi owukira. Choncho, wogwiritsa ntchito payekha pangozi ndi pangozi ayenera kusankha kugwiritsa ntchito mbaliyi muzochitika zina kapena ayi. Mwachitsanzo, ngati sakudziwa kuti fayilo ikutsegulidwa, ndiye bwino kuti musagwiritse ntchito macros, chifukwa zingayambitse kompyuta kukhala ndi kachilombo koyipa. Chifukwa cha ichi, omanga apereka mwayi kwa wosuta kusankha pa nkhani yothetsera ndi kulepheretsa macros.
Thandizani kapena kulepheretsa macros kupyolera mndandanda wamakono
Tidzakambirana za ndondomeko yothandizira ndi kulepheretsa macros kukhala otchuka kwambiri komanso otchuka masiku ano - Excel 2010. Kenako, tidzakambirana bwino momwe tingachitire izi m'mawu ena a ntchito.
Mutha kuthetsa kapena kusokoneza macros ku Microsoft Excel kupyolera pamasewera osungirako. Koma, vuto liri kuti mwachisawawa mndandanda ukulephereka. Kuti mulowetse, pitani ku tabu "Fayilo". Kenaka, dinani pa chinthu "Zosankha".
Muwindo la magawo lomwe limatsegulira, pitani ku gawo la "Tape Settings". Gawo labwino lawindo la gawo ili, fufuzani bokosi pafupi ndi chinthu "Developer". Dinani pa batani "OK".
Pambuyo pake, tabu ya "Chinsintha" ikuwoneka pa ndodo.
Pitani ku tab "Wolemba". Pa mbali yeniyeni ya tepi ndi bokosi la macros. Kuti mutsegule kapena kuzimitsa macros, dinani pa "Makina Achibwana".
Foda la Security Control Center limatsegula mu gawo la Macros. Kuti mulowetse macros, yesani kusinthana kwa "Lolani malo onse". Komabe, wogwirizirayo sakuvomereza kuti achite izi chifukwa cha chitetezo. Kotero, zonse zimachitidwa pangozi yanu komanso pangozi. Dinani ku batani "OK", yomwe ili kumbali ya kumanja kwawindo.
Macros ali olumala pawindo lomwelo. Koma, pali zinthu zitatu zomwe mungasankhe kuti mutseke, zomwe zimasankhidwa ndi wogwiritsa ntchito malinga ndi chiwopsezo choyembekezeka:
- Khumbitsani macros onse popanda chidziwitso;
- Khumbitsani macros onse ndi chidziwitso;
- Khutsani macros onse kupatula ma macros omasulira.
Pachifukwachi, ma macros omwe adzakhala ndi signature adzagwira ntchito. Musaiwale kusindikiza batani "OK".
Thandizani kapena kulepheretsa macros kudzera pulogalamu
Pali njira ina yowonjezera ndikuletsa ma macros. Choyamba, pitani ku "Fayilo" gawo, ndiyeno dinani pa "Parameters" pakani, monga momwe zilili ndikuphatikizidwa ndi mapulogalamu osungira, omwe tinakambirana pamwambapa. Koma, muwindo lazenera lomwe limatsegulira, sitimapita ku "Zinthu Zopangira Tape", koma ku "Security Management Center". Dinani pa batani "Security Control Center Settings".
Filamu yomweyo ya Security Control Center imatsegukira, yomwe ife tinayendayenda kudzera mndandanda wamasewera. Pitani ku gawo "Makonzedwe a Macro", ndipo pomwepo amathandiza kapena amaletsa macros mofanana ndi momwe anachitira poyamba.
Thandizani kapena musiye ma macros m'mawonekedwe ena a Excel
M'zinenero zina za Excel, njira yothetsera macros ndi yosiyana kwambiri ndi ndondomeko yapamwambayi.
M'mawonekedwe atsopano, koma osawerengeka a Excel 2013, ngakhale pali kusiyana pakati pa mawonekedwe a mawonekedwe, ndondomeko yothandizira ndi kulepheretsa macros ikutsatira ndondomeko yomweyi yomwe inanenedwa pamwambapa, koma kumasulira koyambirira ndi kosiyana kwambiri.
Pofuna kuti mutsegule kapena kusokoneza macros ku Excel 2007, muyenera kungolemba pa Microsoft Office logo kumbali yakumanzere yawindo pazenera, ndiyeno pansi pa tsamba lomwe likutsegula, dinani pa "Options". Pambuyo pake, mawindo a Security Control Center amatsegula, ndipo zina zomwe zingathandize ndikuletsa macros ndi zofanana ndi zomwe zinafotokozedwa ku Excel 2010.
Mu Excel 2007, zangokwanira kudzera zinthu zamkati "Zida", "Macro" ndi "Security". Pambuyo pake, mawindo adzatsegulidwa kumene muyenera kusankha imodzi mwazigawo zotetezera: "Wapamwamba kwambiri," "High", "Medium" ndi "Low". Zigawo izi zimagwirizana ndi macros a matembenuzidwe amtsogolo.
Monga mukuonera, kuphatikiza ma macros m'ma Excel atsopano ndi ovuta kwambiri kuposa momwe zinaliri kumasulira koyambirira. Izi ndizo chifukwa cha ndondomeko ya osungirayo kuti pakhale msinkhu wa chitetezo cha wogwiritsa ntchito. Choncho, macros akhoza kuthandizidwa kokha ndi munthu wogwiritsa ntchito "wamkulu" yemwe amatha kuyesa mosamala zoopsa pazochitika.
