View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Richard Buttrey Richard Buttrey is offline
external usenet poster
 
Posts: 296
Default Finding a link source.

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
__________________________