Linked sheets not found when opening a workbook
Posted on 2011-03-01
When I open a workbook that has links to sheets in another workbook - fine.
However when the workbook being linked to (source) isn't present I get a dialog prompting to edit the links.
Does this come from a workbook event? Can I trap and provide my own behaviour? If yes then how?
The real situation:
I have a set of sheets that have the year as part of the name. Each year there will be a copy put into archive and the year part of the name changed. eg. SourceA_2010.xls becomes SourceA_2011.xls and so on.
I have the code required to change the links, I have just had the idea it would be nice to run that if required automatically - not having to cancel the default behaviour then run a custom macro.