Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display cells with data validation | Excel Discussion (Misc queries) | |||
Display first, second, etc Nonblank Cells in a Range | Excel Worksheet Functions | |||
Cells formated as text do not always display properly | Excel Discussion (Misc queries) | |||
Display empty cells | Excel Discussion (Misc queries) | |||
Display empty cells | Excel Discussion (Misc queries) |