Excel 2016 Macros

Excel 2016

Lesson 4 – Creating Macro Buttons

C REATING A M ACRO B UTTON  D ISCUSSION

The Insert button in the Controls group on the Developer tab is used to create a macro button. You drag to draw a button of the required size and position on the worksheet. After you have drawn the macro button, you must assign a macro to it.

When the macro button is clicked, the macro attached to it runs.

Choosing Icons for a Macro

NOTE You can resize a macro button at any time and reposition it anywhere on the worksheet.



P ROCEDURES

1. Open the desired workbook and enable the macros. 2. Select the Developer tab.

3. Select in the Controls group. 4. Select the Button (Form Control) button in the Form Controls section of the Controls gallery. 5. Drag as needed to create the button. 6. Release the mouse button. 7. Select the macro you want to assign to the button.

OFFICEPRO, Inc.

Page 61