Keeping Linked Info When Tabs are Renamed
Karl Burrows wrote:
Is there a way to programmatically create links based on the worksheet
number rather than the tab name to keep the links regardless of what I name
them?
Not that I can think of, unless....
If you ensure that the primary workbook is open when any of the derived
workbooks are in use then you could use the INDIRECT function together with a
VBA function which returns the Nth sheet name from the primary workbook.
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup
|