Button to activate a hyperlink (but going always to the top of the screen)

[richard11153]

I have "Hyper-link" buttons assigned (on each page) so I can jump
to another page in a long worksheet. Is there a way to make the "assigned cell"
go always to the "top / left" of the page?

As it is now, when your at the bottom area of the page "and hyperlink up",
it is proper (the "linked" cell is always at the top). But when hyperlinking down,
on the page, the cell is always at the bottom of the screen.
Page heights may vary, so Im just trying to find a way for it to always
"hyper-link" to a cell, (with the cell placement at the top of the page)

I hope this make sense.
Any help is greatly appreciated. Thanks!!

[GC Excel]

Hi Richard,
Here's a trick that I use, add this code to the sheets containing hyperlinks.

Please Login or Register  to view this content.

[richard11153]

Thanks, I added it. but the links still do not always go to the top.
Not sure if I added the VBA properly. I have a lot of VBA on this worksheet
and I do not really understand most of it.
I was hoping for a "non-VBA" way to do this.

[Winon]

Hello richard11153,

Perhaps something as per the attached sample workbook?

[GC Excel]

Hi again,

I don't know any non-VBA trick unless by referencing other cells below your actual target to "force" a window scroll.

Note : The code as to go in a sheet Module. For example, if your hyperlink is in Sheet2, place the code in Sheet2 Module.

[richard11153]

Yes, I see how that works. But mine are all in one, very long sheet,
im juts moving up & down a lot of pages (not within separate "tabs"
or worksheets).
Maybe there is no way to do this.

[richard11153]

Yes, I see how that works. But mine are all in one, very long sheet,
im juts moving up & down a lot of pages (not within separate "tabs"
or worksheets).
Maybe there is no way to do this.

[GC Excel]

I just tried my solution on a very long worksheet with linked cells and everything is fine...

[Winon]

Hi richard11153,

Perhaps if you could uplaod a sample workbook, we would be able to assist you better.

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Thank you.