Qhov wikiHow no qhia koj li cas los tsim cov lej hauv Microsoft Office 365 program xws li Lo Lus lossis Excel. Koj tuaj yeem sau koj cov kev ua kom cia li tsim macro hauv qee qhov haujlwm, lossis koj tuaj yeem siv Visual Basic coding los tsim macro los ntawm kos hauv ib qho Office 365 program.
Cov kauj ruam
Ntu 1 ntawm 3: Pab kom Tsim Kev Xaiv
Kauj Ruam 1. Qhib Microsoft Office program
Macros tuaj yeem tsim rau feem ntau ntawm Office 365 cov haujlwm, yog li qhib qhov program uas koj xav tsim macros.
- Yog tias koj xav sau cov macro, qhib Lo Lus lossis Excel.
- Yog tias koj xav kom program macro siv VBA, qhib Lo Lus, Excel, PowerPoint, Outlook (Windows nkaus xwb), lossis Publisher (Windows nkaus xwb).
- Koj tsis tuaj yeem ntxiv macros rau Access lossis OneNote.
Kauj Ruam 2. Nyem Qhib lwm cov ntaub ntawv
Nws yog qhov txuas nyob rau sab qis-sab laug ntawm qhov program qhov rai. Qhov no yuav qhib cov npe xaiv nyob rau sab laug ntawm lub qhov rais.
Ntawm Mac, nyem lub npe ntawm koj qhov program nyob rau sab saud sab laug ntawm lub vijtsam kom pom cov ntawv qhia zaub mov nco-down
Kauj Ruam 3. Nyem Xaiv
Koj yuav pom qhov no nyob rau sab laug ntawm lub qhov rais.
Ntawm Mac, koj yuav nyem Nyiam … nyob rau hauv cov ntawv qhia zaub mov nco-down.
Kauj Ruam 4. Nyem Customize Ribbon
Nws nyob rau sab laug ntawm Options window.
Ntawm Mac, nyem Ribbon & Toolbar nyob rau hauv Preferences window.
Kauj Ruam 5. Kos rau lub npov "Developer"
Lub npov no nyob ze rau hauv qab ntawm "Cov Tab Tab" cov npe xaiv.
Nyob ntawm koj qhov haujlwm uas koj xaiv, koj yuav tsum xub tso koj tus cursor rau hauv "Main Tabs" pane thiab tom qab ntawd nqes mus nrhiav lub npov "Developer"
Kauj Ruam 6. Nyem OK
Nws nyob hauv qab ntawm lub qhov rais. Qhov no yuav ntxiv qhov Tsim tawm tab rau koj qhov program uas koj xaiv.
Ntawm Mac, koj yuav nyem Txuag nov xwb.
Ntu 2 ntawm 3: Kaw Macro
Kauj Ruam 1. Nco ntsoov tias koj muaj Lo Lus lossis Excel qhib
Microsoft Word thiab Excel tsuas yog ob lub Office 365 cov haujlwm uas koj tuaj yeem tsim macros los ntawm kev kaw cov kauj ruam.
Kauj Ruam 2. Qhib ib daim ntawv
Nyem rau Blank kev xaiv nyob rau sab saud sab laug ntawm lub qhov rais los tsim daim ntawv tshiab, tsis muaj ntaub ntawv, lossis xaiv cov ntaub ntawv los ntawm koj lub computer.
Koj tseem tuaj yeem nyem ob npaug rau ib daim ntawv qhib nws hauv nws cov haujlwm tshwj xeeb (piv txwv li, ob npaug nyem rau lo lus ntawv yuav qhib hauv Lo Lus)
Kauj Ruam 3. Nyem Developer
Tsuav koj tau qhib nws nyob rau ntu kawg, tab no yuav tsum nyob rau sab saum toj ntawm lub qhov rais.
Kauj Ruam 4. Nyem Sau Macro
Nws yog nyob rau sab saum toj-sab laug ntawm lub qhov rais hauv Tsim tawm toolbar.
Kauj Ruam 5. Sau koj cov ntaub ntawv macro
Cov txheej txheem no yuav txawv me ntsis nyob ntawm koj qhov kev zov me nyuam xaiv:
- Lo Lus - Sau lub npe rau lub macro, xaiv Txhua cov ntaub ntawv raws li "Khw macro hauv" tus nqi, thiab nyem OK.
- Excel - Sau lub npe rau lub macro, ntxiv cov keyboard luv yog tias koj nyiam, xaiv Phau ntawv no raws li "Khw macro hauv" tus nqi, thiab nyem OK.
Kauj Ruam 6. Sau koj lub macro
Thaum koj nyem OK, txhua cov kauj ruam koj ua (piv txwv li, nyem, ntaus ntawv, thiab lwm yam) yuav raug ntxiv rau koj lub macro.
Kauj Ruam 7. Nyem Nthuav Tawm Cov Ntaubntawv
Nws nyob hauv Tsim tawm toolbar. Qhov no yuav txuag koj cov macro thiab ntxiv nws rau koj daim ntawv teev npe macro.
Koj tuaj yeem siv macro los ntawm txhaj Macros, xaiv koj lub npe macro, thiab nyem Khiav.
Ntu 3 ntawm 3: Sau Macro
Kauj Ruam 1. Nco ntsoov tias koj paub yuav ua li cas rau hauv VBA
Visual Basic for Applications (VBA) yog hom lus siv los ntawm Microsoft Office 365 cov haujlwm los khiav macros.
Yog tias koj tsis muaj kev nkag siab zoo ntawm VBA, koj tuaj yeem tuaj yeem pom cov cai rau tus lej uas twb muaj lawm. Yog tias yog, koj tuaj yeem luam cov lej lej thiab muab tso rau hauv VBA qhov rai tom qab hauv ntu no
Kauj Ruam 2. Qhib Microsoft Office 365 cov ntaub ntawv
Nyem ob npaug rau cov ntaub ntawv uas koj xav tsim lub macro. Qhov no yuav qhib cov ntawv hauv nws qhov haujlwm tshwj xeeb.
- Koj tseem tuaj yeem qhib qhov program koj xav siv thiab nyem rau ntawm Blank xaiv nyob rau sab saud sab laug ntawm lub qhov rais los tsim cov ntawv tshiab.
- Koj tsis tuaj yeem siv Access lossis OneNote los tsim macros.
Kauj Ruam 3. Nyem Developer
Cov ntawv no yog nyob rau sab saum toj ntawm qhov program qhov rai.
Kauj ruam 4. Nyem Macros
Nws nyob rau sab laug-sab laug ntawm lub qhov rais. Ua li ntawd qhib lub qhov rai pop-up.
Kauj Ruam 5. Sau lub npe macro
Nyem rau ntawm "Macro name" text box nyob rau sab saum toj ntawm lub qhov rais, tom qab ntawd ntaus lub npe uas koj xav siv rau koj lub macro.
Kauj Ruam 6. Nyem Tsim
Nws nyob sab xis ntawm lub qhov rais. Ua li ntawd hais kom VBA qhov rai qhib.
Kauj Ruam 7. Ntaus koj tus lej lej
Thaum lub VBA qhov rai qhib, ntaus tus lej rau koj lub macro.
Yog tias koj tau theej cov lej lej, muab tso rau hauv VBA qhov rai
Kauj Ruam 8. Txuag koj cov ntaub ntawv raws li hom ntawv qhib siv macro
Nias ib qho Ctrl+S (Windows) lossis ⌘ Command+S (Mac), tom qab ntawd nkag mus rau lub npe cov ntaub ntawv, nyem rau "Save as type" (Windows) lossis "Format" (Mac) lub npov nco, Macro-Enabled kev xaiv hauv cov ntawv qhia zaub mov nco-down tshwm sim. Koj tuaj yeem nyem tom qab Txuag kom txuag tau cov ntaub ntawv nrog lub macro enabled.