Links
 

I have a worksheet which has links to another workbook.

When I copy these links with code, something happens which I do not
understand. I am using Copy - Pastespecial to copy the cells containing the
links.

When the links are to files in the same directory as the workbook, the links
are copied but them take an age to refresh, before the next column of links
are copied and so on.

When the links are to workbooks in a different directory, the links are
copied, but then a model dialog box appears asking where the linked file is.
If I click Cancel the code proceeds and when the workbooks recalculates all
the links are correct.

Can anyone explain this and tell me how I can avoid my code being stopped
and a user input required?

PWS