AskToUpdateLinks not working

J

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.
 
T

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.
 
Top