I have created a web query on a sheet
Excel 2003 Windows XP)
With ActiveSheet.QueryTables.Add(Connection:=URLToday, Destination:=Range("A7"))
.Name = "DisplayMeetings.aspx?State=1&DisplayType=TodaysRacing"
.FieldNames = True
.RowNumbers = False
etc.....
This works perfectly when called as part of macro routines but if I am silly enough to click on that sheet, the sheet becomes non responsive for several minutes and I may need to use the task manager to shut Excel down.
I suspect it's sticking its nose up every link on the page (there are many)
Is there a parameter on the list that I can alter to make it cease and just deal with what's visible?
Is it this one (which is set to False?)
.WebDisableRedirections = False
Bookmarks