Hyperlink question (or two)

[Rick S.]

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

 

[Gary''s Student]

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.

 

[Rick S.]

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.]

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

 

[Rick S.]

I have learned my real problem lies with using VBA to jump around the
workbook as per my sample code. Hyperlinks do work as described by Gary.
--
Regards

VBA.Noob.Confused
XP Pro
Office 2007