Microsoft® Office Excel® 2003 Step by Step

Chapter 12. Automating Repetitive Tasks with Macros

Chapter 12 at a Glance

In this chapter you will learn to:

✓ Open and run macros.

✓ Create and modify macros.

✓ Create toolbars and menus to hold macros.

✓ Run a macro when a workbook is opened.

Many tasks you perform in Microsoft Excel, such as entering sales data for a particular day or adding formulas to a worksheet, either are done once or, like changing the format of a cell range, can be repeated quickly using available tools in Excel. However, you will often perform one or two tasks frequently that require a lot of steps to accomplish. For example, you might have a number of cells in a worksheet ...