netspeedz
New Member
- Joined
- Aug 11, 2011
- Messages
- 21
I have a sheet in a workbook (Excel 2010) that has a Web Query. The sheet/workbook is updated periodically using some VBA Code (ActiveWorkbook.RefreshAll).
Issue is when the Web Query is being updated, the Query 'steals' focus from whatever I happen to be doing, i.e., composing an email, scrolling through a Google Search, etc.
I've tried various screen updating=false, setting various events to false. Nothing seems to keep the Web Query from taking over focus.
I seem to remember that this was not an issue with Office versions before 2010.
Any assistance would be appreciated.
Issue is when the Web Query is being updated, the Query 'steals' focus from whatever I happen to be doing, i.e., composing an email, scrolling through a Google Search, etc.
I've tried various screen updating=false, setting various events to false. Nothing seems to keep the Web Query from taking over focus.
I seem to remember that this was not an issue with Office versions before 2010.
Any assistance would be appreciated.