HyperLinks View

  • Thread starter Thread starter busboy10
  • Start date Start date
B

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!
 
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
 
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!
Click to expand...

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
 
Back
Top