Excel 2016 Macros

Excel 2016

Lesson 4 – Creating Macro Buttons

Steps

Practice Data

10. Select any cell in the worksheet to deselect the macro button. The macro button is deselected.

Click anywhere in the worksheet

Practice the Concept: Bold the text on all macro buttons; then italicize the city names on each macro button.

M OVING /S IZING A M ACRO B UTTON  D ISCUSSION You can move or size a macro button in the same way that you move or size any graphic object on a worksheet. To move or size a macro button, you must first select it.

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



P ROCEDURES

1. To move a macro button, hold [Ctrl] and click the macro button to select it. 2. Release the [Ctrl] key. 3. Point to the shaded border around the button and drag the selected macro button to the desired location on the worksheet. 4. Release the mouse button. 5. Select a cell in the worksheet to deselect the macro button. 6. To size a macro button, hold [Ctrl] and click the macro button to select it. 7. Release the [Ctrl] key. 8. Drag any sizing handle in the desired direction. 9. Release the mouse button. 10. Select a cell in the worksheet to deselect the macro button.



S TEP - BY -S TEP Move and size a macro button.

OFFICEPRO, Inc.

Page 67