Reconnecting a Link
 

I receive an Excel generated dialog in the following circumstance:

- 2 workbooks, sourcewb and destinationwb
- destinationwb has links from named ranges on multiple sheets in sourcewb
- the names of the sourcewb ranges are identical local names on different
sheets

Now:
- with destinationwb closed, on of the sourcewb sheets is deleted and
sourcewb is saved.
- when destinationwb is opened, and links are re-established, Excel
generated a dialogue asking the user to specify the sheet that the broken
link refers to. Selecting cancel causes an error on the link.

All this is fine, except I wish to prevent the Excel dialog from being
displayed to the user since this process is under VBA control.

Any thoughts would be welcome.
Alex J