Excel Amamakhro - wokukusindisa kwesikhathi

Ku-Excel, iZwi Namandla Point, ungakha ithimba lakho siqu, okuthiwa ama-macros. Bona ngokuzenzakalelayo ukukhishwa umsebenzi ojwayelekile, uma ku njalo zisetshenziswe umbhalo noma amaseli i-design efanayo, ukwethula amasethi ezifanayo amafomula, njll Empeleni, ama-macros - izinhlelo ezincane, nomlando wabo senziwa Visual izikripthi Eyisisekelo. Nokho, ngisho kude isofthiwe, umsebenzisi kalula ukudala futhi uwahlele.

Ezisetshenziswa kakhulu-Excel amamakhro. Ngosizo lwabo, ungakha amadokhumenti, ngisho yokubala, isibonelo, ukubala isabelomali sanyanga zonke lenkampani.

irekhodi Macro

Dala Macro ngezindlela ezimbili. Okokuqala - ukubhala iskripthi VB kusuka ekuqaleni. Ngakho program ukukwenza. Indlela yesibili lula: kubalulekile ukufaka irekhodi zonke izenzo ngendlela rekhoda akhethekile kanye nje ukwenza izinqubo ofuna ukushintsha.

Ake sicabangele indlela ukurekhoda amamakhro Excel 2007 usebenzisa makrorekordera (indlela yesibili). Amathuluzi adingekayo ku "Developer" ithebhu. Kusukela ithebhu ezenzakalelayo ngokuvamile akubonakali, kuzomele uqale ukuya lokusebenza lezilungiselelo. Ukuze wenze lokhu, vula inkinobho round nge logo Microsoft bese ukhetha «Izinketho Excel". I "Izilungiselelo zangasese", "Izilungiselelo Basic ...", setha mark ngokumelene nto, unesibopho ukubonisa ithebhu oyifunayo.
Ukuze wenze le-Excel elisha amamakhro, uzodinga okulandelayo:

• Chofoza "Developer"> "Ikhodi"> "Qopha Macro".
• Bhala phansi igama, okuyindawo kuyoba sobala ukuthi Macro enza.
• Khetha ezifanele sekhibhodi ukufinyelela ngokushesha Macro (ayinayo likhiqize okhiye bakho ashisayo Balisebenzisa-Windows, isibonelo, CTRL + C / CTRL V ).
• Uhla "Londoloza ..." unesibopho kwenkululeko Macro. Ukuze Excel yakho amamakhro ukusebenza kuwo wonke amadokhumenti wavula kule khompyutha, ukhethe "Incwadi Siqu".
• Gcwalisa incazelo (uhlu zonke izenzo eqoshiwe).
• Ukuqala ukurekhoda, chofoza "OK". Isithonjana sizovela ekhoneni kwesikrini.
• Yenza izenzo ezidingekayo nge amaseli.
• Chofoza "Stop Ukuqopha" kuthebhu "kunjiniyela"> "Ikhodi".

Qaphela: le-Excel amamakhro bangakhumbula isihlobo noma ngokuphelele iseli amareferensi. Uma ungazange ukhethe ezifanele, ngesikhathi ukurekhoda Macro Uzokhumbula ukuthi izenzo kudingeka sisisebenzise yeseli oyikhethile. Uma une ukusebenza amaseli ahlukene, khetha inketho mayelana isixhumanisi isihlobo.

Ukusebenza imenyu isicelo (ukushintshwa kwethebhu) futhi ushintshe kwezinye amawindi mibhalo angeke iqoshwe.

Amasethingi ezokuphepha

Naphezu isiqiniseko sokuthi isicelo ingakwazi ukulawula amamakhro ikhodi enonya, it is hhayi Kunconywa ukuthatha ke kwavela emthonjeni engathembekile. Ngokwesibonelo, download ngomumo eyenziwe kusukela Inthanethi. Ungakwazi uthemba umbono anti-virus, futhi amamakhro esetshenziswa kumakhompyutha amaningi ehhovisi, kutuswa ukuba unikeze isignisha yezinombolo.

Ngokuzenzakalelayo, ukusetshenziswa amamakhro kumadokhumenti kuvame zikhutshaziwe. Nika amandla i-Excel amamakhro kungaba, uma uya kwi-tab "Unjiniyela" kanye "Ikhodi"> "zokuphepha ze-Macro"> "Izilungiselelo Macro"> "Nika amandla wonke"> "Kulungile." Izinguquko zizosebenza ngesikhathi esilandelayo uma uvule ifayela.