Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Avoid Update Links dialog in Excel 2003 | Links and Linking in Excel | |||
Avoid "update Links" promt in e-mailed pivot tables? | Excel Discussion (Misc queries) | |||
How to avoid "update links" startup prompt? | Excel Discussion (Misc queries) | |||
Is it possible to receive notification of a file update? | Excel Discussion (Misc queries) | |||
Can I avoid annoying Update Links message | Excel Discussion (Misc queries) |