Microsoft® Excel® 2010 Inside Out

Chapter 27. 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 that tells Microsoft Excel 2010 (or another application) to perform one or more actions for you. Macros in Excel 2010 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 can yourself. For example, you can create a macro that enters a series of dates across one row of a worksheet, centers the date in each ...