Microsoft Office Tutorials and References
In Depth Information
by Using Macros
In this chapter, you will learn how to
✔ Enable 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 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 several 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, which is a recorded series of actions, to perform the steps for you. After you
have created a macro, you can run, edit, or delete it as needed.
In Excel, you run and edit macros by using the items available in the Macros group on
the View tab. You can make your macros easier to access by creating new buttons on the
Quick Access Toolbar, to which you can assign your macros. If you run a macro to highlight
specific cells in a worksheet every time you show that worksheet to a colleague, you can
save time by adding a Quick Access Toolbar button that runs the macro to highlight the
cells for you.