Update Links Stopping Workbook_Open Routine
 

John,

In xl2003

I dont know if you want to update the links or not but this code will
stop the links being updated when the workbook is opened. I have not
tested the code but if the dialog box is displayed use
Application.DisplayAlerts = False.

The other constants used can be found in VBA help

ActiveWorkbook.UpdateLinks = xlUpdateLinksNever

Regards

Michael beckinsale