Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linking graphs with macro
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linking graphs with macro
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/P...?ID=209#jon016 - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Hasan Afzal wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking graphs to other spreadsheets | Excel Discussion (Misc queries) | |||
Linking to external tables/Graphs | Excel Discussion (Misc queries) | |||
Excel 7 to powerpoint 7 - embedding graphs but not linking | Excel Discussion (Misc queries) | |||
Linking textbox and graphs | Excel Discussion (Misc queries) | |||
Linking To Excel Graphs | Excel Programming |