Is there a way to assure that an external data range is refreshed before any of the OnOpen events are performed.
I even tried manually refreshing in the on Open, and then calling the macros:
Private Sub Workbook_Open()
workbooks(1).RefreshAll
macro1 'call the macros
End Sub
But even this performs the macro operations, THEN refreshes, thereby making the macro useless.
Thanks as always,
Mark
I even tried manually refreshing in the on Open, and then calling the macros:
Private Sub Workbook_Open()
workbooks(1).RefreshAll
macro1 'call the macros
End Sub
But even this performs the macro operations, THEN refreshes, thereby making the macro useless.
Thanks as always,
Mark