+ Reply to Thread
Results 1 to 2 of 2

How to pop up a warning message before any Excel automatic update link reminder message

  1. #1
    Forum Contributor
    Join Date
    01-15-2013
    Location
    London
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    422

    How to pop up a warning message before any Excel automatic update link reminder message

    Hi, I want to show a pop up message as:

    Sub auto_open()

    MsgBox "Please make sure you DO NOT UPDATE the link to avoid long time of waiting"

    End Sub

    But I found this message always display later than the Excel's system message about link update: "This workbook contains links to other data sources. If you update the links, Excel will..."

    This means that my messagebox is useless as I really want the message displays as a priority to any message.

    Can you help please?

  2. #2
    Forum Contributor
    Join Date
    01-15-2013
    Location
    London
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    422

    Re: How to pop up a warning message before any Excel automatic update link reminder messag

    Just found a way to do it in Excel:

    Click Edit Links -> Startup Prompt -> Don't display the alert and don't update automatic links

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1