Disable links to other workbooks

[JohnUK]

I have various workbooks that the master picks up to transfer data, but some
of the workbooks have links to other files, hence I keep getting a message to
either update or not. This means I have to keep pressing the Don’t Update for
the program to move on. I have used Application.DisplayAlerts = False
command, but to no avail. Is there something else I can use.
Many thanks again, John

 

[JP]

If you go to Edit > Links, there's an option to turn off automatic
updating of links, or something like that.

--JP

 

[JohnUK]

Hi JP. Thanks for that, but that would mean me disabling each workbook and
saving changes, which I don’t want. What I need is something I can insert
into the code that will stop the alerts from appearing as each workbook
opens. Appreciate your feedback. John

 

[JohnUK]

Hi again. I found a way of disabling the pop ups by using
Application.AskToUpdateLinks = False, but the drawback is that I lose
anything that is kept in memory that I need to copy and paste from one
workbook to another. (Ha - Two steps forward, one back) has anyone got an
answer to this problem?
John