In the sections below, learn how to add a macro to a button in Excel—for Windows or the Mac. Note: ActiveX controls are not supported on the Mac.

You can assign a macro to a button on the Quick Access Toolbar or to a button in your own personal group on the ribbon. If you want a macro button to be available in other workbooks, assign it to a …

Oct 14, 2025 · Automate Form controls and ActiveX controls by assigning macros to the control using the steps in this article.

Oct 14, 2025 · Automate Form controls and ActiveX controls by assigning macros to the control using the steps in this article.

Suppose that every month, you create a report for your accounting manager. You want to format the names of the customers with overdue accounts in red, and also apply bold formatting. You can …

Select the new macro (it's named something like Normal.NewMacros.<your macro name>) and select Add. Select a button image, type the name you want, and select OK twice.

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. To do that, see Assign a macro to a button.

To automate a repetitive task, you can record a macro with the Macro Recorder in Microsoft Excel. Imagine you have dates in random formats and you want to apply a single format to all of them.

For example, you can programmatically add a separate option button for each letter of the alphabet or you can add a check box for each item in a large list of dates and numbers.

Improve security, evaluate and mitigate the risks of running macros, and see how to enable or disable macros for Microsoft 365.