Run Macro before burst is greyed out


#1

Sorry, couldn’t add this to the Extend Topic.

I have access to the VBA project object model, have written a macro and saved the template as .xlsm


#2

I didn’t mention this is using the Report Burster


#3

Hi @mmacdonnell,

It usually looks for any public macros in the workbook.

Did you have a Public Sub Routine declared?


Paul


#4

Thanks Paul,

That’s fixed it.

Regards

Mal


#5

Great! Thanks for the confirmation!


Paul