Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello,
I have a worksheet that has hyperlinks to other parts of the same sheet. I have 6 frozen panes on top on the sheet. I would like to have the cursor appear on the top of the screen (just below the frozen panes) rather than bottom of the screen. I have checked previous posts and tried this code on the worksheet: Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) Application.Goto ActiveCell, Scroll:=True End Sub For some reason, nothing happens. It's the same if there was no code. Could I be doing something wrong? Is there something I would need to make specific for my worksheet, eg. name of the Worksheet? My workshhet is called Inputs. Many thanks in advance for your help. -- Johanna |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Print Frozen Panes? | Excel Discussion (Misc queries) | |||
frozen panes | Excel Discussion (Misc queries) | |||
frozen panes print top of each page | New Users to Excel | |||
Drop down list & frozen panes | Excel Discussion (Misc queries) | |||
move to adjacent cell with panes frozen | Excel Discussion (Misc queries) |