Excel2007:Developer

Add Developer tab
To use the forms controls in Microsoft Office Excel 2007, you must enable the Developer tab. To do this, follow this steps: (Microsoft, 2009)
 * 1) Click the Microsoft Office Button, and then click Excel Options.
 * 2) In the Popular tab, click to select the Show Developer tab in the Ribbon check box, and then click OK.

Adding a button

 * 1) Use the Developer > Insert > Form Controls (Button)
 * 2) Make the text on button meaningful.
 * 3) Then right click on the button to assign your macro (otherwise it will continue to give you an edit option)

Save the workbook as:
 * Excel 97-2003 Workbook(*.xls) or
 * Excel Macro-Enabled Workbook(*.xlm)

Note: You may need to close the spreadsheet then reopen and click the Options button on the Security warning and "Enable this content" before the button will work.

Example: Advanced Filter Example with Button


Example vmvXL07_button.xls or vmvXL07_button.xlsm