Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- DownloadDownload
- PrintPrint
13. Automating Repetitive Tasks with Macros
|
In this chapter, you will learn to: | |
|
? |
Describe and examine macros. |
|
? |
Create and modify macros. |
|
? |
Run macros when a button is clicked. |
|
? |
Run macros when a workbook is opened. |
Many tasks you perform in Microsoft® Office Excel® 2007 (for example, entering sales data for a particular day or adding formulas to a worksheet) are done once or (for example, changing the format of a cell range) can be repeated quickly using available tools in Office Excel 2007. 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 that contain important data you use quite often in presentations to your colleagues. Instead of going through a lengthy series of steps to highlight the cells with the important information, you can create a macro, or a recorded series of actions, to perform the step....
