How To Add A Macro To The Quick Access Toolbar

2016-12-12

Do you have a favourite? Maybe you want to be able to run it easily without going to the Developer tab > Macros button > select it from the Macros window and hitting the Run button? There is a quicker way (without assigning a keyboard shortcut), you can have it readily available by adding it to the Quick Access Toolbar (QAT).

In this example we’ll assign a simple macro that auto adjusts the column width to the data in the sheet. See my post about creating a macro to make your own.

Step 1: Open the QAT options window.

Step-001-How-To-Add-A-Macro-To-The-Quick-Access-Toolbar How To Add A Macro To The Quick Access Toolbar

Add a macro to the QAT.

  1. Click the Options button to the right of the Quick Access Toolbar.
  2. Select the More Commands from the option drop down list.

Step 3: Assign your macro.

Step-002-How-To-Add-A-Macro-To-The-Quick-Access-Toolbar How To Add A Macro To The Quick Access Toolbar

Select the Macro you want to add to the QAT.

  1. In the Choose commands from drop down select Macros.
  2. Select the macro you want to add quick access to. Remember, you will only see macros if they are in the current workbook or your personal macro workbook and you will only be able to run the macro in another workbook if it’s globally available in the personal macro workbook.
  3. Press the Add button.
  4. Press the OK button.

Step 3: Run your macro from the QAT.

Step-003-How-To-Add-A-Macro-To-The-Quick-Access-Toolbar How To Add A Macro To The Quick Access Toolbar

Now you will be able to run your macro easily from the QAT. If you forget what macro you’ve assigned to the QAT, you can hover your mouse cursor over the icon and the name of the macro will show.

QAT-customisation-menu-shortcut How To Add A Macro To The Quick Access Toolbar

Tip: You can also access the customization menu easily by right clicking anywhere on the quick access toolbar and selecting Customize Quick Access Toolbar.

About the Author

John MacDougall

John MacDougall

John is a Microsoft MVP and freelance consultant and trainer specializing in Excel, Power BI, Power Automate, Power Apps and SharePoint. You can find other interesting articles from John on his blog or YouTube channel.

Subscribe

Advertisement

Related Articles

37 Awesome Excel Mouse Tips & Tricks You Should Know

37 Awesome Excel Mouse Tips & Tricks You Should Know

While the keyboard is generally quicker, you shouldn’t completely ignore the mouse. There are also some great time saving mouse shortcuts as well. In this post we’ll take a look at some of the best Excel mouse time saving tips and tricks.

read more
25 Amazing Power Query Tips and Tricks

25 Amazing Power Query Tips and Tricks

Power query is amazing tool that allows you to import and transform data with ease and helps to create repeatable and robust procedures with your data. Here are some tips and tricks to help you get the most out Power Query.

read more

Comments

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Get The Latest News

Follow Us

Follow us on social media to stay up to date with the latest tips in Excel!

Pin It on Pinterest

Share This