• 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 39.2).

    Figure 39.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 VBA 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 VBA Editor.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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