The update links question is asked before any code is executed so using
code/the workbook_open event to change the property is not a solution.

--
Regards,
Tom Ogilvy


"Turbo Turtle" wrote in message
...


"EMoe" wrote:
I am building a report. In that report I have copied some graphs from
one workbook into another.

How do I turn off the links updating message for that particular
workbook whenever it is opened, besides going into that workbook and
inserting a code. I would rather have it encoded from the original
workbbok that creates the new workbook.

I know that this happens because the information for the graphs are in
another workbook. So I need to copy those graphs to another workbook,
turning off the links.

You could do this

Private Sub Workbook_Open()
ActiveWorkbook.UpdateLinks = xlUpdateLinksNever
End Sub