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

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

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

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

The free Excel add-in "Excel Extras" creates a Table of Contents worksheet with
links to all sheets (worksheets and chart sheets). It lists, but does not link hidden sheets.
It works from a menu item on the Insert menu.
It does other stuff too. Download from (no registration required)...
http://www.realezsites.com/bus/primitivesoftware
--
Jim Cone
San Francisco, USA




"Emilia"
wrote in message
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