Momwe mungayambitsire ndikuletsa macros mu Excel

Mothandizidwa ndi macros mu Excel, malamulo apadera amakhazikitsidwa, chifukwa chake mutha kusintha ntchito zina, potero, kuchepetsa kwambiri nthawi yogwira ntchito. Komabe, ma macros ali pachiwopsezo cha owononga ndipo ndi owopsa. Tiyenera kukumbukira kuti amanyamula chiwopsezo china, ndipo owukira angagwiritse ntchito mwayiwu. Chigamulo chofuna kuzigwiritsa ntchito chiyenera kupangidwa, kupenda nkhani iliyonse.

Mwachitsanzo, ngati wosuta sakudziwa za chitetezo cha chikalata chotsegulidwa, zingakhale bwino kukana macros, chifukwa fayiloyo ikhoza kukhala ndi code virus. Okonza mapulogalamu amaganizira izi ndikupatsa wogwiritsa ntchito kusankha. Ichi ndichifukwa chake Excel ili ndi ntchito yoyika ma macros, kapena m'malo mwake, ntchito zawo.

Kuyambitsa ndi kuyimitsa ma macros mu tabu Yopanga Mapulogalamu

Ndikoyenera kudziwa nthawi yomweyo kuti pochita ntchitoyi, ogwiritsa ntchito ena amatha kukumana ndi zovuta. Izi ndichifukwa choti tabu ya "Developer" imazimitsidwa mwachisawawa ndipo, choyamba, muyenera kuyiyambitsa.

1. Dinani kumanzere pa "Fayilo" menyu.
2. Kenako, pansi pa mndandanda wotsitsa, sankhani chinthu cha "Zosankha".
3. Pazigawo za pulogalamuyo, tili ndi chidwi ndi chinthu cha "Ribbon Setup". Kenako, chongani bokosi pafupi ndi "Developer" tabu. Tsopano tikutsimikizira zomwe zikuchitikazo ndikukanikiza batani la OK.

Mukamaliza masitepe awa, tabu ya Madivelopa idzatsegulidwa. Tsopano mutha kuyamba kuyambitsa ma macros.

1. Dinani pa "Developer" tabu. Pakona yakumanzere padzakhala gawo lofunikira, pomwe timakanikiza batani la "Macro Security" mwanjira yachidziwitso.
2. Pazenera la zoikamo lomwe likuwoneka, mutha kuyambitsa ma macro onse nthawi imodzi. Kuti muchite izi, sankhani "Yambitsani ma macros onse" pazosankha zonse zomwe mukufuna. Mwa kukanikiza batani "Chabwino", timatsimikizira zosintha zomwe zasinthidwa ndikutuluka magawo.Komabe, muyenera kulabadira mfundo yakuti Madivelopa Microsoft samalimbikitsa kusankha njira, chifukwa pali zotheka kuyendetsa pulogalamu yoopsa yomwe ingawononge kompyuta yanu. Chifukwa chake, pochita opareshoni iyi, kumbukirani kuti mumachita mwangozi komanso pachiwopsezo chanu.

Kuletsa ma macros zimachitika mu dialog box yomweyo. Komabe, pozimitsa, wogwiritsa ntchitoyo adzapatsidwa zosankha zitatu nthawi imodzi ndi magawo osiyanasiyana achitetezo.

Monga momwe dzinalo likusonyezera, mu njira yotsika kwambiri, ma macros onse omwe ali ndi siginecha ya digito adzagwira ntchito bwino. Ndipo muzosankha ziwiri zoyambirira, iwo adzakhala olumala kwathunthu. Tikapanga chisankho, tikanikiza batani la OK.

Kukonza Macros mu Zosankha za Pulogalamu

1. Timapita ku "Fayilo" menyu, ndikusankha chinthu cha "Zosankha" mmenemo - mofanana ndi chinthu choyamba mu chitsanzo chomwe chinakambidwa kale.
2. Koma tsopano, m'malo mwa makonda a riboni, sankhani gawo la "Trust Center". Kumanja kwa zenera, dinani batani "Trust Center Settings ..."
3. Zotsatira zake, dongosololi lititsogolera ku zenera la zoikamo zazikulu, zomwe zidatsegulidwanso pochita ntchitoyi mu tabu ya Developer. Kenako, sankhani zomwe tikufuna ndikudina "Chabwino".

Kukhazikitsa macros m'mitundu yakale ya Excel

M'mitundu yakale ya pulogalamuyi, ma macros adatsegulidwa ndikuzimitsa mosiyana.

Mwachitsanzo, ma aligorivimu a zochita mu mapulogalamu a 2010 ndi aang'ono ndi ofanana, koma pali kusiyana zina mu mawonekedwe a pulogalamu.

Ndipo kuti muyambitse kapena kuyimitsa ma macros mu mtundu wa 2007, muyenera dinani chizindikiro cha Microsoft Office pakona yakumanzere kumanzere. Pambuyo pake, muyenera kupeza gawo la "Zikhazikiko" pansi pa tsamba lomwe limatsegula. Mwa kuwonekera pa gawo la "Zikhazikiko", tifika ku Trust Center. Chotsatira, tifunika Zokonda za Trust Center ndipo, chifukwa chake, mwachindunji, zosintha zazikulu zokha.

Kutsiliza

Poletsa ma macros, opanga akuyesera kuteteza ogwiritsa ntchito ku zoopsa zomwe zingachitike. Komabe, nthawi zina, amafunikabe kuyatsidwa. Kutengera mtundu wa pulogalamuyo, ndipo ngakhale mumtundu womwewo, izi zitha kuchitika mosiyana. Koma mosasamala kanthu za njira yosankhidwa, ndondomekoyi ndi yosavuta ndipo sikutanthauza chidziwitso chakuya ndi luso logwira ntchito ndi PC.