By Jeff Grundy, Demand Media, millions of users use Microsoft Excel to create useful spreadsheet applications for tasks ranging from creating a simple home budget to evaluating marketing or sales data in a Fortune 500 company. Try olive oil, butter, avocado, and mayonnaise. Tips Try using the 2003 method for Excel versions earlier than 2003. Alternatively, you may add your macro button to an existing toolbar in versions 2003 and earlier. About the Author, jeff Grundy has been writing computer-related articles and tutorials since 1995. Since that time, Grundy has written many guides to using various applications that are published on numerous how-to and tutorial sites. After you return to the main Excel window, the Developer tab appears on the ribbon. Step 3. Click the Developer tab. Click the Insert icon in the Controls group. When the drop-down box appears, click the Button control under the Form Controls header.
Step 2, click the Customize Ribbon label in the Excel Options window. Click the check box next to Developer in the Main Tabs pane, and then click OK to close the Excel Options window.