Stopping Display Alerts

[Guest]

I am using Excel 97.

I am trying to disable the displaying of alerts, a typical example of this
is when opening a file being asked whether to update links to other workbooks.

I have used

Application.DisplayAlerts = False 'Turn off important messages

in the Private Sub Workbook_Open() in this 'This Workbook' module but it
doesn't seem to work.

In turn I have also tried by adding to each sub() I write and turning them
back on at the end.

Can anyone assist further?

Thanks

 

[Tom Ogilvy]

the prompt for updating links is shown before any code is run, so you can't
control it with code.

In xl2002 and later there is an option under Edit=>Links to control this
(Startup Prompt button).

for you (xl97), there is no easy solution if you don't want links updated
and you don't want a prompt. On solution is to use a dummy workbook. The
user opens the dummy workbook. It uses the workbook_open event to open the
real workbook with a setting to not update links, then closes itself.