the concept of autorefresh and with a commandbutton are not really
consistent unless you mean you want to set it to autorefresh by clickking a
commandbutton. Assuming you just want to have them refresh when the button
is clicked.

Private CommandButton1_Click()
Worksheets("Sheet3").QueryTables(1).Refresh Backgroundquery:=False
Worksheets("Sheet5").QueryTables(1).Refresh Backgroundquery:=False
End sub

--
Regards,
Tom Ogilvy


"Dmorri254" wrote in message
...
Hello,

I have at least two queries in my workbook that I would like to auto
refresh
via a Command Button. Can anyone provide a method to do this?

Thank you

David Morrison