Running an Excel Macro from a Graphic

Its easy to set up

These days running a macro off a control button seems to be old school and many people have started running macros off graphics.

This is probably because buttons on websites now have a more sophisticated look and people want to replicate that look in their spreadsheets.

There are many formatting options for graphics in Excel and you can quickly and easily create professional looking buttons – see example below.

macro_graphic_01

 

When a graphic is selected, the Format ribbon tab provides many professional formatting options.

macro_graphic_02
It is easy to run a macro off a graphic in Excel. Simply right click the graphic and select Assign Macro.

macro_graphic_03

The available macros are listed as per the dialog below.

 

macro_graphic_04
Select a macro and click OK to complete the process. Clicking the graphic will run the macro.

Please note: I reserve the right to delete comments that are offensive or off-topic.