Results 1 to 6 of 6
  1. #1
    Star Lounger
    Join Date
    Jun 2005
    Location
    Singapore
    Posts
    89
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Rid of Notification (Office XP)

    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!


    Cheers, Kun

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Rid of Notification (Office XP)

    Kun

    Does this help:

    To cancel the Update Links message while opening a linked workbook:

    1. From the Tools menu, select Options, and then select the Edit tab.
    2. Deselect the Ask to update automatic links checkbox, and then click OK
    Jerry

  3. #3
    Star Lounger
    Join Date
    Jun 2005
    Location
    Singapore
    Posts
    89
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Rid of Notification (Office XP)

    Jerry

    Thank you for your prompt response, using that option now show the notification that the links van't be update but ask me
    to edit. I want to avoid the notification being show up when opening the workbook.

    thanks, kun

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Rid of Notification (Office XP)

    It would help to see the code to know exactly what you are doing. As a guess, add the following before inserting the new worksheet:

    <code>
    Application.AskToUpdateLinks = False
    </code>

    and this after:

    <code>
    Application.AskToUpdateLinks = True
    </code>
    Legare Coleman

  5. #5
    Star Lounger
    Join Date
    Jun 2005
    Location
    Singapore
    Posts
    89
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Rid of Notification (Office XP)

    Leagre

    Thank you for your response. It didn't work. Some cells in the workbook contain links to another workbook or another worksheet in the same workbook. Is it possible to avoid the updating notification alert at all? This is because after I send this file out, the receipents will get this notification alert too which I think is useless.

    thanks, kun

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Rid of Notification (Office XP)

    Does Re: Automatic Open Of Linked Files (2000) answer your question?

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •