S.H.A.D.O.
Well-known Member
- Joined
- Sep 6, 2005
- Messages
- 1,915
Good morning,
I have a sheet called "Summary" and a sheet called "Calculation".
I have set up Hyperlinks in the sheet called "Summary" which relate to different cells in the sheet called "Calculation". This works very well.
What I would like to be able to do is when ANY of the Hyperlinks are pressed that the sheet "Calculation" goes two rows above the reference set in the Hyperlink and the two rows above the reference moves the sheet upto the top of the page. Something like...
...if VBA was used.
Thanks in advance.
I have a sheet called "Summary" and a sheet called "Calculation".
I have set up Hyperlinks in the sheet called "Summary" which relate to different cells in the sheet called "Calculation". This works very well.
What I would like to be able to do is when ANY of the Hyperlinks are pressed that the sheet "Calculation" goes two rows above the reference set in the Hyperlink and the two rows above the reference moves the sheet upto the top of the page. Something like...
Code:
ActiveWindow.ScrollRow = 1
...if VBA was used.
Thanks in advance.