Linking graphs with macro

[Hasan Afzal]

Hi,

I was doin some work with spread-sheets, and i made a
chart. How do i link a button on a sheet to go to the
graph and vice versa. something about a macro?

could u plz help me

Many thanks

Hasan Afzal

 

[Jon Peltier]

Hi Hasan -

Are these chart sheets? Tell your users that the sheet tabs are buttons designed for
navigation. (Well, they are.)

If you really want to do it with hyperlinks or code, then read on.

To go from the chart to the sheet, draw a rectangle, right click on it, and choose
Hyperlink. Choose Place in this Document, select your sheet, and type in the cell
reference.

Go to this article for how to link to a chart:

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

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