Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.scripting.vbscript
|
|||
|
|||
Hyperlink to a chart sheet...?
Hi,
I would like to create a "Table of Contents" for a rather complicated workbook that conatins several charts. I would the text "Chart 1" to link to the work sheet that contains a stand-alone chart. I can easily create hyperlinks using the hyperlink button, but for some reason my chart sheets don't show up, and typing them in manually causes Excel to crash. Hyperlinks I create to non-chart worksheets work fine. Any ideas? Thank you, Robert Stober |
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.scripting.vbscript
|
|||
|
|||
Hyperlink to a chart sheet...?
You can't hyperlink to a chart sheet. Jon Peltier describes a
workaround, using a macro, in the following thread: http://groups.google.com/groups?&thr...08%40yahoo.com Robert Stober wrote: I would like to create a "Table of Contents" for a rather complicated workbook that conatins several charts. I would the text "Chart 1" to link to the work sheet that contains a stand-alone chart. I can easily create hyperlinks using the hyperlink button, but for some reason my chart sheets don't show up, and typing them in manually causes Excel to crash. Hyperlinks I create to non-chart worksheets work fine. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.scripting.vbscript
|
|||
|
|||
Hyperlink to a chart sheet...?
It and many other questions are also answered in my Charting FAQ, in the
recent issue of TechTrax e-zine: http://pubs.logicalexpressions.com/P...?ID=209#jon016 - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ Debra Dalgleish wrote: You can't hyperlink to a chart sheet. Jon Peltier describes a workaround, using a macro, in the following thread: http://groups.google.com/groups?&thr...08%40yahoo.com Robert Stober wrote: I would like to create a "Table of Contents" for a rather complicated workbook that conatins several charts. I would the text "Chart 1" to link to the work sheet that contains a stand-alone chart. I can easily create hyperlinks using the hyperlink button, but for some reason my chart sheets don't show up, and typing them in manually causes Excel to crash. Hyperlinks I create to non-chart worksheets work fine. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shortcut Hyperlink of 615 Sheet | Excel Discussion (Misc queries) | |||
Sheet becomes a hyperlink when protected | Excel Discussion (Misc queries) | |||
Hyperlink to another sheet, same workbook | Excel Discussion (Misc queries) | |||
Hyperlink from one sheet to the hyperlink on another | Excel Discussion (Misc queries) | |||
HELP required: Insert -> Hyperlink -> ???(no CHART sheet name)!!! | Excel Worksheet Functions |