Yuav Ua Li Cas Luam Ib Qho Macro

Cov txheej txheem:

Yuav Ua Li Cas Luam Ib Qho Macro
Yuav Ua Li Cas Luam Ib Qho Macro

Video: Yuav Ua Li Cas Luam Ib Qho Macro

Video: Yuav Ua Li Cas Luam Ib Qho Macro
Video: thaum txiv neej phev yuav los poj niam hnov zoo li cas 2024, Hlis ntuj nqeg
Anonim

Ib qho ntawm cov teeb meem tshwm sim thaum luam ntawv loj heev los ntawm cov ntawv xaiv lossis qauv mus rau qhov xav tau yog qhov yuav tsum tau hloov lossis luam cov chaw ntawm cov ntawv lossis template. Nws raug nquahu kom siv cov ntawv luam ntawm cov ntaub ntawv xaiv lossis cov qauv uas muaj macros.

Yuav ua li cas luam ib qho macro
Yuav ua li cas luam ib qho macro

Tsim nyog

Microsoft Word, Microsoft Excel, Siv Kev Pom Duab

Cov Lus Qhia

Kauj ruam 1

Nco ntsoov tias Lo Lus macros ua haujlwm thiab qhib daim ntawv xaiv.

Kauj ruam 2

Mus rau Visual Basic Editor los ntawm nias ALT + F11 tib lub sijhawm.

Kauj ruam 3

Xaiv cov Compile ntu hauv Debug kev pabcuam zaub mov thiab tos rau cov lus hais txog kev ua tiav tiav ntawm kev ua haujlwm. Txwv tsis pub, nws yog qhov yuav tsum tau txheeb xyuas cov npe ntawm cov ntawv txuas nrog.

Kauj ruam 4

Rov qab mus rau Visual Basic Editor thiab mus rau ntawm Ntawv Qhia Ntawv Qhia.

Kauj ruam 5

Xaiv cov Kab Ntawv Qhia thiab tsis khij (lossis rho tawm) lub npov hauv daim teb uas yuav tsum tau ua.

Siv cov khoom siv kho mob kom luam ib feem ntawm daim ntawv lossis template.

Kauj Ruam 6

Qhib lub "Macros" window los ntawm nias lub pob ALT + F8 tib lub sijhawm.

Kauj Ruam 7

Nyem Lub Organizer khawm.

Kauj ruam 8

Ua raws li cov lus qhia hauv lub app.

Ua raws li cov theem no los luam Microsoft Excel macros.

Kauj Ruam 9

Xaiv "Xaiv" los ntawm cov ntawv qhia "Cuab Yeej" thiab mus rau "Security" tab.

Kauj ruam 10

Nias lub khawm Macro Security nyob rau ntu Macro Security seem thiab nyem rau Macro Security Level tab.

Kauj ruam 11

Qhia meej "Nruab Nrab" lossis "Tsawg" hauv "Macro Security Level".

Kauj ruam 12

Xaiv phau ntawv uas muaj qhov yuav tsum sau loj thiab qhib nws.

Kauj ruam 13

Xaiv cov "Macro" cov khoom hauv "Cov Cuab Yeej" ntawv qhia zaub mov thiab coj cov ntawv ua "Macros".

Kauj ruam 14

Qhia lub npe ntawm cov ntawv loj uas xaiv rau kev luam hauv "Macro lub npe" kab.

Kauj ruam 15

Nyem lub pob "Hloov".

Kauj ruam 16

Nco ntsoov tias cov kab Sub thiab Xaus Sub yog suav nrog ib feem ntawm cov ntawv loj yuav tsum tau theej theej txhuv tag nrho macro, lossis xaiv cov kab uas muaj feem ntawm cov macro kom raug theej.

Kauj ruam 17

Nyem rau "Luam" khawm nyob rau hauv toolbar ntawm qhov kev pab cuam lub qhov rai.

Kauj ruam 18

Qhib tus qauv yuav raug hloov kho thiab nyem khawm "Ntxig".

Pom zoo: