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
|