Multiple seperate Worksheet Events - Order

[Jabba69]

Hi
I hope someone can help...

I have created a dashboard with a few 'report' tabs and many hidden tabs.
2 of the hidden tabs have Worksheet_PivotTableUpdate Events, that basically do some things on some of the hidden tabs, when Slicers are used on the 'report' tabs by the user. They then finish on the given original report worksheet.

This works fine in terms of the usability of the report.

However, when the report is refreshed (eg 'refresh all' - connections), although it works ok, it always Selects the same report tab once refreshed - and its not the one I want it to be.
Via trial and error I've come to the conclusion that it must be down to the Order in which the Events are run.
I've tried renaming the actual property of the Sheet name so its in the order of preference, but no luck. I've also tried just renaming the actual report tabs, and the hidden tabs with the Event procedures, and still no luck.

Is there any way I can force the Events to run in a particular order on Refresh??

Hope this makes sense!

Thanks

[AlphaFrog]

You could create a macro that 'refresh all' - connections and at the end it selects your prefered sheet.

[Jabba69]

Thanks AlphaFrog

yes this is kind of the solution I've come up with - I have a separate 'reports updater' which is a sort of switchboard that allows we to update a variety of reports - I've added a line of code to select the relevant sheet.

I guess I was more just curious as to whether you can specify the order that events are run? Or what is it that determines the order?

Thanks

[AlphaFrog]

I'm guessing that they refresh in the order they were created.

[Jabba69]

After some trial and error I think I've worked it out - and its quite simple!

Seems as though they are run in the order that the worksheet tabs appear (Left to Right).