Suppress Alerts - Update Links

[skuzapo]

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

 

[Ron de Bruin]

Hi skuzapo

See

Tools>Options..Edit

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

 

[skuzapo]

Thanks Ron,

But what happens when the spreadsheet is opened on another user's pc
Won't the change you suggested under the tools menu be pc specifi
rather than specific to this spreadsheet?

Thanks agai

 

[Tom Ogilvy]

You are correct. This is an application level setting.

What version of excel will be used to open the file?

 

[skuzapo]

Hi Tom,

We have a selection of excel versions running through out our compan
(so much for standardisation) but predominantly excel 97 SR-2.

Thank yo