Ungawavula kanjani futhi ukhubaze ama-macros ku-Excel

Ngosizo lwama-macros ku-Excel, imiyalo ekhethekile isethiwe, ngenxa yokuthi ungakwazi ukuzenzela eminye imisebenzi futhi, ngaleyo ndlela, unciphise kakhulu isikhathi esichithwa emsebenzini. Kodwa-ke, ama-macros asengozini yokuhlaselwa kwama-hacker futhi angaba yingozi. Kufanele kukhunjulwe ukuthi bathwala usongo oluthile, futhi abahlaseli bangasebenzisa lokhu. Isinqumo ngesidingo sokuzisebenzisa kufanele senziwe, kucutshungulwe icala ngalinye elithile.

Isibonelo, uma umsebenzisi engaqiniseki ngokuvikeleka kwedokhumenti evuliwe, kungaba ngcono ukwenqaba ama-macros, njengoba ifayela lingase libe nekhodi yegciwane. Abathuthukisi bohlelo bayalicabangela leli qiniso futhi banikeze umsebenzisi ukukhetha. Kungakho i-Excel inomsebenzi wokusetha ama-macros, noma kunalokho, umsebenzi wawo.

Ukwenza kusebenze nokuvala amamakhro kuthebhu kanjiniyela

Kuhle ukuqaphela ngokushesha ukuthi ngesikhathi sokwenza lo msebenzi, abanye abasebenzisi bangase bahlangabezane nobunzima. Lokhu kungenxa yokuthi ithebhu ethi "Unjiniyela" ivaliwe ngokuzenzakalelayo futhi, okokuqala, udinga ukuyivula.

1. Chofoza kwesokunxele kumenyu ethi "Ifayela".
2. Bese, ezansi kohlu lokudonsela phansi, khetha into ethi "Izinketho".
3. Kumapharamitha wohlelo, sinentshisekelo entweni ethi "Ukusethwa kweRibhoni". Okulandelayo, maka ibhokisi eliseduze kwethebhu ethi “Unjiniyela”. Manje siqinisekisa isenzo ngokucindezela inkinobho ethi OK.

Ngemva kokuqeda lezi zinyathelo, ithebhu kanjiniyela izosebenza. Manje ungaqala ukunika amandla ama-macros.

1. Chofoza kuthebhu ethi “Developer”. Ekhoneni elingakwesokunxele kuzoba nesigaba esidingekayo, lapho sicindezela inkinobho ethi "Ukuphepha Okukhulu" ngendlela yophawu lwesibabazo.
2. Ewindini lezilungiselelo elivelayo, ungavula wonke ama-macros ngesikhathi esisodwa. Ukuze wenze lokhu, khetha inketho ethi "Vumela wonke ama-macros" kuzo zonke izinketho ezihlongozwayo. Ngokucindezela inkinobho ethi "KULUNGILE", siqinisekisa izinguquko ezenziwe futhi siphume kumapharamitha.Kodwa-ke, kufanele unake iqiniso lokuthi abathuthukisi beMicrosoft abakuncomi ukukhetha le nketho, njengoba kungenzeka ukuthi usebenzise uhlelo oluyingozi olungalimaza ikhompuyutha yakho. Ngakho-ke, lapho wenza lo msebenzi, khumbula ukuthi uzenzela wena engozini nangengozi.

Ivala amamakhro kwenzeka ebhokisini lengxoxo elifanayo. Kodwa-ke, lapho uvala, umsebenzisi uzokwaziswa ngezinketho ezintathu ngesikhathi esisodwa ngamazinga ahlukahlukene okuphepha.

Njengoba igama lisho, kunketho ephansi kakhulu, wonke ama-macros anesignesha yedijithali azosebenza kahle. Futhi ezintweni ezimbili zokuqala ongakhetha kuzo, zizokhutshazwa ngokuphelele. Ngemuva kokuthi senze ukukhetha, sicindezela inkinobho ethi OK.

Ilungiselela ama-Macros kuzinketho zohlelo

1. Siya kumenyu ethi "Ifayela", bese ukhetha into ethi "Izinketho" kuyo - efana nento yokuqala esibonelweni esikhulume ngayo ngaphambili.
2. Kodwa manje, esikhundleni sezilungiselelo zeribhoni, khetha isigaba "Isikhungo Sokuthemba". Engxenyeni engakwesokudla yewindi, chofoza inkinobho ethi “Izilungiselelo Zesikhungo Sokuthemba …”
3. Ngenxa yalokho, uhlelo luzosiqondisa efasiteleni lezilungiselelo ze-macro, elibuye lavulwa lapho kwenziwa umsebenzi kuthebhu kanjiniyela. Okulandelayo, khetha inketho esiyidingayo bese uchofoza "OK".

Ukusetha ama-macros ezinguqulweni zangaphambili ze-Excel

Ezinguqulweni zangaphambili zohlelo, ama-macro enziwe asebenza futhi angasebenzi ngendlela ehlukile.

Isibonelo, i-algorithm yezenzo ezinhlelweni zika-2010 nabancane iyafana, kodwa kunomehluko othile esibonakalayo sohlelo.

Futhi ukuze uvule noma uvale amamakhro enguqulweni ka-2007, udinga ukuchofoza isithonjana se-Microsoft Office ekhoneni eliphezulu kwesokunxele. Ngemuva kwalokho, udinga ukuthola ingxenye ethi "Izilungiselelo" ngezansi kwekhasi elivulayo. Ngokuchofoza ingxenye ethi "Izilungiselelo", sizofika ku-Trust Center. Okulandelayo, sidinga Izilungiselelo ze-Trust Center futhi, ngenxa yalokho, ngokuqondile, izilungiselelo ze-macro ngokwazo.

Isiphetho

Ngokukhubaza ama-macros, onjiniyela bazama ukuvikela abasebenzisi ezingozini ezingaba khona. Nokho, kwezinye izimo, zisadinga ukuvunyelwa. Kuye ngenguqulo yohlelo, futhi ngisho nakunguqulo efanayo, lokhu kungenziwa ngendlela ehlukile. Kodwa kungakhathaliseki ukuthi iyiphi indlela ekhethiwe, inqubo ilula futhi ayidingi ulwazi olujulile namakhono ekusebenzeni nge-PC.