I have hyperlinks that are linked to hyperlinks, is it possible to click on
one hyperlink and have it follow to the next hyperlink without following the
second hyperlink?

I have a worksheet that is a Map of all my hyperlinks, on some a double
hyperlink exists. From the Map worksheet I need to follow the Parent
hyperlink only.
--
Regards

VBA.Noob.Confused
XP Pro
Office 2007

It should function the way you have described.

If you have in A1 a hyperlink to cell B9 and in cell B9 a hyperlink to
cnn.com, then clicking on A1 will take to to B9, but not to CNN.

An additional click would be required.
--
Gary''s Student - gsnu200765


"Rick S." wrote:

I have hyperlinks that are linked to hyperlinks, is it possible to click on
one hyperlink and have it follow to the next hyperlink without following the
second hyperlink?

I have a worksheet that is a Map of all my hyperlinks, on some a double
hyperlink exists. From the Map worksheet I need to follow the Parent
hyperlink only.
--
Regards

VBA.Noob.Confused
XP Pro
Office 2007

Here is a bit of code I use.
'======
'SS_34 (source)
'_GPS5100_1 (target)
On Error Resume Next
sS = Target.Name.Name 'get parent name of cell, target = "_GPS5100_1"
On Error GoTo 0
sNextS = "_GPS5100_1" 'make progmatic
If sS = "SS_34" Then
Call x
Worksheets("Tempe").Select
ActiveSheet.Range(sNextS).Select 'go to named cell in sNextS
sS = "" 'set sS to nothing
Else
sS = "" 'set sS to nothing
End If
'======

In this code "ActiveSheet.Range(sNextS).Select" the hyperlink continues to
follow to sNextS (a named cell "_GPS5100_1") on a chosen worksheet (Tempe).
It functions the same whether I use .Select or .Activate?
--
Regards

VBA.Noob.Confused
XP Pro
Office 2007



"Gary''s Student" wrote:

It should function the way you have described.

If you have in A1 a hyperlink to cell B9 and in cell B9 a hyperlink to
cnn.com, then clicking on A1 will take to to B9, but not to CNN.

An additional click would be required.
--
Gary''s Student - gsnu200765


"Rick S." wrote:

I have hyperlinks that are linked to hyperlinks, is it possible to click on
one hyperlink and have it follow to the next hyperlink without following the
second hyperlink?

I have a worksheet that is a Map of all my hyperlinks, on some a double
hyperlink exists. From the Map worksheet I need to follow the Parent
hyperlink only.
--
Regards

VBA.Noob.Confused
XP Pro
Office 2007

I forgot to mention I am using Named Cells (IE: "SS_34") and in the Hyperlink
dialog box I am using "Place in This Document" instead of a direct cell
address (IE: "A1").
--
Regards

VBA.Noob.Confused
XP Pro
Office 2007



"Rick S." wrote:

I have hyperlinks that are linked to hyperlinks, is it possible to click on
one hyperlink and have it follow to the next hyperlink without following the
second hyperlink?

I have a worksheet that is a Map of all my hyperlinks, on some a double
hyperlink exists. From the Map worksheet I need to follow the Parent
hyperlink only.
--
Regards

VBA.Noob.Confused
XP Pro
Office 2007