From: "me" <[email protected]>
Subject: Re: bookmark a chart?
Date: Friday, August 26, 2005 2:59 PM

Thank you, this was helpful, but doesn't quite solve my problem which I
should have stated earlier. BookA has the hyperlink to a chart in BookB. I
need to copy the chart from BookB into a new worksheet in BookA using VBA.
How would I do that?

Thanks again,
Mike
"Debra Dalgleish" <[email protected]> wrote in message
news:[email protected]...
> You can't hyperlink to the chart sheet, but Jon Peltier has a macro
> workaround in his Charting FAQ article:
>
>
> http://pubs.logicalexpressions.com/P...?ID=209#jon016
>
>
> that you may be able to use.
>
>
>
>
> me wrote:
>> Hi, I can hyperlink to cell A1 in a worksheet using this format:
>> Book1.xls#Sheet1!A1
>> byt I can't figure out how to name a chart or create a bookmark to a
>> chart "worksheet" or chart object so I can hyperlink to either. Is this
>> possible and, if so, how do you do it?
>>
>> Thanks,
>> Mike
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>