Linking to a Chart Worksheet

[Tim]

We have a workbook with about 20 charts. We would like to
have the first worksheet in the workbook act as a link to
the charts. Whne we click on the words "Chart1-Title" in
cell A1, we want the Chart1 worksheet to open. Cell A2
would have a link to Chart2, etc.
We were looking at hyperlinks but couldn't figure out how
to get a worksheet in the same workbook to open.

Any ideas?

TIA.

 

[Frank Kabel]

Hi Tim
not possible without using VBA and triggering the selection_change
event of your
worksheet. Have a look at
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=209#jon016

for some code