Cov txheej txheem:

Kuv cov macros khaws cia hauv Excel nyob qhov twg?
Kuv cov macros khaws cia hauv Excel nyob qhov twg?

Video: Kuv cov macros khaws cia hauv Excel nyob qhov twg?

Video: Kuv cov macros khaws cia hauv Excel nyob qhov twg?
Video: Keem lis ( Nkauj iab thiab Nraug oo 1 ) 2024, Hlis ntuj nqeg
Anonim

Cov ntaub ntawv tus kheej macro workbook qhib nyob rau tom qab txhua zaus koj qhib Excel . Koj tuaj yeem pom nws hauv ProjectWindow ntawm Visual Basic (VB) Editor. Cov ntaub ntawv yog khaws cia hauv daim nplaub tshev XLSTART ntawm lub computer. Ib qho Excel cov ntaub ntawv hauv daim nplaub tshev no yuav qhib thaum koj qhib Excel.

Ib yam li ntawd, tib neeg nug, Kuv yuav ua li cas thiaj li khaws tau qhov macro hauv Excel mus tas li?

Tsim thiab txuag tag nrho koj cov macro hauv ib phau ntawv ua haujlwm

  1. Mus rau Developer tab, thiab nyem Cov Ntaub Ntawv Macro.
  2. Hauv Cov Ntaub Ntawv Macro dialog box, tsis txhob thab nkag mus rau lub npe rau lub macro hauv lub thawv npe Macro.
  3. Hauv khw macro hauv lub thawv, xaiv Tus Kheej Macro Workbook> OK.
  4. Nyem tus tsim tawm> Tsis txhob kaw, thiab Excel yuav tsim koj tus kheej Macro worbook.

Kuv yuav txuag macro hauv Excel 2016 li cas? Txuag koj phau ntawv ua haujlwm li " Excel macro -enabledworkbook" Nias Crl + S, tom qab ntawd nyem lub pob "Tsis yog" hauv "Cov yam ntxwv hauv qab no tsis tuaj yeem ua tau. cawm hauv macro -freeworkbook" ceeb toom dialog. Txuag raws li "dialog yuav qhib. Xaiv" Excel macro -enabled workbook" los ntawm " Txuag raws li hom" drop-down daim ntawv teev thiab nyem rau ntawm Txuag khawm.

Kuj paub, qhov twg XLStart folder?

Muab ib phau ntawv ua haujlwm rau hauv XLStartfolder Qhov no XLStart folder tau tsim thaum koj nruab Excel, thiab feem ntau nyob hauv ib qho ntawm cov chaw hauv qab no. Hauv Windows Vista, txoj hauv kev mus rau qhov XLStart folder isusually: C:UsersusernameAppDataLocalMicrosoftExcel XLStart.

Yuav ua li cas thiaj ua tau ib qho macro rau tag nrho cov ntaub ntawv Excel?

Nov yog cov kauj ruam los tsim Tus Kheej Macro Workbook hauv Excel:

  1. Qhib phau ntawv ua haujlwm tshiab lossis ib phau ntawv ua haujlwm uas twb muaj lawm.
  2. Mus rau Developer tab nyob rau hauv ribbon.
  3. Nyem rau Cov Ntaub Ntawv Macro.
  4. Hauv Cov Ntaub Ntawv Macro dialog box, qhia lub npe (default is finetoo).
  5. Hauv 'Kho Macro hauv', xaiv Tus Kheej MacroWorkbook.
  6. Nyem OK.

Pom zoo: