Hi skuzapo

See

ToolsOptions..Edit

Uncheck "Ask to update.......


--
Regards Ron de Bruin
http://www.rondebruin.nl


"skuzapo" wrote in message
...

Hi all,

My spreadsheet has links to other workbooks so the user is asked
whether or not to update automatic links when the spreadsheet is
opened.

Is it possible to suppress this message and update the links every
time?

I tried the following in the "ThisWorkbook" sheet:

Application.DisplayAlerts = False

But the message still comes up.

Thanks in advance for any suggestions


--
skuzapo
------------------------------------------------------------------------
skuzapo's Profile: http://www.excelforum.com/member.php...o&userid=27430
View this thread: http://www.excelforum.com/showthread...hreadid=471190