Microsoft Office Tutorials and References
In Depth Information
Chapter 12: Working with macros and forms
Working with 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.
▪ Insert form controls and set form properties.
Many tasks you perform in Microsoft Excel 2013 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, you
probably have 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 that have 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
Another handy feature of Excel macros is that you can create macros that run when a
workbook is opened. For example, you might want to ensure that no cells in a worksheet are
highlighted when the worksheet opens. You can create a macro that removes any special
formatting from your worksheet cells when its workbook opens, which enables you to
emphasize the data you want as you present the information to your colleagues.