Disable Update Warning

[GreenyMcDuff]

Hi all,

Currently when I need to disable application warnings I use the following:

    Application.DisplayAlerts = False

However,

I my macro needs's to open a workbook with lots of referenced data in it. When I open it I am prompted to either update or not update values in the sheet.

Is there anyway I can default this to update or not update so that the user does not see the message box?

Many thanks

Chris

 

[VoG]

Try like this

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

 

[GreenyMcDuff]

Awesome, Thanks Peter