hyperlink to defined name in same document

[stenmark]

Hi

When a hyperlink is done to a defined name in same document it will select the cell at botton of document...I would like the targeted cell (name) to be displayed at the top of the document...Anyone know how to do this?

Thanks in advance.

[/img]

 

[GlennUK]

Can you explain exactly what you mean ... what is the definition of the name? Is cell the one you expected to be selected? When you say "I would like the targeted cell (name) to be displayed at the top of the document." do you mean you want the scrolling to show the selected cell at the top of the window? ( that is not the same as position within a document ... or sheet as we like to say when using Excel )

 

[stenmark]

"do you mean you want the scrolling to show the selected cell at the top of the window?"

yes, that is correct =)

thanks

 

[GlennUK]

Put a selection change event into the worksheet code, like this:

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
    Set isect = Application.Intersect(Target, Range("ThereItIs"))
    If isect Is Nothing Then
        ' do nothing
    Else
        ActiveWindow.ScrollRow = ActiveCell.Row
        ActiveWindow.ScrollColumn = ActiveCell.Column
    End If
End Sub

 

[stenmark]

thanks...but how do I do that? =)

thanks a lot for the help!

 

[GlennUK]

For the sheet where the named range is, right-click the sheet tab and do View Code. Then paste the code I've given into the code window .... altering the name I have "ThereItIs" to whatever name you've defined.