This code worked for me, too. I'm trying to link to multiple charts from a
table of contents page as well. Can you tell me how to modify the code so
you can open more than one chart tab from the same table of contents?

Thanks

"Lon Sarnoff" wrote:

Many thanks. With slight modification it served as a simple solution to my
problem.

--
Lon Sarnoff


"Andy Pope" wrote:

Hi,

Jon Peltier has an explanation and code work around,
http://peltiertech.com/Excel/Hyperlinks.html

Cheers
Andy

Lon Sarnoff wrote:
My program creates a workbook the structure of which is one worksheet
followed by several hundred charts. The worksheet is to serve as a table of
contents, allowing the user to click on a cell containing the name of the
desired chart in order to display that chart.

The hyperlink function seems to allow this linkage to other worksheets in
the same workbook. I cannot determine whether one can link to charts in the
same workbook. Any advice?

Lon Sarnoff

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info