>I have several querytables linked to external data in a workbook. I want
>to be able to refresh these queries using a macro, which I created using the
>macro recorder. Each querytable is on a different worksheet. When I hide
>these worksheets, my macro will not run. What can I do so that the
>worksheets do not have to be visible?

I don't know a particular answer, but a general one is to do

Sub MyMacro
	Application.ScreenUpdating = False
	Worksheets(MyWorksheet).Visible = True
	...business of the macro...
	Worksheets(MyWorksheet).Visible = False
	Application.ScreenUpdating = True
End Sub
John