Stopping Display Alerts
 

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


--
Mark

Stopping Display Alerts
 

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.

--
Regards,
Tom Ogilvy

"Mark" wrote in message
...
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


--
Mark