Project lists all the macros you create in the Macros dialog box (Tools → Macro → Macros). You can run one any time by selecting it, and then clicking Run. But since the whole point of writing macros is to save time 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 a few pros and cons. In the Macros dialog box, you can select a macro, and then click Run. Adding a macro to a toolbar or menu keeps them nearby, and a single click runs one. A keyboard shortcut is another way to run a macro, although the limited number of keyboard shortcuts available makes this method best for your most popular macros. (Showoffs who edit code in the Visual Basic Editor: you can run a macro there, too, although this way doesn't count as an everyday method.)
The Macros dialog box method requires the most mouse clicks, but it's ideal when you need a refresher course in the macros you use. Perhaps you've created so many macros, you can't remember them all. Or you didn't create 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:
Choose Tools → Macro → Macros.
The Macros dialog box opens. You can also open this dialog box by pressing Alt+F8.
In the macro list, select the macro you want to run, and then click Run.
When you select a macro, the description ...