Hope some one can share some insight.
I have an expanding number of Workbooks that include hyperlinks to common reference Workbooks, all of which have autorun macros in the WorkbookOpen Event. However this event is not trigured by a hyperlink, as a work around i have used the WindowActivate event to run initialisation code normally called by the auto open routines.
This is not very efficient as the code is called every time the user selects a given Window. Does anyone have a better solution???