Hi, I'm using excel 2007.
At the top of a spreadsheet I have hyperlinks to various cells in column A. The hyperlinks are in the first 10 rows that I froze the panes for to always show up top. When I click on a hyperlink while scrolled to the top of the page it jumps to a cell down the spreadsheet displaying everything above it that fits on a monitor. But while now scrolled down the spreadsheet if I then click another hyperlink from the top rows visible in the frozen pane it jumps to a cell but now displaying everything below it that fits on a monitor.
Is there anyway, VB or otherwise, to ensure the hyperlinks clicked always jump to either the top or the bottom?
Thank you,
John
At the top of a spreadsheet I have hyperlinks to various cells in column A. The hyperlinks are in the first 10 rows that I froze the panes for to always show up top. When I click on a hyperlink while scrolled to the top of the page it jumps to a cell down the spreadsheet displaying everything above it that fits on a monitor. But while now scrolled down the spreadsheet if I then click another hyperlink from the top rows visible in the frozen pane it jumps to a cell but now displaying everything below it that fits on a monitor.
Is there anyway, VB or otherwise, to ensure the hyperlinks clicked always jump to either the top or the bottom?
Thank you,
John