VBA Problem- Overriding a Display Alert/Message Box

[chufaroo]

I've written a macro that opens a Workbook with links to other workbooks (which are closed). I have set Application.DisplayAlerts = False

The problem is that a message box still pops up, and it stops the macro.
"The workbook contains links to other data sources." with a Yes/No prompt.

How can I override this message box (and have it select the default option, "Yes")?

Thanks.

 

[VoG]

Hello and welcome to MrExcel.

Try

Workbooks.Open Filename:="test.xls", UpdateLinks:=True

 

[chufaroo]

Thank you. It works!