Excel 2016 Macros

Excel 2016

Lesson 4 – Creating Macro Buttons

Steps

Practice Data

10. Type the desired text.

Type New York

The text appears on the macro button.

11. Select a cell in the worksheet to deselect the macro button. The macro button is deselected.

Click anywhere in the worksheet

Click the Open New York macro button to test it. Notice that the NEWYORK.XLSX workbook opens.

Close NEWYORK.XLSX.

F ORMATTING A M ACRO B UTTON  D ISCUSSION You can format text on a macro button in much the same way as you format text on a worksheet. You can select the entire button and apply the same formats to all the button text, or you can select individual characters in the button text to format.

NOTE To select a macro button for editing, hold the [Ctrl] key as you click the macro button; otherwise, the macro attached to the button runs when you click it.



P ROCEDURES

1. Select the Home tab in the Ribbon . 2. To format all the button text, hold [Ctrl] and click the macro button you want to format. 3. Release the [Ctrl] key. 4. Format the macro button text as desired. 5. Select any cell in the worksheet to deselect the macro button. 6. To format selected macro button text, hold [Ctrl] and click the macro button you want to format. 7. Release the [Ctrl] key.

8. Select the text you want to format. 9. Format the selected text as desired. 10. Select a cell in the worksheet to deselect the macro button.

OFFICEPRO, Inc.

Page 65