Lub macro yog cov program me me hauv kev siv ntau yam los ntawm games mus rau office office. Nrog kev pabcuam ntawm macros, koj tuaj yeem hloov kho kom sai dua, pab txhawb thiab ua haujlwm nrog koj lub khoos phis tawm kom yooj yim dua. Piv txwv, hauv Excel qhov xwm txheej, koj yuav tsum tau ua ib puas yam. Qhov no tuaj yeem ua tau manually, siv sijhawm ntau, lossis nws tuaj yeem siv tshuab. Nws yog rau lub hom phiaj no uas macros tau siv - microprograms, rau kev tsim cov uas koj tsis tas yuav paub siv lub cajmeem.
Cov Lus Qhia
Kauj ruam 1
Pib Excel. Thaum lub rooj qhib, nyem rau khawm "Kev pabcuam" nyob rau sab saum toj ntawm lub qhov rais thiab xaiv cov ntawv "Macro" submenu, nyob rau sab laug uas sau rau "Pib sau" kab. Cov lus piav qhia no yog raws nraim rau cov khoos phis tawj Microsoft Excel 2003, tab sis cov kauj ruam yuav zoo ib yam li lwm qhov.
Kauj ruam 2
Lub qhov rai hu ua "Cov Ntaub Ntawv Macro" tshwm. Hauv thawj kab, sau lub npe kom koj tuaj yeem paub qhov txawv ib qho macro los ntawm lwm qhov thiab, tsis tas yuav khiav nws, paub tias lub hom phiaj ntawm microprogram no yog dab tsi.
Kauj ruam 3
Hauv qab lub npe, teeb lub khawm luv, nws tuaj yeem yog qhov tseem ceeb hauv kev sib xyaw nrog khawm "Ctrl". Kuj xaiv qhov chaw txuag. Txhawm rau ua qhov no, xaiv ib qho ntawm cov kev xaiv hauv daim ntawv nco-down: "Phau Ntawv no", "Phau Ntawv Tus Kheej Macro" lossis "Phau Ntawv Tshiab". Yog tias koj xav tau cov ntawv sau cia ntawm cov haujlwm yuav tsum muaj los ntawm txhua daim ntawv Excel, xaiv qhov kev xaiv Tus Kheej Macro Phau Ntawv. Lwm qhov kev xaiv yog khaws cov ntawv loj hauv cov ntawv uas nws ib txwm yuav siv, tom qab ntawd xaiv qhov "Phau Ntawv no" kev xaiv.
Kauj ruam 4
Daim teb kawg ntawm txoj hauj lwm. Sau luv luv lub ntsiab lus ntawm macro - tom qab ntawd nws yuav yooj yim dua rau siv nws. Koj tuaj yeem tsis teb dab tsi.
Kauj ruam 5
Nyem OK los pib sau. Ib lub pob kom nres sau cia yuav tshwm sim ntawm qhov screen, nws zoo li lub xiav xiav. Pib ua cov haujlwm uas koj xav ua kom txuag tau xws li macro: hloov qhov loj me, tsim cov kab ntawv ntawm thaj chaw, luam cov nqi ntawm tes, uas yog, tag nrho cov haujlwm tib yam uas koj ib txwm ua nrog daim ntawv.
Kauj Ruam 6
Thaum ua tiav, nyem lub xiav xiav - lub khawm kaw cia. Los yog koj tuaj yeem nyem cov Cuab Yeej menu ntxiv, tom qab ntawd Macro. Ntawm qhov chaw ntawm kab ntawv "Pib sau", yuav muaj qhov rov qab tso tawm "nres sau".
Kauj Ruam 7
Kaw koj lub rooj. Thaum qhov kev tshoov siab kom khaws cov kev hloov pauv hauv daim ntawv thiab hauv phau ntawv tus kheej loj, nyem lub pob "Yog". Qhov no, koj li macro yuav kaw cia thiab tuaj yeem tua tau txhua lub sijhawm.
Kauj ruam 8
Txhawm rau kuaj, rov qhib koj Excel daim ntawv nthuav dav lossis tsim daim ntawv tshiab. Nias lub keyboard shortcut teeb rau txoj kev cawm ntawv loj. Yog tias koj tau ua txhua yam raws li qhov yog, txhua qhov kev ua uas koj tau ua thaum sau cia yuav ua rau nrawm dua ntawm qhov screen. Kev sim - thiab koj kev ua haujlwm nrog lub koos pis tawj yuav yooj yim dua.
