Running a Macro
After you record a macro (or create it from scratch, as described later in this chapter), you can run it as needed by pressing its keyboard shortcut, adding it to a toolbar or menu, or by attaching it to an object in a worksheet.
For you to be able to run the macro, the workbook that contains it must be open. If you stored the macro in the Personal Macro Workbook, you can run it at any time, because, after you create the Personal Macro Workbook, Excel keeps the Personal Macro Workbook open in the background whenever you run Excel. If you stored the macro in a workbook, you must open that workbook before you can run the macro.
Running a Macro from the Macro dialog Box
You can run any macro from the Macro dialog box. This is useful ...
Get Learn Excel 2011 for Mac now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
