You can use a Form control button or a command button (an ActiveX control) to run a macro that performs an action when a user clicks it. Both these buttons are also known as a push button, which can be set up to automate the printing of a worksheet, filtering data, or calculating numbers.

You can create a custom group that appears on a tab in the ribbon and then assign a macro to a button in that group. For example, you can add a custom group named "My Macros" to the Developer tab and then add a macro (that appears as a button) to the new group.

You use a command button on an Access form to start an action or a set of actions. For example, you can create a command button that opens another form. To make a command button perform an action, you write a macro or event procedure and attach it …

You can use a button (a form control) to run a macro that performs an action when a user clicks it. For example, you might use a button to automate the printing of a worksheet, the filtering of data, or the calculation of numbers.

This procedure creates a button in the workbook that runs the script when the button is selected. It also shares the script with anyone who can edit the workbook. Select Automate , and then select the script you want to run.

To learn more about creating macros, see Create or delete a macro. To learn about how to run a macro, see Run a macro.

If you create a lot of macros, the description can help you quickly identify which macro does what, otherwise you might have to guess. Click OK to start recording. Perform the actions that you want to record. On the Developer tab, click Stop Recording. Working with recorded macros in Excel

You might want a macro you recorded to run automatically when you open a specific workbook. The following procedure uses an example to show you how that works. You may also want to run macros automatically when Excel starts.

To run a macro, select the button on the Quick Access Toolbar, press the keyboard shortcut, or you can run the macro from the Macros list. Select View > Macros > View Macros. In the list under Macro name, select the macro you want to run. Select Run.

Perform an action or operation when a user clicks a form control by assigning a macro to it. Run Microsoft Visual Basic for Applications (VBA) code to process any events that occur when a user interacts with an ActiveX control. For more information about how to create macros, see Create or delete a macro. Add or edit a macro for a form control