Run Macro before burst is greyed out

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

I didn’t mention this is using the Report Burster

Hi @mmacdonnell,

It usually looks for any public macros in the workbook.

Did you have a Public Sub Routine declared?


Paul

Thanks Paul,

That’s fixed it.

Regards

Mal

Great! Thanks for the confirmation!


Paul