Sub CtrlHome()
ActiveWindow.VisibleRange.Resize(1, 1).Select
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Johanna Gronlund" wrote in
message ...
Hello,

I have a worksheet that has hyperlinks to other parts of the same sheet. I
have 6 frozen panes on top on the sheet. I would like to have the cursor
appear on the top of the screen (just below the frozen panes) rather than
bottom of the screen. I have checked previous posts and tried this code on
the worksheet:

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

For some reason, nothing happens. It's the same if there was no code.
Could
I be doing something wrong? Is there something I would need to make
specific
for my worksheet, eg. name of the Worksheet? My workshhet is called
Inputs.

Many thanks in advance for your help.

--
Johanna