LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Avoid Update Links dialog in Excel 2003 Ian Chappel Links and Linking in Excel 3 June 29th 07 01:11 PM
Avoid "update Links" promt in e-mailed pivot tables? Michelle B Excel Discussion (Misc queries) 2 October 23rd 06 02:54 PM
How to avoid "update links" startup prompt? [email protected] Excel Discussion (Misc queries) 8 July 23rd 06 04:20 AM
Is it possible to receive notification of a file update? spavlica09 Excel Discussion (Misc queries) 1 May 8th 06 04:50 PM
Can I avoid annoying Update Links message phillyjoe Excel Discussion (Misc queries) 2 October 29th 05 03:00 PM


All times are GMT +1. The time now is 03:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"