Microsoft® Excel® 2010: Step by Step

Chapter 12. Automating Repetitive Tasks by Using Macros

Chapter at a Glance

In this chapter, you will learn how to
✓	Enabling and Examining Macros.
✓	Creating and Modifying Macros.
✓	Running Macros When a Button Is Clicked.
✓	Running Macros When a Workbook Is Opened.

Many tasks you perform in Microsoft Excel 2010 are done once (for example, entering sales data for a particular day or adding formulas to a worksheet) or can be repeated quickly by using tools in Excel (for example, changing the format of a cell range). However, there are probably one or two tasks you perform frequently that require a lot of steps to accomplish. For example, you might have ...