I have a spreadsheet with links to another workbook that take a long time to update if the external workbook is closed. To prevent this I have written a macro that fires on the open event of the workbook that automatically opens the links. However the message box asking whether the user wants to update links or not still appears (even though I suppress alerts in the on open macro) so there is still the opportunity for a user to click 'Update' and be waiting ages.

Is there a way to suppress this message does anyone know as it appears to occur before the on open macro fires.

Regards

Ben