I have created some link formula,
Example
CellA1 has ='Corridor Select- Input'!C5.

I was told by a colleague that there is a function in excel that allows me
to auto go to that linkd source. ie if I double click on Cell A1, I can
automatically go to Sheet"CorridorSelect-Input" Cell C5.

I have tried doing that but it does not work. Just wondering if I am doing
anything wrong.
--
Thanks a million for your time and expert advice :-)
Jaylin
*****Jaylin Message ended*******

CellA1 has ='Corridor Select- Input'!C5.
.. to auto go to that linked source

Tinker with this:

Select A1
Click Tools Auditing Trace Precedents
Double-click on the dotted arrow / little sheet icon
to bring up the "Go to" dialog, then just either
double-click on the link in the box (or select it and click OK)
which will zap you straight to: 'Corridor Select- Input'!C5
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jaylin" wrote in message
...
I have created some link formula,
Example
CellA1 has ='Corridor Select- Input'!C5.

I was told by a colleague that there is a function
in excel that allows me to auto go to that linkd source.
ie if I double click on Cell A1, I can
automatically go to Sheet"CorridorSelect-Input" Cell C5.

I have tried doing that but it does not work.
Just wondering if I am doing anything wrong.
--
Thanks a million for your time and expert advice :-)
Jaylin
*****Jaylin Message ended*******

Dear Mr Max
Thank you very much for yoru help. I try to follow your advice but when I
double click on the dotted line, the GOTO Box pop up. And I have to select
that formula again to go to the link.

Just wondering if I am doing correctly.
--
Thanks a million for your time and expert advice :-)
Jaylin
*****Jaylin Message ended*******


"Max" wrote:

CellA1 has ='Corridor Select- Input'!C5.
.. to auto go to that linked source

Tinker with this:

Select A1
Click Tools Auditing Trace Precedents
Double-click on the dotted arrow / little sheet icon
to bring up the "Go to" dialog, then just either
double-click on the link in the box (or select it and click OK)
which will zap you straight to: 'Corridor Select- Input'!C5
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jaylin" wrote in message
...
I have created some link formula,
Example
CellA1 has ='Corridor Select- Input'!C5.

I was told by a colleague that there is a function
in excel that allows me to auto go to that linkd source.
ie if I double click on Cell A1, I can
automatically go to Sheet"CorridorSelect-Input" Cell C5.

I have tried doing that but it does not work.
Just wondering if I am doing anything wrong.
--
Thanks a million for your time and expert advice :-)
Jaylin
*****Jaylin Message ended*******

Just wondering if I am doing correctly.
Don't think you're doing anything wrong

We can also double-click *directly* on the link in the "Go to" dialog as per
steps given earlier:

... to bring up the "Go to" dialog, then just either
double-click on the link in the box (or select it and click OK)
which will zap you straight to: 'Corridor Select- Input'!C5

Not sure of any other / shorter way
(In Excel 97, my ver)

btw, there's no need for the "Mr." stuff <g
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jaylin" wrote in message
...
Dear Mr Max
Thank you very much for yoru help. I try to follow your advice but when I
double click on the dotted line, the GOTO Box pop up. And I have to select
that formula again to go to the link.

Just wondering if I am doing correctly.
--
Thanks a million for your time and expert advice :-)
Jaylin

Perhaps an alternative to play with, using the "barebones" sub below
(Just tinkered around with the macro recorder)

Steps:

Press Alt+F11 to go to VBE
Click Insert Module
Copy paste everything within the dotted lines below
into the code window (whitespace) on the right

'-----
Sub JumpToLinkCell()
ActiveCell.ShowPrecedents
ActiveCell.NavigateArrow TowardPrecedent:=True, _
ArrowNumber:=1, LinkNumber:=1
End Sub
'----

In Excel, press Alt+F8
Select "JumpToLinkCell" in the macro list
Click "Options"
Enter a "j" for the shortcut key OK

Test it out. Select a cell with a link formula to another sheet in the same
book. Press CTRL+j to run, and you'll be zapped instantly to the source
cell in the linked sheet. (Need to go back & clear the arrows later, though
...)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Thanks a million again for your expert advice.

I ve also found another way to get to the source link.

It is by unchecking the "Edit directly in cell" in the Tools -- Option --
Edit

Jaylin
*****Jaylin Message ended*******


"Max" wrote:

Perhaps an alternative to play with, using the "barebones" sub below
(Just tinkered around with the macro recorder)

Steps:

Press Alt+F11 to go to VBE
Click Insert Module
Copy paste everything within the dotted lines below
into the code window (whitespace) on the right

'-----
Sub JumpToLinkCell()
ActiveCell.ShowPrecedents
ActiveCell.NavigateArrow TowardPrecedent:=True, _
ArrowNumber:=1, LinkNumber:=1
End Sub
'----

In Excel, press Alt+F8
Select "JumpToLinkCell" in the macro list
Click "Options"
Enter a "j" for the shortcut key OK

Test it out. Select a cell with a link formula to another sheet in the same
book. Press CTRL+j to run, and you'll be zapped instantly to the source
cell in the linked sheet. (Need to go back & clear the arrows later, though
...)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---