View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Patricia Shannon
 
Posts: n/a
Default bring hyperlinked cell to top of page

You might be able to use the following with the FollowHyperlink event. I'm
fairly new to Excel and visual basic programming, so you might know more
about how to do this than I do.

Sub ActiveTop()

' Move active cell to top of window

' Shortcut key: Ctrl+Shift+A

ActiveWindow.ScrollRow = ActiveCell.Row

End Sub

Good luck,
Patricia Shannon

"Tina" wrote:

Is there a way to bring the hyperlinked cell to the top of the page?
Currently, when I select my hyperlinked text, it takes me to the correct
cell, but the cell is always at the bottom of the page. I need it to be at
the top of the page so the user sees it promptly.

Thank you!!
--
Tina