Advertisement
Online Test Banks
Score higher
See Online Test Banks
eLearning
Learning anything is easy
Browse Online Courses
Mobile Apps
Learning on the go
Explore Mobile Apps
Dummies Store
Shop for books and more
Start Shopping

How to Run an Excel 2010 Macro

After you create an Excel 2010 macro, either by using the macro recorder or by creating it in Visual Basic for Applications (VBA), you run the macro to have it carry out the commands and keystrokes that are saved as part of the macro.

The macro commands in Excel 2010 are located on the Developer tab, which doesn't appear on the Ribbon by default. To display this tab, click the File tab and then click Options. Select Customize Ribbon in the left pane, and then click the Developer check box under Main Tabs on the right side of the dialog box. Click OK.

Follow these steps to run an existing macro in Excel 2010:

  1. Click the Macros button in the Code group of the Developer tab.

    The Macro dialog box appears. Excel lists the names of all the macros in the current workbook and in your Personal Macro Workbook (provided you've created one) in the Macro Name list box.

  2. Click the name of the macro in the list box and click the Run button.

    Selecting the macro to run in the Macro dialog box.
    Selecting the macro to run in the Macro dialog box.

If you assigned a shortcut keystroke to the macro, you don't have to open the Macro dialog box to run the macro. Simply press the shortcut keys that you assigned and Excel immediately plays back all of the commands that you recorded.

If you run your macro in a worksheet that already contains data in the cells that the macro uses, you run the risk of having existing data and/or formatting overwritten during the macro's execution. Keep in mind that, although you can use the Undo feature to reverse the very last action performed by your macro, most macros perform a series of actions, so you may end up using multiple levels of Undo before you are able to successfully reconstruct your worksheet.

If you no longer need a macro that you've created or you want to scrap one and start over again, you can easily delete the macro. Click the Macros button in the Code group of the Developer tab, select the macro you want to remove in the Macro dialog box, and click the Delete button.

blog comments powered by Disqus
Advertisement
Advertisement
Learning anything is easy with For Dummies eLearning!

Inside Dummies.com

Dummies.com Sweepstakes

Win an iPad Mini. Enter to win now!