Adding Macros to the Quick Access Toolbar

Contact Us or call 1-877-932-8228
Adding Macros to the Quick Access Toolbar

Adding Macros to the Quick Access Toolbar

The reason to create a macro is to make it easier to complete a set of operations that you regularly perform. Given this, it is likely that you need to run the macro frequently. To make it easy to do so, you can add the macro to the Quick Access Toolbar.

To add a macro to the Quick Access Toolbar:

  1. Click the Customize Quick Access Toolbar drop-down arrow:Customize Quick Access Toolbar
  2. Select More Commands:More Commands
  3. In the Excel Options dialog box on the Quick Access Toolbar tab, from the Choose commands from drop-down list, select Macros:Excel Options Dialog Box
  4. Select the macro you want to add to the Quick Access Toolbar and click Add and then OK:Select Macro
  5. You can now see and run the macro on the Quick Access Toolbar:Quick Access Toolbar

Managing Macro Security

When working with macros, it is important to maintain security, that is, ensure that no dangerous code is going to be run.

To enable security when working with macros in Excel 2013:

  1. Enter Backstage View by selecting FILE > Options. Backstage View
  2. In the Excel Options dialog box, select Customize Ribbon. Excel Options Dialog Box
  3. Under Customize the Ribbon, on the right, check the Developer check box and then click OK. Developer Checkbox
  4. Now, on the DEVELOPER tab, in the Code group, select Macro Security. Macro Security
  5. Use the options in the Trust Center dialog box to set security options. Trust Center Dialog Box
Next