This will open the Excel Options page, and Customize Ribbon should already be highlighted on the left-hand side. To add a button to the ribbon, start by right-clicking anywhere on the ribbon or ribbon tabs.

Checkout my post & video on the Personal Macro Workbook if you don't have yours setup yet.

The Quick Access Toolbar is the line of icons found at the very top of the Excel page.Īgain, you will most likely want to store the macros for these buttons in your Personal Macro Workbook because that file opens every time you open Excel. The ribbon is the tabbed menu that is found just above the formula bar. One way to make your macros more accessible is by storing them in your Personal Macro Workbook and then creating buttons for them, so that they can run with just a simple click.Ĭreating buttons for macros basically requires you to customize either the Excel Ribbon or the Quick Access Toolbar. But like any tool, they should be kept near at hand so that they can be used right when you need them. They make things faster and easier and are tools that accomplish specific tasks. Macros are simply pieces of code that automate tasks and procedures. Watch on YouTube Macros Are Tools in Your Toolbelt

Quick access popup change icon resource