Qhov wikiHow qhia yuav ua li cas los tsim macros yooj yim rau Excel daim ntawv nthuav qhia.
Cov kauj ruam
Ntu 1 ntawm 3: Pab kom Macros
Kauj Ruam 1. Qhib Excel
Cov txheej txheem rau qhib macros yog tib yam rau Excel 2010, 2013, thiab 2016. Muaj qhov sib txawv me ntsis rau Excel rau Mac, uas yuav piav qhia ntxaws hauv qab no.
Kauj ruam 2. Nyem rau File tab
Hauv Excel rau Mac, nyem rau "Excel" ntawv qhia zaub mov
Kauj Ruam 3. Nyem Xaiv
Hauv Excel rau Mac, nyem qhov "Nyiam" cov ntawv qhia zaub mov xaiv
Kauj Ruam 4. Nyem rau Customize Ribbon xaiv
Hauv Excel rau Mac, nyem "Ribbon & Toolbar" hauv ntu "Authoring"
Kauj Ruam 5. Kos rau lub npov tsim tawm hauv cov npe ntawm sab xis
Hauv Excel rau Mac, koj yuav pom "Tus Tsim Tawm" hauv "Tab lossis Pawg Npe" npe
Kauj Ruam 6. Nyem OK
Koj yuav pom Tus Tsim Tawm tab tshwm ntawm qhov kawg ntawm koj daim ntawv teev npe.
Ntu 2 ntawm 3: Kaw Macro
Kauj Ruam 1. Xyaum koj cov lej sib lawv liag
Thaum koj sau cov duab macro, txhua yam koj nyem lossis ua yuav raug kaw, yog li ib daim ntawv tuaj yeem ua rau puas tag nrho. Khiav los ntawm cov lus txib koj yuav sau ob peb zaug kom koj tuaj yeem ua lawv yam tsis muaj kev poob siab thiab tsis ua yuam kev.
Kauj Ruam 2. Nyem rau Tus Tsim Tawm tab
Kauj Ruam 3. Nyem Sau Macro
Koj yuav pom qhov no hauv Tshooj Cai ntawm kab ntawv. Koj tseem tuaj yeem nias Alt+T+M+R kom pib lub tshiab macro (Windows nkaus xwb).
Kauj Ruam 4. Muab lub npe macro
Nco ntsoov tias koj yuav tuaj yeem txheeb xyuas nws yooj yim, tshwj xeeb tshaj yog tias koj tab tom yuav tsim ntau macros.
Koj tseem tuaj yeem ntxiv cov lus piav qhia piav qhia txog dab tsi macro yuav ua tiav
Kauj Ruam 5. Nyem rau Shortcut key field
Koj tuaj yeem muab cov keyboard luv rau lub macro kom yooj yim khiav nws. Qhov no yog nyob ntawm yeem.
Kauj Ruam 6. Nias ⇧ Shift ntxiv rau ib tsab ntawv
Qhov no yuav tsim Ctrl+⇧ Shift+tsab ntawv keyboard ua ke kom pib lub macro.
Ntawm Mac, qhov no yuav yog ⌥ Opt+⌘ Command+tsab ntawv ua ke
Kauj Ruam 7. Nyem rau Store Macro hauv cov ntawv qhia zaub mov
Kauj Ruam 8. Nyem rau qhov chaw koj xav khaws cov macro
Yog tias koj tsuas yog siv tus lej rau koj daim ntawv teev npe tam sim no, tsuas yog tso nws ntawm "Phau Ntawv Qhia Ua Haujlwm no." Yog tias koj xav tau cov macro muaj rau txhua daim ntawv nthuav qhia koj ua haujlwm, xaiv "Tus Kheej Macro Phau Ntawv Ua Haujlwm."
Kauj ruam 9. Nyem OK
Koj lub macro yuav pib sau cia.
Kauj Ruam 10. Ua cov lus txib uas koj xav sau
Zoo nkauj npaum li cas txhua yam koj ua tam sim no yuav raug kaw thiab ntxiv rau qhov macro. Piv txwv li, yog tias koj ua cov lej sib piv ntawm A2 thiab B2 hauv cell C7, khiav cov lej yav tom ntej yuav ib txwm suav A2 thiab B2 thiab tso tawm cov txiaj ntsig hauv C7.
Macros tuaj yeem ua rau nyuaj heev, thiab koj tseem tuaj yeem siv lawv qhib lwm qhov haujlwm hauv Office. Thaum lub macro kaw, yuav luag txhua yam koj ua hauv Excel tau ntxiv rau lub macro
Kauj Ruam 11. Nyem Nthuav Tawm Cov Ntaub Ntawv thaum koj ua tiav
Qhov no yuav xaus cov ntaubntawv povthawj siv macro thiab txuag nws.
Kauj Ruam 12. Txuag koj cov ntaub ntawv hauv hom mac-enabled
Txhawm rau khaws koj cov macros, koj yuav tsum khaws koj phau ntawv ua haujlwm tshwj xeeb macro-enabled Excel hom:
- Nyem rau File menu thiab xaiv Txuag.
- Nyem rau File Type menu hauv qab cov ntaub ntawv npe teb.
- Nyem Excel Macro-Enabled Workbook.
Ntu 3 ntawm 3: Siv Macro
Kauj Ruam 1. Qhib koj cov ntaub ntawv ua haujlwm mac-enabled
Yog tias koj tau kaw koj cov ntaub ntawv ua ntej siv koj lub macro, koj yuav raug ceeb toom kom qhib cov ntsiab lus.
Kauj Ruam 2. Nyem Enable Content
Qhov no tshwm nyob rau sab saud ntawm daim ntawv Excel nyob rau hauv Kev Nyab Xeeb Kev Nyab Xeeb bar thaum twg qhib phau ntawv ua haujlwm macro. Txij li nws yog koj li ntaub ntawv, koj tuaj yeem ntseeg nws, tab sis ceev faj heev qhib cov ntaub ntawv qhib-qhib los ntawm lwm qhov chaw.
Kauj Ruam 3. Nias koj qhov luv luv
Thaum koj xav siv koj lub macro, koj tuaj yeem nrawm nws los ntawm nias qhov luv uas koj tsim rau nws.
Kauj Ruam 4. Nyem rau Macros khawm hauv Tus Tsim Kho tab
Qhov no yuav tso tawm tag nrho cov macros uas muaj nyob hauv koj daim ntawv nthuav qhia tam sim no.
Kauj Ruam 5. Nyem qhov macro koj xav khiav
Kauj Ruam 6. Nyem rau Khiav khawm
Macro yuav khiav hauv koj lub cell tam sim no lossis xaiv.
Kauj Ruam 7. Saib macro's code
Yog tias koj xav kawm paub ntau ntxiv txog kev ua haujlwm coding li cas, koj tuaj yeem qhib qhov chaws ntawm txhua qhov macro koj tau tsim thiab tinker nrog nws:
- Nyem rau Macros khawm hauv Tus Tsim Kho tab.
- Nyem qhov macro koj xav pom.
- Nyem qhov Kho kom raug khawm.
- Saib koj cov lej lej hauv Visual Basic code kho qhov rai.