O'Reilly logo

Learn Excel 2011 for Mac by Guy Hart-Davis

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required