Hyperlinks in Excel

[Maria]

Help anyone?

I'm trying to create a hyperlink from a cell to a chart
which located on a worksheet in another Excel workbook.
When I try to create the hyperlink I select the file
containing the chart, but when I click on "bookmark", all
of the worksheets aren't listed - it appears not to
recognise any worksheets that contain charts. The only
way I can see round this is to place the chart as
an "object" in a worksheet (but then I have to mess around
re-sizing the chart and it doesn't look that good). Any
ideas?

Thanks very much,

Maria

 

[Debra Dalgleish]

Jon Peltier has a macro workaround in his FAQ article:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=209#jon016

that you may be able to adapt to your situation.