Maitiro ekugonesa uye kudzima macros muExcel

Nerubatsiro rwemacros muExcel, mirairo yakakosha inoiswa, nekuda kwaunokwanisa kuita otomatiki mamwe mabasa uye, nekudaro, kuderedza zvakanyanya nguva inoshandiswa pabasa. Nekudaro, macros ari panjodzi yekurwiswa kwehacker uye anogona kuve nengozi. Izvo zvinofanirwa kuyeukwa kuti vanotakura kumwe kutyisidzira, uye vanorwisa vanogona kutora mukana weizvi. Chisarudzo pamusoro pekudikanwa kwekuzvishandisa chinofanira kuitwa, kuongorora nyaya imwe neimwe chaiyo.

Semuenzaniso, kana mushandisi asina chokwadi nezve kuchengetedzwa kwegwaro rakavhurwa, zvingava nani kuramba macros, sezvo faira inogona kunge iine kodhi yehutachiona. Vagadziri vezvirongwa vanotora chokwadi ichi uye vanopa mushandisi sarudzo. Ndokusaka Excel iine basa rekuseta macros, kana kuti, basa ravo.

Kuita uye kudzima macros muDeveloper tab

Zvinokosha kucherechedza kuti mukuita basa iri, vamwe vashandisi vanogona kusangana nematambudziko. Izvi zvinokonzerwa nekuti iyo "Developer" tab inodzimwa nekukasira uye, kutanga, iwe unofanirwa kuimisa.

1. Tinya kuruboshwe pane "Faira" menyu.
2. Zvadaro, pazasi pechinyorwa chekudonha, sarudza chinhu che "Options".
3. Mune zvirongwa zvepurogiramu, isu tinofarira chinhu che "Ribbon Setup". Tevere, tarisa bhokisi riri padivi pe "Developer" tab. Zvino isu tinosimbisa chiito nekudzvanya bhatani OK.

Pakupera kwematanho aya, iyo Developer tab ichaitwa. Iye zvino unogona kutanga kugonesa macros.

1. Dzvanya pane "Developer" tab. Mukona yekuruboshwe pachava nechikamu chinodiwa, patinodzvanya bhatani re "Macro Security" muchimiro chechiratidzo chekudanidzira.
2. Muwindo rezvirongwa rinoonekwa, unogona kumisa macros ese kamwechete. Kuti uite izvi, sarudza "Gonesa macros ese" sarudzo kubva pane zvese zvakarongwa sarudzo. Nekudzvanya bhatani re "OK", tinosimbisa shanduko dzakaitwa uye kubuda ma parameter.Nekudaro, iwe unofanirwa kuteerera kune chokwadi chekuti Vagadziri veMicrosoft havakurudzire kusarudza iyi sarudzo, sezvo paine mukana wekumhanyisa chirongwa chine njodzi chinogona kukuvadza komputa yako. Naizvozvo, kana uchiita oparesheni iyi, yeuka kuti unoita panjodzi yako uye nenjodzi.

Deactivating macros zvinoitika mubhokisi renhaurirano rimwechete. Nekudaro, kana uchidzima, mushandisi anokurudzirwa nesarudzo nhatu kamwechete dzine madhigirii akasiyana ekuchengetedza.

Sezvinoreva zita, mune yakaderera sarudzo, ese macros ane siginecha yedhijitari achashanda nemazvo. Uye mune yekutanga sarudzo mbiri, ivo vachave vakaremara zvachose. Mushure mekunge taita sarudzo, tinodzvanya bhatani OK.

Kugadzirisa Macros mune Zvirongwa zvePurogiramu

1. Tinoenda kumenyu ye "Faira", uye sarudza chinhu che "Options" mairi - zvakafanana nechinhu chekutanga mumuenzaniso wakambokurukurwa.
2. Asi ikozvino, panzvimbo yezvirongwa zveribhoni, sarudza chikamu che "Trust Center". Muchikamu chekurudyi chehwindo, tinya bhatani "Trust Center Settings ..."
3. Nekuda kweizvozvo, iyo sisitimu inozotitungamira kune macrosetting hwindo, iro rakavhurwa zvakare pakuita oparesheni muDeveloper tab. Zvadaro, sarudza sarudzo yatinoda uye tinya "OK".

Kumisikidza macros mumavhezheni ekutanga eExcel

Mune shanduro dzekutanga dzechirongwa, macros akamiswa uye akamiswa zvakasiyana.

Semuenzaniso, iyo algorithm yezviito muzvirongwa zve2010 uye mudiki yakafanana, asi pane mimwe misiyano muchirongwa chechirongwa.

Uye kuti uvhure kana kudzima macros mune 2007 vhezheni, unofanirwa kudzvanya paMicrosoft Office icon mukona yekuruboshwe. Mushure meizvozvo, iwe unofanirwa kuwana iyo "Settings" chikamu pazasi peji inovhura. Nekudzvanya pane "Settings" chikamu, isu tichasvika kuTrust Center. Tevere, isu tinoda Zvirongwa zveTrust Center uye, semhedzisiro, zvakananga, iwo macro marongero pachavo.

mhedziso

Nekudzima macros, vanogadzira vari kuyedza kuchengetedza vashandisi kubva kune njodzi dzinogona kuitika. Nekudaro, mune zvimwe zviitiko, ivo vachiri kufanira kugoneswa. Zvichienderana neshanduro yepurogiramu, uye kunyange mune imwe shanduro, izvi zvinogona kuitwa zvakasiyana. Asi zvisinei nenzira yakasarudzwa, maitiro acho ari nyore uye haadi ruzivo rwakadzama uye hunyanzvi mukushanda nePC.