Kuv Yuav Nrhiav Tus Kheej Macro Workbook nyob qhov twg?
- Qhib phau ntawv tshiab lossis phau ntawv ua haujlwm uas twb muaj lawm.
- Mus rau tus tsim tawm tab hauv kab.
- Click on Record Macro.
- Nyob rau hauv Cov Ntaub Ntawv Macro dialog box, qhia lub npe (default is fine too).
- Nyob hauv 'Kho Macro hauv' poob qis, xaiv Tus Kheej Macro Workbook.
- Click OK.
Kuv yuav nrhiav kuv phau ntawv macro tus kheej nyob qhov twg?
Nyob hauv ib phau ntawv ua haujlwm, mus rau Developer tab > Code pawg, thiab nyem Cov Ntaub Ntawv Macro. Cov Ntaub Ntawv Macro dialog box yuav tshwm sim. Hauv Khw Macro hauv daim ntawv teev npe, xaiv Tus Kheej Macro Workbook thiab nyem OK.
tus kheej macros tau txais kev cawmdim nyob qhov twg?
Hauv Windows 10, Windows 7, thiab Windows Vista, phau ntawv no tau txais kev cawmdim hauv C:\Users\user name\AppData\Local\Microsoft\Excel\XLStart folder Hauv Microsoft Windows XP, phau ntawv no tau txais kev cawmdim hauv C:\Documents thiab Settings\user name\Application Data\Microsoft\Excel\XLStart folder.
Kuv macro nyob qhov twg?
Peb qhov kev xaiv macro tshwm sim ntawm qhov kawg sab xis ntawm Saib tabKoj siv Macros dropdown los saib macros, sau cov macro, lossis siv cov txheeb ze cov ntaub ntawv thaum kaw macro. Txhawm rau nkag mus rau qhov seem ntawm macro functionality, koj yuav tsum tau qhib qhov zais Developer ribbon tab. Xaiv Cov Ntaub Ntawv, Kev Xaiv, Customize Ribbon.
Kuv yuav ua kom macro muaj nyob hauv txhua phau ntawv ua haujlwm li cas?
Txuag koj Excel Macro siv rau hauv txhua phau ntawv ua haujlwm
- Nyem Sau Macro ntawm tus tsim tawm tab raws li koj ib txwm xav.
- Nyob hauv Cov Ntaub Ntawv Macro dialog box, xaiv Tus Kheej Macro Workbook los ntawm Khw macro hauv: kev xaiv poob.
- Ua tiav qhov macro raws li koj ib txwm xav.
