Running Macros from Buttons

With v2.6.0 of the Analytics Edge Core Add-in, it is now possible to run a specific Analytics Edge macro from a button on your worksheet (the Analytics Edge Core Add-in must be installed). This opens the door to interactive refreshes without having to navigate the Task Pane controls.

add-a-buttonassign-macroStarting with a workbook containing an Analytics Edge macro, add a Form Control Button to your worksheet.

When prompted for the Macro name, enter AnalyticsEdge.RunMacro

Click OK.

Note: the workbook can be saved with XLSX format. An Analytics Edge macro is not an Excel macro and does not require a macro-enabled workbook.

With the button still selected (right click on the button if you need to select it), change the button name to match the name of the macro to be run when you click the button. You enter the button name in the Name box, located to the left of the formula bar:

add-a-button

That’s it! Now you can just click the button to run the Analytics Edge macro!