Forum Discussion

Scott Stilwell

Copper Contributor

Feb 23, 2018

Macro execution

How do I attach a macro to a button so the user merely has to click the button to execute the macro?

Macros and VBA

Damien_Rosario

Silver Contributor

Feb 23, 2018

Hi Scott

Try this:

1. In the Developer menu tab, click onto Insert and add the click onto the very first icon in the list, top left.

Note: If you don't have it then right click onto the View menu text, Customize the ribbon and add Developer.

2. Drag and make the button the size you want. When you do an Assign Macro box will appear asking you to name the Macro name.

3. You can also click onto New button which will open VBA code window for you to put code against, or Record so you can make a macro based on your actions.

Hope that helps?

Cheers

Damien