Excel 2016 Macros

Lesson 4 – Creating Macro Buttons

Excel 2016

8. Select 9. Select the existing button text. 10. Type the desired button text. 11. Select any cell in the worksheet to deselect the button.



S TEP - BY -S TEP

Create a macro button.

If necessary, enable the macros and make sure that your current folder is set for the path containing the student data files.

Steps

Practice Data

1. Select the Developer tab.

Click Developer

The Developer tab is displayed.

2. Select the Insert button in the Controls group. The Controls gallery opens. 3. Select the Button (Form Control) button in the Form Controls section of the Controls gallery. The mouse pointer changes into a crosshair when positioned in the worksheet. 4. Drag as needed to create the button. An outline appears as you drag.

Click

Click

Drag from the top-left corner of cell H4 to the bottom-right corner of cell I4

5. Release the mouse button. The button appears on the

Release the mouse button

worksheet, and the Assign Macro dialog box opens.

6. Select the macro you want to assign to the button. The macro name appears in the Macro name box.

Click Chicago

7. Select OK .

Click

The Assign Macro dialog box closes and the macro is assigned to the button.

Page 62

OFFICEPRO, Inc.