Excel 2016 Macros

Excel 2016

Lesson 4 – Creating Macro Buttons

Steps

Practice Data

8. Select the button text.

Select the Button 2 text

The button text is selected.

9. Type the desired button text. The text appears on the button. 10. Select any cell in the worksheet to deselect the button. The button is deselected.

Type Open Chicago

Click anywhere in the worksheet

Click the macro button to test it. Notice that the Chicago workbook opens. Close CHICAGO.XLSX.

C OPYING A M ACRO B UTTON  D ISCUSSION

You can create new macro buttons quickly by copying existing ones. This option is useful in adding several similar macro buttons to a worksheet. When you copy a macro button, the pasted macro buttons will always be the same size and shape as the copied macro button.

After copying the button, you can assign a different macro to the copy and then edit the text on the button.  P ROCEDURES 1. Open the desired workbook and enable the macros. 2. Hold [Ctrl] and drag the macro button you want to copy to where you want the copy to appear. 3. Release the mouse button. 4. Release the [Ctrl] key. 5. Select a cell in the worksheet to deselect the macro button copy. 6. Right-click the macro button copy. 7. Select Assign Macro from the shortcut menu. 8. Select the desired macro from the list in the Assign Macro dialog box.

9. Select . 10. Select the text you want to edit on the macro button copy. 11. Type the desired text. 12. Select a cell in the worksheet to deselect the macro button copy.



S TEP - BY -S TEP

Copy a macro button.

OFFICEPRO, Inc.

Page 63