bookmark a chart?

  • Thread starter Thread starter me
  • Start date Start date
M

me

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
 
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
 
A worksheet has cells, and may have chart objects embedded in it.

A chart sheet has no cells, but usually has a visible chart as its "sheet". It may
also have chart objects embedded in it, but that's an advanced topic.

To move a chart sheet:

Workbooks("BookB").Sheets("Chart1").Move Before:=Workbooks("BookA").Sheets(1)

To copy a chart object:

Workbooks("BookB").Sheets("Sheet1").ChartObjects(1).Copy
Workbooks("BookA").Sheets("Sheet2").Paste

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top