Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
I have approx 200 simple templates all of which are the same in layout, i'm using a simple macro which uses a loop to open each file pick up bits of info and lay it out on a list. The problem i have is some of these files have external links and when the macro opens them i get the message "Do i want to update links" which also pauses the macro until i click update or dont update. Is it possible to put a code within the macro which automatically selects dont update if a file has links. I've displayalerts = false but this doesnt seem to work thanks in advance Hervinder |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Disable update links prompt | Excel Programming | |||
Update links without opening other files | Excel Programming | |||
Disable Update Automatic Links | Excel Discussion (Misc queries) | |||
Disable find files error message for missing links on opening WB | Excel Discussion (Misc queries) | |||
Disable update links dialog box | Excel Programming |