call a Macro when refresh is clicked

[vvbkumar]

Hi,
I have a requirement, where whenever the user clicks refresh / refresh all, i need to call a macro. I tried using BeforeRefresh() and AfterRefresh(), but somehow those are not working.
can anyone help me on this.

[starryknight64]

Could you be any more specific?

Post an example spreadsheet if you have to.

[vvbkumar]

Hi,
Sorry for the lack in clarity.
In my workbook, i have 2 sheets. each sheet has a query table. when the user clicks on refresh / refresh all (for refreshing the Query table), i need to call a macro / function to perform an operation before refreshing the query tables.