View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
andy62 andy62 is offline
external usenet poster
 
Posts: 158
Default 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