Lub macro yog cov npe ntawm cov lus qhia rau Lo Lus lossis Excel. Cov lus qhia no tau muab tso ua ke rau hauv ib tsab ntawv thiab qhia qhov kev pab cuam tias yuav ua li cas thiaj li ua tiav lub hom phiaj tshwj xeeb. Cov ntawv tuaj yeem raug caw los ntawm nias ib tus yuam sij lossis lawv kev sib xyaw ua ke, thiab tseem tau siv lub tshuab raj hais kom ua lossis lub pob rau ntawm lub cuab yeej.
Cov Lus Qhia
Kauj ruam 1
Xaiv "Cov Ntawv Sau Macro" los ntawm cov ntawv qhia "Cuab Yeej", tom qab ntawd "Pib Teev". Ib daim teb rau sau lub npe ntawm macro yuav tshwm sim.
Kauj ruam 2
Sau ib lub npe rau macro. Hauv qhov "piav qhia", koj yuav tsum nkag mus rau nws lub hom phiaj. Tom qab ntawd nias lub khawm OK, tom qab ntawd macro yuav raug kaw, thiab lo lus "Recording" yuav tshwm nyob rau hauv bar xwm txheej.
Kauj ruam 3
Tag nrho cov kab ke ntawm cov yeeb yam uas sau cia macro yuav ua. Txij li cov ntawv kaw (cov ntawv sau loj) sau tag nrho cov kev ua (nrog rau kev zam ntawm cov nyees khawm nyob ntawm lub Nres Cov Cuab Yeej Teev), lawv yuav tsum ua kom zoo zoo.
Kauj ruam 4
Nyem lub Nres Macro khawm thaum koj xav tau kom tiav kev sau koj macro.
Kauj ruam 5
Restore lub pob macro nres rau ntawm lub vijtsam yog tias nws ploj lawm. Ua li no, nyem rau ntawm lub pob nyem khawm ntawm cov tuam. Cov npe ntawm cov twj paj nruag yuav tshwm sim. Xaiv cov "Chaw" yam nyob hauv.
Kauj Ruam 6
Xaiv cov Macro qeb ntawm daim ntawv uas tshwm. Txheej txheej nyees khawm yuav tshwm sim. Nyem lub Nres Macro khawm thiab, thaum tuav cia sab laug nas khawm, txav lub pob nyem daim duab mus rau txoj kab qhib.
Kauj Ruam 7
Kho kom raug cov ntawv sau tseg raws li xav tau los ntawm Xaiv Cov Cuab Yeej, tom qab ntawd Macro thiab Macros. Xaiv cov macro uas yuav tsum tau los ntawm daim ntawv uas tshwm thiab nyem rau "Hloov" khawm. Txuag koj hloov pauv.
Kauj ruam 8
Txheeb ib daim ntawv qhia ua zaub mov lossis tus yuam sij shortcut rau macro. Txheem qhov hais kom ua "Kev pabcuam" thiab tom qab ntawd "Macro". Xaiv cov macro uas yuav tsum tau los ntawm daim ntawv thiab nyem khawm Xaiv. Xaiv cov khoom lag luam uas xav tau los yog cov khoom siv yuam sij, thaum xaiv thiab nias, lub macro no yuav ua nws cov haujlwm.
Kauj Ruam 9
Txhawm rau rho tawm qhov tsis muaj qhov tsis txaus, qhib "Macro" kev xaiv nyob rau hauv "Cov Khoom Pab" thiab nyem rau "Delete" khawm. Yog tias cov kab ntawv nrog cov npe ntawm macros tau sau rau hauv "Cov Cuab Yeej" ntawm cov ntawv qhia zaub mov tseem ceeb, kom tshem lawv, ua ntej qhib Visual Basic toolbar, tom qab ntawd nyem rau "Ntawv Qhia Xov Xwm" khawm. Hauv kev sib tham uas tshwm sim, xaiv thiab rho tawm kab uas xav tau los ntawm txhaj khawm "Rho tawm".
