I have a workbook with 2 MS Queries. They both require the same parameters
so I set up a macro to run them in a certain order. The first query asks for
the parameter, the second query then takes the paramenter from the first
queries output. Then the macro refreshes a series of pivot tables. My
problem is I get the Run Macro Dialog box, say yes, my macro runs then I get
the Auto Refresh Query Dialog box. My users are used to the macro box, we
want them to disable macros from an outside source, but they will no doubt
say yes to the Auto Refresh box and have to enter the parameters in again,
and update teh quesries again. Is there a way to turn off the Auto Refresh
Dialog box completely. I have already unchecked all the refresh boxes in the
queries properies. Thanks