Microsoft Excel X for Mac OS X: Visual QuickStart Guide

Macros

A macro is a series of commands that Excel can perform automatically. You can create simple macros to automate repetitive tasks, like entering data or formatting cells.

Although macros are created with Excel's built-in Visual Basic programming language, you don't need to be a programmer to create them. Excel's Macro Recorder will record your keystrokes, menu choices, and dialog settings as you make them and will write the programming code for you. This makes macros useful for all Excel users, even raw beginners.

To record a macro with the Macro Recorder

1.	Choose Tools > Macro > Record New Macro (Figure 51) to display the Record Macro dialog (Figure 52), Figure 51. The Macro submenu under the Tools menu offers commands for working with ...