Ib qho macro yog qhov program tshwj xeeb uas tso cai rau koj los ua ntau qhov rov ua dua nyob rau hauv ib daim ntawv thov, piv txwv li, koj tuaj yeem tsim macro hauv Microsoft Office cov haujlwm los ua tib qho.
Tsim nyog
Microsoft Chaw Haujlwm
Cov Lus Qhia
Kauj ruam 1
Tsim kev loj dua, piv txwv, hauv Excel. Nws yuav tso cai rau koj kom txuag tau ib txheej ntawm kev ua haujlwm thiab ua nws yav tom ntej siv ib qho lus txib. Txhawm rau tsim cov ntawv loj, npaj tag nrho cov txheej txheem ua haujlwm uas koj npaj yuav cawm tau zoo ib yam li macro.
Kauj ruam 2
Thov nco ntsoov tias txhua qhov kev ua yuav raug cawm dim, suav nrog kev kho ntawm kev ua yuam kev thiab kev tshem tawm txoj haujlwm. Khiav cov lus txib "Macro" - "Pib Teev" los ntawm cov ntawv qhia "Cuab yeej". Nyob rau hauv "Cov Ntawv Sau Macro" qhov rai uas tshwm, sau lub npe macro kom tsim. Hauv daim "Keyboard shortcut", nyem cov nyees khawm uas koj npaj siab yuav khiav cov macro yav tom ntej. Tom ntej no, sau rau "Txuag mus rau Phau Ntawv" teb. Nyem OK. Tom qab ntawd, cov ntaubntawv sau tseg ntawm macro pib.
Kauj ruam 3
Ua cov haujlwm uas koj npaj yuav cawm thiab tom qab ntawd cob rau macro kom khawm. Tom qab ua tiav txhua yam tsim nyog ua tiav, nyem rau ntawm lub pob ntawm "toolbar" Stop recording ". Koj tuaj yeem khiav tsim macro siv cov keyboard uas muab rau koj los yog siv "Cuab Yeej" - "Macro" ntawv qhia zaub mov. Koj tuaj yeem tso cai tua ib tus macro mus rau lub pob lossis khoom.
Kauj ruam 4
Tso rau macro kom khawm. Excel muaj lub peev xwm los tsim koj cov ntaub ntawv siv hluav taws xob. Txhawm rau ua qhov no, koj yuav tsum pab kom "pawg" tswj hwm. Hauv lub vaj huam sib luag no, xaiv lub pob "khawm". Kos lub pob rau ntawm qhov chaw xav tau nyob rau ntawm nplooj ntawv.
Kauj ruam 5
Hauv lub npov uas tshwm sim, xaiv "Xaiv" Macro "xaiv thiab xaiv cov macro tsim, nyem" OK ". Ib lub pob nrog lub luag haujlwm macro tau tsim, koj tuaj yeem hloov cov ntawv lossis rov ua dua macro siv cov ntawv qhia ua zaub mov.
Kauj Ruam 6
Txheeb macro rau cov khawm uas twb muaj lawm ntawm cov txheej txheem toolbar. Txhawm rau ua qhov no, xaiv cov ntawv qhia zaub mov "Saib" - "Toolbars" - "Chaw". Hu rau cov ntsiab lus teb ntawv ntawm lub pob uas raug xaiv, xaiv "Xaiv" Macro "xaiv". Xaiv cov macro uas koj tsim ua ntej, nyem OK.
