MS Query Button On Spreadsheet?

  • Thread starter Thread starter mx-3 for me
  • Start date Start date
M

mx-3 for me

Hello All,
Since you were so helpful my first time around on this message board-
thought I would return to ask another question I have.

Is it possible to place the "Refresh Data" button on a spreadshee
while using MS Query? This is so that the user using the spreadshee
wont have to search around for the refresh button and it could be righ
there in front of them.
Thanks in advanced, im sure this is an easy one for you gurus ou
there! :)

Michell
 
Hi
you may assign the following statement to a button in your sheet:
activeworkbook.refreshall
 
Back
Top