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
|