Create a toolbar button or menu item to run a Macro

Excel 2007
If you assigned a key combination to a macro when you recorded it, you can run the macro by pressing that key combination. If not, you can subsequently assign the macro to the menu item.

Follow these steps:

   1.    Choose Tools -> Customize... to display the Customize dialog box, choose the Commands tab:

Customize Excel 2003

   2.    Select the Macros category to display the list of macros.

   3.    Drag the Custom Menu Item to a menu to create a menu item, or drag the Custom Button item to a toolbar to create a toolbar button:

Item Excel 2003

   4.    With the menu item or toolbar button selected, click the Modify Selection button in the Customize dialog box and choose Assign Macro...:

Assign Macro Excel 2003

   5.    In the Assign Macro dialog box, select the macro to associate with the menu item or toolbar button. If necessary, change the selection in the Macros In drop-down list so that the macro you need is displayed:

Macro Excel 2003

   6.    Click the OK button to close the Assign Macro dialog box and assign the macro.

   7.    Click the Modify Selection button in the Customize dialog box again and use its commands to edit the display name to make it easy to understand or assign a suitable button, or both.

   8.    Click the OK button to close the Customize dialog box.

For more information about how to customize menu and buttons, see Creating your own menu.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.