Cov txheej txheem:

Nrhiav tsis tau kuv phau ntawv ua haujlwm hauv Excel?
Nrhiav tsis tau kuv phau ntawv ua haujlwm hauv Excel?

Video: Nrhiav tsis tau kuv phau ntawv ua haujlwm hauv Excel?

Video: Nrhiav tsis tau kuv phau ntawv ua haujlwm hauv Excel?
Video: tag rau koj lawm - nuj xeem - nkauj tawm tshiab 2022 2024, Tej zaum
Anonim

Phau Ntawv Qhia Txog Tus Kheej Tsis Ua Haujlwm

  1. Tso saib Excel Options dialog box.
  2. Nyem Ntxiv-Ins ntawm sab laug ntawm lub dialog box.
  3. Siv cov Tswj cov npe teev tseg (hauv qab ntawm lub thawv sib tham), xaiv Cov Khoom Tsis Taus.
  4. Nyem rau khawm mus.
  5. Yog tias Phau ntawv ua hauj lwm tus kheej yog teev li neeg tsis taus, xaiv thiab ces nias Enable.
  6. Kaw tag nrho cov qhib dialog boxes.

Cov lus nug tseem yog, qhov twg yog Tus Kheej Macro Workbook tau txais kev cawmdim?

Sib koom macro Yog koj xav share koj Tus kheej .xlsb nrog lwm tus, koj tuaj yeem luam nws mus rau XLSTART nplaub tshev ntawm lwm lub khoos phis tawj. Hauv Windows 10, Windows 7, thiab Windows Vista, qhov no phau ntawv ua haujlwm yog cawm hauv C:UsersusernameAppDataLocalMicrosoftExcelXLStart folder.

Tsis tas li ntawd, kuv yuav ua li cas kom muaj macro muaj nyob hauv txhua phau 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.

Tsis tas li ntawd, XLStart folder nyob qhov twg?

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.

Kuv yuav ua li cas thiaj pab tau tus kheej phau ntawv ua haujlwm hauv Excel?

Ua raws li cov kauj ruam no:

  1. Tso saib Excel Options dialog box.
  2. Nyem Ntxiv-Ins ntawm sab laug ntawm lub dialog box.
  3. Siv cov Tswj cov npe teev tseg (hauv qab ntawm lub thawv sib tham), xaiv Cov Khoom Tsis Taus.
  4. Nyem rau khawm mus.
  5. Yog tias Phau Ntawv Qhia Txog Tus Kheej tau teev tseg tias yog neeg xiam oob qhab, xaiv nws thiab tom qab ntawd nyem Enable.
  6. Kaw tag nrho cov qhib dialog boxes.

Pom zoo: