How to refresh one tab at a time with a single button

[jpiazza]

So basically, I have a workbook with 5 or so tabs. Some tabs have XML calls, others have pivot tables. I am trying to figure out how to refresh each tab in a certain order.

So the ThisWorkbook.RefreshAll doesn't seem to work.

I am looking for something like

Workbook."Closed Issues".Refresh
Workbook."Open Issues".Refresh
Workbook."Summary".Refresh

Thanks

 

[Macropheliac]

Have you tried recording a macro while you do this manually?

 

[jpiazza]

I am not familar with recording macros and then calling them from a button ?

 

[Norie]

Just goto Tools>Macro...Record New Macro... and then carry out the refreshing manually.

That should generate code that you can call from a button.

Note the code generated will probably need cleaned up - the macro recorder records all your actions.

 

[Macropheliac]

If you need help with the clean up, post it and I'm sure we can help you with it.

Mac