Chapter 12. Automating Repetitive Tasks with Macros

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 ...

Get Microsoft® Office Excel® 2003 Step by Step now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.