×
영어
죄송합니다. 이 문서는 귀하의 언어로 사용할 수 없습니다.
매크로 작업

매크로 편집

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Watch this video to see how to edit a macro in a special text editor called the Visual Basic Editor. Visual Basic is the programming language that macros are recorded in.

First, show the Developer tab

The DEVELOPER tab, on the ribbon, is where all of the macro commands are.

  • To have it appear on the ribbon, click FILE > Options > Customize Ribbon, check Developer, and click OK.

  • On the DEVELOPER tab, in the Code group, are the Record Macro button and some other buttons that will come in handy.

Create a macro using Visual Basic

  1. Click DEVELOPER > Visual Basic.

  2. If needed, in the Visual Basic Editor, on the Insert menu, click Module.

    Note:  Modules are automatically created for all sheets in the workbook.

  3. In the code window of the module, type or copy the macro code that you want to use.

  4. To run the macro from the module window, press F5.

  5. In the Visual Basic Editor, on the File menu, click Close and Return to Microsoft Excel when you finish writing the macro.

Edit the macro

  1. On the DEVELOPER tab, in the Code group, click Macros.

  2. In the Macro name box, click the macro that you want to edit.

  3. Click Edit. The Visual Basic Editor appears.

Want more?

Create or delete a macro

Edit a macro

Assign a macro to a button

Create and save all your macros in a single workbook

Office 기술 확장
교육 살펴보기
새로운 기능 우선 가져오기
Office Insider 참여

이 정보가 유용한가요?

의견 주셔서 감사합니다!

피드백을 주셔서 감사합니다. Office 지원 에이전트와 연락하는 것이 도움이 될 것 같습니다.

×