Create Or Run Macro. On the worksheet with the cell you need to click to run a Macro right click the sheet tab and then click View Code from the context menu. Select the macro youd like to assign to the button and click on OK.
Trigger or run a Macro by clicking a specific cell. Its important to note that the two macros DO NOT run at the same time. Once the Call line is.
When you have inserted your shape right click it and select Assign Macro Then select the macro you want to run when the shape is clickedperhaps the one you just made with a recording and save it by clicking OK.
From the dialogue box displayed click on Customize Ribbon option. In the list under Macro name click the macro you want to run. Developer tab is not visible on the ribbon by default and you may need to add it before using it. Click View Macros View Macros.