Automate the refresh of an excel addin

[mountainman88]

I use an excel add-in to extract data from the Onestream XF financial planning system. The addin tab has a refresh button per the below.

What are my options to automate this refresh button? I tried recording a macro and clicking it but with no luck

thanks

 

[RasGhul]

You could add the following to a sheetChange event

Private Sub Worksheet_Change(ByVal Target As Range)

    ThisWorkbook.RefreshAll

End Sub

 

[mountainman88]

You could add the following to a sheetChange event

Private Sub Worksheet_Change(ByVal Target As Range)

    ThisWorkbook.RefreshAll

End Sub

How does this work when the refresh is on an addin and not anywhere I can see in the connections list?

I actually have too many sheets to refresh all of them I would need to set up a loop to go through each tab and refresh that tab.

Thanks