AskToUpdateLinks not working

[Jason Bishop]

I want my workbook to update links upon opening, but not prompt me as
I open the workbook. I have used the following code.

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

And I still get the prompt. Any ideas why?

Thanks in advance.

 

[Tom Ogilvy]

Sure, set it manually under Tools=>Options, Edit Tab.

The prompt is issued before your code is run, so trying to manage it in the
workbook being opened is not an option.