Microsoft® Office Excel® 2007 Inside Out

Chapter 26. Recording Macros

Configuring Macro Security

Using the Macro Recorder

Introducing the Visual Basic Editor

Learning the Basics of Visual Basic

Adding Code to or Editing Recorded Macros

Using Subroutines in Macros

Using the Personal Macro Workbook

Going On from Here

A macro is a set of instructions telling Microsoft Office Excel 2007 (or another application) to perform one or more actions for you. Macros in Office Excel 2007 are like computer programs, but they run completely within Excel. You can use them to automate tedious or frequently repeated tasks.

Macros can carry out sequences of actions much more quickly than you could yourself. For example, you can create a macro that enters a series of dates across one row of a worksheet, centers the ...