VBA EXCEL: Cancel the update link message?
Solved
teddy42700
-
Nono -
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?
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 réponses
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
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