The Quick Access Toolbar (QAT) can really speed up your work in Excel. You can even attach macros to the QAT.
The QAT is that horizontal bar either above or below the ribbon – see below.
This post will demonstrate how to add a macro icon to the QAT.
Right click the QAT and choose Customize Quick Access Toolbar.
Scroll down, find and select the macro. Double click the macro or select it and click the Add button. It will appear on the right hand side of the screen.
Click the Modify Button and select an icon to use.
You can click in the Display name box and modify the name that will display when you point to the icon on the QAT.
Click OK and then click OK again to return to the Excel Grid. The icon is added to the end of the QAT.