How to Add an Excel 2010 Macro to the Quick Access Toolbar

The following process details how to add a Macro shortcut to the Toolbar which will be available to all opened Excel documents.

Create a ‘Personal.XLSB’ file

To make the macros available you need to create a ‘personal.xlsb’ file and save the macro into it.

Each time you open a new or existing excel document the ‘personal.xlsb’ file will be opened to enable the macros.

  1. Open a new Excel file, configure your macros as required
  2. Save the file as Personal.xlsb in the folder – C:\Program Files\Microsoft Office\Office14\XLSTART
  3. Close Excel

Configure the Quick Access Toolbar

  1. With Excel open right click on the Quick Access Toolbar and select ‘Customize Quick Access Toolbar’
  2. MSExcel2010-QuickAccessToolbar
  3. Under ‘Choose commands from:’ select ‘Macros’
  4. Select the Macros as previously configured and then click on ‘Add’
  5. To customise the macro icon, select the macro and then the ‘Modify’ button
  6. Select the desired icon for each the macro.
  7. Click on ‘OK’ and ‘OK’ to save the changes.

Was this article helpful?

Related Articles