RE: Hyperlink question (or two)

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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



"Rick S." wrote:

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
Active***.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 "Active***.Range(sNextS).Select" the hyperlink continues to
follow to sNextS (a named cell "_GPS5100_1") on a chosen work*** (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 work*** that is a Map of all my hyperlinks, on some a double
hyperlink exists. From the Map work*** I need to follow the Parent
hyperlink only.
--
Regards

VBA.Noob.Confused
XP Pro
Office 2007

.

Quantcast