Hyperlinks

Hi,

I am trying to integrate some hyperlinks into my workbook, essentially
all they are doing is jumping from one area on a sheet to another area
on the same sheet.

However, when I have a link at the top of the sheet and have it linking
to a cell many rows below, when it is clicked the cell it's jumping to
is made active but at the bottom of the visible area on my screen. What
I mean is that the new active cell is not put at the top of the viewing
area.

Is there any way of getting around this? Seems a bit stupid to me!

Cheers,

Mark.


--
mevetts


------------------------------------------------------------------------
mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130
View this thread: http://www.excelforum.com/showthread...hreadid=494644

How did you insert the hyperlink?

Did you use Insert|Hyperlink?

If yes, then maybe you could rightclick on the worksheet tab that holds the
hyperlink. Select view code.

Paste this in:

Option Explicit
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
On Error Resume Next
Application.Goto Target.SubAddress, scroll:=True
On Error GoTo 0
End Sub


mevetts wrote:

Hi,

I am trying to integrate some hyperlinks into my workbook, essentially
all they are doing is jumping from one area on a sheet to another area
on the same sheet.

However, when I have a link at the top of the sheet and have it linking
to a cell many rows below, when it is clicked the cell it's jumping to
is made active but at the bottom of the visible area on my screen. What
I mean is that the new active cell is not put at the top of the viewing
area.

Is there any way of getting around this? Seems a bit stupid to me!

Cheers,

Mark.

--
mevetts

------------------------------------------------------------------------
mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130
View this thread: http://www.excelforum.com/showthread...hreadid=494644

--

Dave Peterson

Hi Dave,

I have tried pasting the code in, but when I still click the link it
jumps to the linked cell, but it is still appearing at the bottom of
the screen.

In web design, you use anchors and when a link is clicked that realtes
to an anchor the anchor is displayed at the top of the screen, thus
showing what's below it.

Any other ideas?

Thanks.


--
mevetts


------------------------------------------------------------------------
mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130
View this thread: http://www.excelforum.com/showthread...hreadid=494644

Did you paste the code behind the correct worksheet?
Did you enable macros when you opened that workbook?
(Try saving, closing and reopening -- answer yes to enable macros)

And you did create the link via Insert|Hyperlink, right?



mevetts wrote:

Hi Dave,

I have tried pasting the code in, but when I still click the link it
jumps to the linked cell, but it is still appearing at the bottom of
the screen.

In web design, you use anchors and when a link is clicked that realtes
to an anchor the anchor is displayed at the top of the screen, thus
showing what's below it.

Any other ideas?

Thanks.

--
mevetts

------------------------------------------------------------------------
mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130
View this thread: http://www.excelforum.com/showthread...hreadid=494644

--

Dave Peterson

Yep, I did all those things, but no joy.


--
mevetts


------------------------------------------------------------------------
mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130
View this thread: http://www.excelforum.com/showthread...hreadid=494644

I don't have another suggestion. It worked fine for me.

mevetts wrote:

Yep, I did all those things, but no joy.

--
mevetts

------------------------------------------------------------------------
mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130
View this thread: http://www.excelforum.com/showthread...hreadid=494644

--

Dave Peterson

Would it be possible for you to post an example so I could perhaps try
and use a working model?

Or you could email me over a workbook?

Sorry, if that's a bit cheeky, but just really want to get it working.

Mark.


--
mevetts


------------------------------------------------------------------------
mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130
View this thread: http://www.excelforum.com/showthread...hreadid=494644

The code I posted in the previous response was all I used.

If you did what you said you did, then I don't it'll help.

mevetts wrote:

Would it be possible for you to post an example so I could perhaps try
and use a working model?

Or you could email me over a workbook?

Sorry, if that's a bit cheeky, but just really want to get it working.

Mark.

--
mevetts

------------------------------------------------------------------------
mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130
View this thread: http://www.excelforum.com/showthread...hreadid=494644

--

Dave Peterson

Have I put the code where it should be?


+-------------------------------------------------------------------+
|Filename: screen.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=4131 |
+-------------------------------------------------------------------+

--
mevetts


------------------------------------------------------------------------
mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130
View this thread: http://www.excelforum.com/showthread...hreadid=494644

I don't see your post through excelforum, so I can't see the attachment.

did you rightclick on the worksheet tab that contained the hyperlink? Did you
select View code and paste into that code window?



mevetts wrote:

Have I put the code where it should be?

+-------------------------------------------------------------------+
|Filename: screen.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=4131 |
+-------------------------------------------------------------------+

--
mevetts

------------------------------------------------------------------------
mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130
View this thread: http://www.excelforum.com/showthread...hreadid=494644

--

Dave Peterson