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.

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.



--
Regards,
Tom Ogilvy

"Jason Bishop" wrote in message
m...
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.