ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Make hyperlink arrive at top of page (https://www.excelbanter.com/excel-worksheet-functions/140378-make-hyperlink-arrive-top-page.html)

andy62

Make hyperlink arrive at top of page
 
I have a tab that serves as an index to another tab called Library. The
Index tab is like a table of contents, with each item hyperlinked into a
destination on the Library tab. The problem is that when you jump to a row
in Library that is "below screen", the view only scrolls up far enough to
include the destination row, thus it is at the very bottom of the screen. I
want the tab to open each time with the bookmarked cell at the top of the
active screen. Any ideas? I think there is a VBA solution that might
address this, but would need some help . . . or a simpler solution. TIA


All times are GMT +1. The time now is 09:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com