View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
E.J. van Wijngaarden[_2_] E.J. van Wijngaarden[_2_] is offline
external usenet poster
 
Posts: 5
Default How to avoid Update Links notification?

Hello experts,

In workbook A I add a worksheet using another workbook B as template, all in
VBA code.
This workbook B contains references to named regions in workbook A, which
works fine once it is loaded.

Now I have the following problem: on adding the new worksheet Excel notifies
that in workbook B there are links to external workbooks and asks if they
must be updated.
I want to get rid of this notification.
I set Application.Displayalerts to False before adding workbook B, but this
has no effect on this notification.

Thanks for your help!

Ed van Wijngaarden