Microsoft Project 2007: The Missing Manual

Chapter 27. Saving Time With Macros

You perform many of the same actions in Project day after day (sometimes, several times each day). Like doing the dishes, vacuuming the carpet, and washing the cat on the delicate cycle, some repetitive tasks are unavoidable, but some timesaving tools sure would help. Instead of hiring a maid or handyman to take the drudgery out of your Project work, you can write handy mini-programs called macros.

You don’t have to be a geek to write your own macros. You can create a macro simply by recording the steps you want the macro to perform. Then you can run the macro to replay the steps again and again. The geeky project managers in the audience can build upon recorded macros by editing them in Visual Basic for Applications (VBA).

This chapter explains macro basics: recording them, running them, and adding them to toolbars or keyboard shortcuts. But you can create full-strength custom solutions if you’re up for it. If you’re a programmer wannabee, you’ll also find resources for learning more about programming in Project.

What You Can Do with Macros

A macro does one thing really well—it performs a series of steps each time you run it. For example, you can record a macro that hides summary tasks, and then sorts tasks by Duration. Macros are great timesavers because they can perform the equivalent of dozens of mouse-clicks and key presses almost instantaneously. Moreover, macros reduce mistakes because you’re not typing and clicking as much.

Any kind of repetitive ...