• Add a button (Form control)
• Display the Developer tab

Add a button (Form control)

1. If the Developer tab is not available, display it.

2. On the Developer tab, in the Controls group, click Insert, and then under Form Controls, click Button .

3. Click the worksheet location where you want the upper-left corner of the button to appear.

4. Assign a macro to the button.

5. To specify the control properties of the button, right-click the button, and then click Format Control.

Display the Developer tab

1. Click the Microsoft Office Button , and then click Excel Options.

2. In the Popular category, under Top options for working with Excel, select the Show Developer tab in the Ribbon check box, and then click OK.