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 Add an Excel 2007 Macro to the Quick Access Toolbar

You can assign a macro created in Excel 2007 to a custom button on the Quick Access toolbar and then run it by clicking that button. This provides quicker access to a macro than using the Macro dialog box.

1

Click the Office Button and then click the Excel Options button.

The Excel Options dialog box appears.

2

Click the Customize tab.

The Customize options appear in the right pane.

3

Click Macros in the Choose Commands From drop-down list box.

Excel lists the names of all macros created in the current workbook and those saved in the PERSONAL.XLSB workbook in the Choose Commands From list box.

4

Select the name of the macro and click the Add button.

The macro appears in the list box on the right side of the dialog box.

5

Click the macro name in the list box on the right and then click the Modify button.

The Modify Button dialog box appears.

6

Select an icon to use for the button.

This is the icon that will appear on the Quick Access toolbar to represent your macro.

7

Click OK two times.

Both dialog boxes close and the macro button appears on the Quick Access toolbar.

To remove the macro button from the Quick Access toolbar, simply right-click the button and select Remove from Quick Access Toolbar.

blog comments powered by Disqus
Advertisement
Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win an iPad Mini. Enter to win now!