xluser2007
10-28-2009, 01:14 AM
Hi All,
I would like to double click a named range (single-cell) to hyperlink to the desired object stated in the cell contents.
For example, in the sample attached workbook, I have in Sheet1 a named range called "link_ChartScatterPlotSheet3". In "Sheet3" of the same workbook, I have a Chart that is a scatter plot named "ChartScatterPlotSheet3" i.e. same as the named range in "Sheet1", without the first 5 letters "link_" signifying it is the object and not the link to the chart object.
As such, i would like to write the event code in "Sheet1" to double click a named range of the form "link_NameofObject", and then automatically go to that named Object e.g. chart or named range.
In the sample workbook, I can't get this to work, despite trying to use the functions and approach sourced from this (http://www.vbaexpress.com/kb/getarticle.php?kb_id=120) VBAX method here by Zack Baresse for building a TOC for a workbook.
I don;t for example understand how to check whether the named link is for a chart name or a named range to a cell (or cells) i.e. how to use the "IsChart" function in my attached workbook example.
I've had a go at the event code, but it is not working for me.
If anyone could please help that would be appreciated.
regards
I would like to double click a named range (single-cell) to hyperlink to the desired object stated in the cell contents.
For example, in the sample attached workbook, I have in Sheet1 a named range called "link_ChartScatterPlotSheet3". In "Sheet3" of the same workbook, I have a Chart that is a scatter plot named "ChartScatterPlotSheet3" i.e. same as the named range in "Sheet1", without the first 5 letters "link_" signifying it is the object and not the link to the chart object.
As such, i would like to write the event code in "Sheet1" to double click a named range of the form "link_NameofObject", and then automatically go to that named Object e.g. chart or named range.
In the sample workbook, I can't get this to work, despite trying to use the functions and approach sourced from this (http://www.vbaexpress.com/kb/getarticle.php?kb_id=120) VBAX method here by Zack Baresse for building a TOC for a workbook.
I don;t for example understand how to check whether the named link is for a chart name or a named range to a cell (or cells) i.e. how to use the "IsChart" function in my attached workbook example.
I've had a go at the event code, but it is not working for me.
If anyone could please help that would be appreciated.
regards