Button Refreshing Web Query Error

Im trying to pull in data from a website, a currency exchange rate website.

Though when I open the document I get a Query Refresh window that pops up. I'd like to get rid of this pop up, and replace it with a button on one of my sheets. As well my query thats being imported currently, i'd like to be on a hidden worksheet, so no one can see it easily.

Is this possible? I have a macro that can refresh the web query but it doesn't work with a hidden worksheet and still get the annoying pop up window upon opening the document.

Please Login or Register  to view this content.

Hi,

How about doing an
Application.ScreenUpdating = False
then unhide your sheet if needed
Import the web data
Acitvate or select the sheet you want the user to see
Application.ScreenUpdating = True

Then they will never see the sheet and it will be faster.