How do I turn off update links and links could not be updated message boxes?

Posted on 2009-04-28
Last Modified: 2013-12-14
I'm running code to update a group of cells on about 500 spreadsheets that have active links to other sheets. I used Application.AskToUpdateLinks = False to turn off the message box asking if I want to update links but I'm getting a message box stating links could not be updated.
What can I do to prevent both message boxes and maintain active links when the update code is finished running?
Question by:dn920

    Author Comment

    Added VB Script as a zone, need any suggestions you all can offer!
    LVL 39

    Accepted Solution

    In C++ I possibly would create a thread which was monitoring the message boxes and which would close them automatically.

    But probably it is easier to set the silent property if available.

    You may look for the following link

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
    Over the years I have built up my own little library of code snippets that I refer to when programming or writing a script.  Many of these have come from the web or adaptations from snippets I find on the Web.  Periodically I add to them when I come…
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
    THe viewer will learn how to use NetBeans IDE 8.0 for Windows to perform CRUD operations on a MySql database.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now