Microsoft Project 2013: The Missing Manual

Running Macros

Project lists all the macros you create in the Macros dialog box (in the View tab’s Macros section, click Macro→View Macros). You can run one anytime by selecting it and then clicking Run. But since the whole point of writing macros is to reduce time spent on repetitive tasks, clicking several times to run a macro defeats the purpose.

You can run a macro in any of three ways, each with its pros and cons. In the Macros dialog box, you can select a macro, and then click Run. Adding a macro to the ribbon or to the Quick Access toolbar keeps it close at hand, and a click or two runs it. A keyboard shortcut is another way to run a macro, although the limited number of keyboard shortcuts available makes this method best for only your most popular macros. (Showoffs who edit code in the Visual Basic Editor: You can run a macro there, too, although doing so doesn’t count as an everyday method.) This section explains your options.

Running Macros from the Macros Dialog Box

The Macros-dialog-box method requires the most mouse clicks, but it’s ideal when you need a refresher course in the macros you have available. Perhaps you’ve created so many macros that you can’t remember them all. Or maybe someone else created the macros, and you want to see what’s available. The Macros dialog box lists macros that are available in all open projects. To run a macro from the Macros dialog box, do the following:

1. In the View tab’s Macros section, click Macros→View Macros.

   The Macros dialog box opens. ...