Qhov wikiHow qhia koj li cas kom pom cov npe macros hauv koj phau ntawv Excel, nrog rau yuav ua li cas saib txhua qhov macro cov ntsiab lus hauv Visual Basic Editor. Ua ntej koj tuaj yeem ua haujlwm nrog macros, koj yuav tsum tau pab kom Tus Tsim Tawm tab hauv Excel-hmoov zoo, qhov no yooj yim heev ua.
Cov kauj ruam
Kauj Ruam 1. Qhib phau ntawv ua haujlwm hauv Excel
Koj tuaj yeem nyem ob npaug rau lub npe ntawm phau ntawv ua haujlwm kom qhib nws hauv Excel. Xwb, qhib Excel thawj zaug los ntawm Windows Start menu lossis koj Mac's Applications folder, nyem Qhib, thiab tom qab ntawd nyem ob npaug rau cov ntawv.
Kauj Ruam 2. Pab kom tus tsim tawm tab
Yog tias Tus Tsim Kho tab tau qhib, nws yuav nyob hauv cov ntawv qhia zaub mov nyob rau sab saum toj ntawm Excel. Yog tias koj tsis pom nws, ntawm no yog yuav ua li cas los pab nws:
-
Qhov rai:
- Nyem rau Cov ntaub ntawv menu thiab xaiv Kev xaiv.
- Nyem Customize Ribbon.
- Xaiv Cov Ntsiab Tseem Ceeb los ntawm "Customize the ribbon" drop-down menu.
- Khij lub npov nyob ib sab Tsim tawm thiab nyem OK.
-
macOS: ua
- Nyem rau Excel menu thiab xaiv Nyiam.
- Xaiv Cov Ntsiab Tseem Ceeb hauv qab "Customize Ribbon."
- Kos rau lub npov nyob ib sab Tsim tawm.
- Nyem Txuag.
Kauj Ruam 3. Nyem rau Developer tab
Nws yog nyob rau sab saum toj ntawm Excel.
Kauj ruam 4. Nyem Macros
Nws nyob rau sab laug ntawm qhov toolbar. Qhov no qhia cov npe ntawm macros hauv txhua phau ntawv qhib los ntawm lub neej ntawd.
Txhawm rau pom macros hauv phau ntawv tshwj xeeb nkaus xwb, xaiv phau ntawv ntawd lub npe los ntawm "Macros in" menu
Kauj Ruam 5. Xaiv lub macro thiab nyem Kho kom raug
Qhov no qhia txog cov macro hauv Visual Basic Editor.