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