HyperLinks View

[busboy10]

Hi All,

I want to have hyperlinks to parts within the same worksheet. The
problem is that the reference cell is being displayed wherever it can
first be seen on the screen. What I would like to have happen is that
the cell I am linking to gets displayed in the upper left so it will
be the main focus. I have tried the following code and it doesn't
seem to be catching.

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
Application.Goto reference:=ActiveCell, scroll:=True
End Sub


Any thoughts?
Thanks!

 

[Gord Dibben]

You have disabled events somehow?

Your code works for me in 2003 and 2007 versions.

Drop this into the Immediate Window then try again.

Application.EnableEvents = True


Gord Dibben MS Excel MVP

 

[WallyWallWhackr]

Hi All,

I want to have hyperlinks to parts within the same worksheet. The
problem is that the reference cell is being displayed wherever it can
first be seen on the screen. What I would like to have happen is that
the cell I am linking to gets displayed in the upper left so it will
be the main focus. I have tried the following code and it doesn't
seem to be catching.

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
Application.Goto reference:=ActiveCell, scroll:=True
End Sub


Any thoughts?
Thanks!

My hyperlinks point to cells directly, and go there directly. There
are a number of rows where you will not see an "upper left corner"
resolve for *screen* placement. The cell focus works fine though.

There are hyperlinks that transport the user to specific worksheets, and
there are hyperlinks in each sheet that move between a pivot table and
the main worksheet body.

http://tinyurl.com/27zvzv4