View original (French)

VBA EXCEL: Cancel the update link message?

Solved
teddy42700 -  
 Nono -
Hello,

In one of my Excel macros:

-I open another Excel file that contains links to another workbook.

While the macro is running, a message appears asking if I want to update the links, and I can't get rid of this message.

- In the macro, I used Docmd.setwarning=false, I also put the Excel equivalent (so I don't remember it right now ;) )

-In Excel, I unchecked the box "Prompt for automatic update of links"

The message still appears, how can I make this message go away? 
Configuration: Windows XP Internet Explorer 6.0

4 answers

  1.
    michel_m Posted messages 18903 Registration date   Status Contributor Last intervention   3 320
     
    Hello,

    Private Sub Workbook_Open()
    Application.AskToUpdateLinks = False
    End Sub

    Small note:
    Application.DisplayAlerts = False is strongly discouraged as it prevents all security messages
    When, REALLY, we have no other choice, it is necessary to use MANDATORILY the restoration of alerts display as soon as possible
    Application.DisplayAlerts = False

    Not doing this or not advising it is a serious mistake


    --
    Best regards, Michel
    13