Thanks, you really understood what I'm after.

But it still doesn't quite work. If I am for example at A1 and want to
scroll so that A40 is the left upper corner it won't work. Or if the A40 is
somewhere on the screen visible. But if I am at A70 and want to go to A 45
then it does the job



"Gary''s Student" wrote:

This is very clumsy and if you get a better response, forget this post. Say
we have:

=HYPERLINK("#Sheet1!B9","go")

in a cell. Clicking it will take you to B9. In the worksheet code area put
this event macro:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Set r = Range("B9")
If Intersect(Target, r) Is Nothing Then Exit Sub
Application.Goto reference:=Target, scroll:=True
End Sub

So the hyperlink takes you to B9. When you get to B9 the macro will scroll
so B9 is in the upper left-hand corner.
--
Gary''s Student - gsnu200754


"DaveFinn" wrote:


I don't think that will work because it needs to work on any computer. I
can't leave it for user to adjust every time.



"Gary''s Student" wrote:

try:

Tools Options Transition Transition navigations keys



--
Gary''s Student - gsnu200754


"DaveFinn" wrote:

I have this worksheet that has lots of graphs etc. I would like to make the
reading experience better for users so that they wouldn't have to scroll down
all the time.

What I havre done so far is that I have freezed couple of rows from the top
and inserted buttons to contain hyperlinks to this sheet. The purpose is to
give user impression of going through different pages. It works well when you
go down from the first to last but not other way round bacause hyperlink has
to refer to only one cell.

So is there any way to refer to range of cells so user would allways see
same section of the worksheet?

Thanks!