Hi John
Is your web query linked to query tables in your workbook?

Cordially
Pascal

"John V" a écrit dans le message de news:
...
I have several web queries that auto-refresh every X minutes or so. I would
like to craft a macro that temporarily suspends refreshing so, for
example, I
can edit the spreadsheet without interruption. And, of course, I'd need a
way
to un-suspend. I didn't know if this was possible short of manually
changing
the refresh parameter in each query.

Any ideas appreciated.