From your description, I presume you copied the VBA code into the 2nd
workbook also (or just made a copy of the 1st workbook?).

Try this: Edit | Links | [change source]
and point to the copy of the 'problem' workbook on the hard drive. In other
words, you're going to point it to the same workbook you have open. See if
that doesn't clear things up.

"Richard Buttrey" wrote:

I have a workbook which is created from another workbook - basically a
copy and paste job into a pre-existing blank workbook, which contains
some VBA code and a couple of picture logos which when clicked run the
macros.

When opening this second workbook when the original is not open in
memory, it tells me that there are links to the first workbook.

I've searched all the cells with the 'Find' "[" which is my usual
method for finding references to another workbook, without finding
anything.
I've also checked the only two logo pictures to ensure that they only
refer to macros in the second workbook and not the original - and they
do.

I'm stuck now and can't see what these links are.

Is there any other way of identifying the link references? (This seems
such an obvious requirement that I'm always suprised that MS haven't
built it in as a standard).

Usual TIA

Rgds


__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________