How To Add A Macro To The Quick Access Toolbar

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

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

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

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.

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 qualified actuary with over 15 years of experience. He has worked in a variety of industries, including insurance, ad tech, and most recently Power Platform consulting. He is a keen problem solver and has a passion for using technology to make businesses more efficient.

Related Posts

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

Get the Latest Microsoft Excel Tips

Follow Us

Follow us to stay up to date with the latest in Microsoft Excel!

Subscribe for awesome Microsoft Excel videos 😃