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
|