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

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,
--
Valeria

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

Valeria wrote:
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,
--
Valeria

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

Valeria wrote:
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,
--
Valeria

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

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

This works wonderfully, thanks a lot!
Kind regards

--
Valeria


"Ken Johnson" wrote:

Valeria wrote:
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,
--
Valeria

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