Your “Say_Hello” button can’t appear anywhere except in the Quick Access Toolbar, and it can do nothing but run a macro. Your “Say_Hello” button now appears on the Quick Access toolbar.Īlthough this is the easiest method, it is also the least flexible. From the dialog box that appears, choose “ Macros” for “ Choose commands from:” and select your macro from the list.

Choose “ Customize Quick Access Toolbar.”.

Right-click a blank area of the ribbon.

The simplest way to add a button for “Say_Hello” is to add it to the Quick Access toolbar, which is displayed in the Excel window title bar.

From the “ File” menu, choose “ Options.”ġ.If there is no “ Developer” tab, then add it: Look at the far right of your Excel ribbon. In this example, we’ll add a button for the macro titled “Say_Hello.” Before you can use any of these methods, however, you must have the Developer tab available on the ribbon. Add a button to the Quick Access Toolbar.The easiest way is to add a macro button to your spreadsheet, for which Excel offers three straightforward methods: But, once you have a macro, how do you access it? If you’ve ever repeated the same actions multiple times in a spreadsheet, you’ll benefit from recording a macro to automate those tasks.

Customize excel shortcut keys