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


--
blatham
------------------------------------------------------------------------
blatham's Profile: http://www.excelforum.com/member.php...o&userid=19441
View this thread: http://www.excelforum.com/showthread...hreadid=534488