Originally Posted by
SteveABC
Message box stated = True.
The code is situated in the workbook....Mainstay Master Template.xlsm
It's so difficult to do this in the dark, but check very carefully where you're adding/changing things and whether it's happening where you think it's happening:
All references to ThisWorkbook in the code refer to the workbook where the code resides, which you tell me is Mainstay Master Template.xlsm
So lines such as:
ThisWorkbook.Names.Add Name:="Sitenames", RefersTo:=Rng
where you're adding a name to Mainstay Master Template.xlsm, not to any newly created workbook.
This line:
linkSources = ThisWorkbook.linkSources(1)
will return the links from Mainstay Master Template.xlsm
and this:
ThisWorkbook.ChangeLink link, newLink, xlLinkTypeExcelLinks
will try to update links in Mainstay Master Template.xlsm
Is that what you want to happen?
Perhaps those references to ThisWorkbook need to be changed to b?
Don't forget to correct both instances of xlLinkTypeExcelLinks to 1 or xlExcelLinks.
Reply With Quote