Closed Thread
Results 1 to 2 of 2

UpdateLinks:=1 (or3), automatically Continue!

  1. #1
    gord.lawson11
    Guest

    Question UpdateLinks:=1 (or3), automatically Continue!

    Simple request:

    On a daily basis, I've got to open several spreadsheets that need to have their links updated, but always get the annoying question:

    ‘this workbook contains …. Cannot be updated’
    Continue Edit Links…

    I'd like it to auto select Continue so I don’t have to sit around and click the button 20 times.

    Things like:
    Application.AskToUpdateLinks = False
    blah blah blah
    Application.AskToUpdateLinks = True
    Do nothing.

    Please respond with either the code or a link to the solution

    Thanks

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: UpdateLinks:=1 (or3), automatically Continue!

    Please continue in your original thread.

    Thanks.
    Entia non sunt multiplicanda sine necessitate

Closed Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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