Has anyone had the same problem please? I have registered a Callback_AfterRedisplay routine in my Analysis workbook. It's meant to run a macro after all data sources have refreshed. Problem is it also gets triggered after many other events, for example when I save the workbook. I have managed to avoid that by adding unregister call back routines to different Worksheet events, so that's fine, although not elegant.
But I am unable to fix one other thing. Namely, when you cancel the Prompts box. It still runs the macro although none of the data sources get refreshed. Any ideas how to fix this? I only want to be able to run the macro after one event - when all data sources are refreshed, NOT when I cancel or save the workbook, or drill down within query, or set filters etc.
Many thanks,
AL
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.