set hyperlinked cells to always display at the top of the workshee

V

Valeria

Dear experts,
I have hyperlinks linked to different cells belonging to the same worksheet.
How can I set Excel to display the linked cells always at the top, and not
sometimes at the top and sometimes at the bottom of the page? It can get very
confusing otherwise to understand which one the linked cell really is.

Thanks in advance,
Best regards,
 
K

Ken Johnson

Valeria said:
Dear experts,
I have hyperlinks linked to different cells belonging to the same worksheet.
How can I set Excel to display the linked cells always at the top, and not
sometimes at the top and sometimes at the bottom of the page? It can get very
confusing otherwise to understand which one the linked cell really is.

Thanks in advance,
Best regards,
Click to expand...
 
K

Ken Johnson

Valeria said:
Dear experts,
I have hyperlinks linked to different cells belonging to the same worksheet.
How can I set Excel to display the linked cells always at the top, and not
sometimes at the top and sometimes at the bottom of the page? It can get very
confusing otherwise to understand which one the linked cell really is.

Thanks in advance,
Best regards,
Click to expand...

Copy the following code...

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
ActiveWindow.ScrollRow = ActiveCell.Row
End Sub

Right click the sheet tab, select View Code then paste the code into
the sheet's code module.

Your macro security level will need to be Medium and you will need to
click "Enable Macros" on the "Security Warning" dialog, that appears
when the workbook is opened, for the code to run.

Ken Johnson
 
Top