Hi
I need pivot tables to be refreshed on leaving a specific sheet in my workbook. How do I trigger a macro on leaving a sheet ?
Currently, the refresh part is being done using a simple macro (refresh all) and the trigger is on a form button.
Thanks!
N
Bookmarks