D
Dan
Hello -
I have some VBA which will REFRESH DATA on a worksheet. However, when
the worksheet is hidden, the macro will not work.
How can I get this code to work on this HIDDEN WORKSHEET?
Sub JCW_Refresh()
Sheets("ODBC Updates").Select
Selection.QueryTable.Refresh BackgroundQuery:=False
Sheets("JCW").Select
End Sub
Thanks for helping out this rookie.
Dan
I have some VBA which will REFRESH DATA on a worksheet. However, when
the worksheet is hidden, the macro will not work.
How can I get this code to work on this HIDDEN WORKSHEET?
Sub JCW_Refresh()
Sheets("ODBC Updates").Select
Selection.QueryTable.Refresh BackgroundQuery:=False
Sheets("JCW").Select
End Sub
Thanks for helping out this rookie.
Dan