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, …

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.

Add a button on your slide and then apply an action to it such as 'Next' or 'Previous' or a hyperlink to a URL or even another presentation.

Macros can help you automate repetitive tasks and save time. You can use the macro recorder to record the macro or write your own macro script in VBA.

When you create a macro, you are recording your mouse clicks and keystrokes. After you create a macro, you can edit it to make minor changes to the way it works.

By using the Command Button Wizard, you can quickly create command buttons that do a variety of tasks, such as closing the form, opening a report, finding a record, or running a macro.

This article shows you how to add macros to user interface elements such as forms or command buttons in Access desktop databases, allowing you to automate tasks you perform often.

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

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.