Microsoft® Office Project 2007 Inside Out

Creating Macros

The easiest and quickest way to create a macro, especially one that will be used to automate a lengthy series of steps, is to record the steps that make up a task. Recording a macro is just what it sounds like: Start the macro recorder, perform the series of actions you want the macro to do, and then stop the recorder. In most cases, there’s no need to edit the VBA code generated by the recorder.

Note

For more information about creating macros by writing VBA code directly, including how to edit macros, see the Microsoft Office Project 2007 Software Development Kit (SDK), available online at http://msdn2.microsoft.com/en-us/library/aa568824.aspx.

Understanding the Record Macro Dialog Box

Before you can record a macro, you must first ...