View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Turbo Turtle Turbo Turtle is offline
external usenet poster
 
Posts: 5
Default Don't Update Links



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



You could do this by changing the update links property. as in

ActiveWorkbook.UpdateLinks = xlUpdateLinksNever