• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL

Part 15. Advanced Office and Web Feature... > Automating Repetitive Tasks with Mac...

Automating Repetitive Tasks with Macros

Open the Tools menu and select Macro, Record New Macro to open the Record Macro dialog box.

In the Macro Name field, type a descriptive name for the macro—something you will easily remember (for example, Quarter)—and click OK.

Office begins recording your actions; all actions will be performed by the macro when it is run. In this case, click the New button to create a new workbook.

Add and format any text that you want automatically placed in each new workbook the macro creates.


If your job requires you to use your computer to perform repetitive tasks, you can probably use Office to create a macro to automate those tasks. For example, suppose you frequently create quarterly workbooks. You could create a macro that automatically opens a new blank workbook and adds the appropriate column heading information, as outlined in this task. You can create macros that accomplish just about any task in any Office application—without knowing anything about programming. You simply use Office's macro-recording feature to record the actions of a particular task; then, when you run the macro, Office performs these actions for you.


Macro Security

Before you run a macro, make sure you know who a macro is from and that it is a trusted source. To be extra careful, select Tools, Macro, Security to open the Security dialog box. Make sure the security level is set to High.

When you've completed all the actions you want the macro to perform, click the Stop Recording button.

To run the macro you created, open the Tools menu and select Macro, Macros (or press Alt+F8 ) to open the Macro dialog box.

Double-click the macro's name to run it. (Notice that the macro's name contains the name of the workbook you were using when the macro was created.)

Office runs the macro—in this case, automatically creating a new workbook and adding and formatting the text you specified.



Not a subscriber?

Start A Free Trial

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint