Skip to content

 

Adding VBA Macros to the Quick Access Toolbar

Bookmark and Share

When you are customizing the Quick Access Toolbar, the left drop down offers a setting for Macros. This will display all of the macros available in open workbooks, plus macros available from installed add-ins.

Each macro has an identical icon. Choose a macro from the list and click the Add button to add it to the QAT. After adding the macro to the QAT, you can select the macro in the right listbox and choose Modify.

The Modify Button dialog appears with 200 new icons. Try to fi nd an icon that might work with your macro. Also, you can type a new name for the button. This name will appear as a tooltip when you hover over the icon in the QAT.