View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.scripting.vbscript
Debra Dalgleish[_2_] Debra Dalgleish[_2_] is offline
external usenet poster
 
Posts: 52
Default 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