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

Managing Macros

Word, Excel, PowerPoint, Outlook, Publisher, and FrontPage include built-in tools for creating and deleting macros. In all six applications:

1.
Choose Tools, Macro, Macros, and you'll see the Macros dialog box (see Figure 42.2).

Figure 42.2. If more than one document, template, workbook, or presentation is open, you can narrow down the list of macros by making a choice in the Macros In box.


2.
To create a new, empty macro, type a name for the new macro, choose a location for it in the Macros In box, and click Create. VBA creates a new subroutine with the given name, and puts you in the Visual Basic Editor (discussed in the next section), ready to start typing your macro.

Word places newly created macros in a module called NewMacros. Excel and PowerPoint put them in modules called Module1, Module2, and so on. If you want to place your new macro in a specific module, use the Visual Basic Editor.

TIP FROM

If you want to easily copy and move individual macros in Word, you'll want to move them out of the NewMacros module and give them their own module.

3.
To delete a macro, click the macro's name and click Delete.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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