Disable Background refresh for entire sheet

[mblake5]

I have multiple SQL queries in a VBA macro. Then run one after another in a loop based on pulling in different values from an array. I need to make the macro pause before proceeding so that the data can be refreshed. I've seen multiple posts on disabling the background refresh outside of VBA, but I need to do it within a loop in VBA. How do I do this?

 

[Fazza]

Maybe best to post some of the code to help understand what you're doing?

It sounds like you have query tables? In which case the VBA might be
.refresh backgroundquery:=false

That should be OK, but if not, try also adding a "doevents" line

HTH