Oh and also i forgot to mention I run the macros to refresh from the moment the the workbook is opened.
So, in ThisWorkbook I have the following code:
Private Sub Workbook_Open()
Call WorkSheet2.TabShow
End Sub
and in the Worksheet2 i have the following code:
Sub TabShow()
Dim i As...
Thank you Luke M.
I havea problem though. I was bring in data from an external source (a CSV file) and I had set it up so the file would refresh the data upon opening and then refresh every 30mins.
Running the above mentioned macros is not allowing me to refresh the data on my worksheets...
Hey. This post has been extremely helpful to me. Thank you!
But I have a small problem. I am running excel 2010 and I was using the code posted above to auto-tab worksheets. I do have a couple of worksheets and according to the code above ...
If Worksheets(i).Visible = "False" Then GoTo 10...