PlayInfoBox

Home /Utilities /How to Create a Clickable Macro Button in Excel

How to Create a Clickable Macro Button in Excel

Turn a macro that only power users remember into a button anyone on the team can click.

  1. Prepare the macro first

    Record or write the macro you want the button to trigger before you start adding the button.

  2. Go to Developer β†’ Insert

    On the Developer tab, click "Insert" and choose "Button" under Form Controls.

  3. Draw the button where you want it

    Click and drag on the worksheet to draw the button shape at the location you want.

  4. Assign the macro

    In the dialog that appears after drawing the button, select the macro to run and click OK.

  5. Why this matters

    Instead of remembering a macro's name to run it, anyone can just click a labeled button β€” no Excel expertise required.

One click instead of remembering a macro name

When you need to share a workbook with a colleague who is not comfortable navigating the Macro menu, placing a labeled button directly on the sheet lets them run the automation without ever knowing a macro name exists.

Customizing the button afterward

You are not stuck with the default look: right-click the button to edit its text, resize it, or change its font and alignment through "Format Control." You can also reassign a different macro to the same button later if your workflow changes, without recreating it from scratch.

Frequently Asked Questions

Can I change the button's shape or color?

Right-click the button and choose "Edit Text" to change its label, or use "Format Control" to adjust its font and alignment.

Can I change which macro a button runs later?

Yes β€” right-click the button, choose "Assign Macro" again, and pick a different one at any time.