+ Reply to Thread
Results 1 to 4 of 4

Disable links on opening

  1. #1
    Forum Contributor
    Join Date
    12-02-2008
    Location
    Brisbane
    MS-Off Ver
    2016
    Posts
    807

    Disable links on opening

    Hi

    I've inherited a spreadsheet which, on opening, attempts to contact a server that no longer exists, and run one or more external (?) links which aren't there. I get three message boxes one after the other in a loop. I can't break this loop. I can't access anything on the menu bar - I assume the attempts to link can't be interrupted from the keyboard or mouse.

    If I hit ctrl+shift+esc I get a message box saying I can't delete anything from task activities because there is an open message box.

    How do I permanently stop this?
    Last edited by BRISBANEBOB; 09-17-2021 at 09:05 PM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,929

    Re: Disable links on opening

    You’ve marked this as solved - is it?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,463

    Re: Disable links on opening

    If it isn't, please see the yellow banner at the top of the page.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  4. #4
    Forum Contributor
    Join Date
    12-02-2008
    Location
    Brisbane
    MS-Off Ver
    2016
    Posts
    807

    Re: Disable links on opening

    I solved the problem by rewriting the spreadsheet...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Disable form from opening @ workbook opening
    By rob_h in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-20-2017, 06:00 PM
  2. [SOLVED] disable update links while opening a file
    By sudharshan86 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-16-2014, 12:09 PM
  3. Disable "Update Links?" Box Upon Opening File
    By solecraft311 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-16-2012, 01:50 PM
  4. Disable update links.
    By JapanDave in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-15-2012, 10:18 AM
  5. How to disable worksheet links???
    By JohnBH in forum Excel General
    Replies: 4
    Last Post: 06-18-2007, 04:03 PM
  6. Replies: 3
    Last Post: 05-10-2006, 07:35 AM
  7. Not able to disable external links please help
    By Amit Sharma in forum Excel General
    Replies: 1
    Last Post: 04-20-2006, 09:45 AM

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