Add the Macro to a Button

Macros are more User Friendly if they can be found on a button. The quickest way to add a Macro to a button is with the Backstage Options. On the following pages, we will create a new Group on the Home Ribbon, then add the Macro to the Group.

 

2. Try it: Go to the Backstage

Go to File ->Options

 

Keep going...!

Exam 77-888: Microsoft Excel Expert 2010

4. Working with Macros and Forms

4.1. Create and manipulate macros: Run a Macro from a button

File ->Options