I want to avoid the update links message when a workbook is opened, but
only for that workbook.

So I created a module with the code below.
However Auto_open is run AFTER the update links dialog appears.
I also tried using Workbook_Open.

How do I stop the dialog from appearing?
I do want to update every time this workbook is opened.

Public Sub Auto_Open()
Application.AskToUpdateLinks = False
End Sub

Public Sub Auto_Close()
Application.AskToUpdateLinks = True
End Sub


--
http://www.standards.com/; See Howard Kaikow's web site.