Linking cells in worksheets

  • Thread starter Thread starter Jazzad
  • Start date Start date
J

Jazzad

I have seen it where you can double click a link in a
worksheet to another worksheet in the same Workbook and it
opens the worksheet that is being referenced.
eg. in sheet one there is a value in cell a1 that is
coming from sheet 2
when you double click the cell it opens sheet two.
At the moment it just opens the formula.
any ideas people??????
Thanks you.
Jazza
 
I have seen it where you can double click a link in a
worksheet to another worksheet in the same Workbook and it
opens the worksheet that is being referenced.
eg. in sheet one there is a value in cell a1 that is
coming from sheet 2
when you double click the cell it opens sheet two.
At the moment it just opens the formula.
Click to expand...

You might mean a hyperlink, although unlikely since that only needs one
click.

Maybe (Tools -- Auditing --) Trace Precedents?

HTH,
Andy
 
Put the following code into a new worksheet. Two ways to do this.
Firstly, right-mouse click on the "Sheet1" tab at the bottom of th
screen and selection view code. In the drop down where is say
general, choose "Worksheet" and on the right hand one choos
"BeforeDoubleClick". Paste the code below into module. Alternativel
can access this in the Project Explorer, putting code into Sheet1.


Dim MyCell As String
MyCell = ActiveCell.Address
If MyCell = "$A$1" Then
Worksheets("Sheet2").Activate
End If

This will flip to Sheet2 when you double click on A1.

Hope this help
 
<"At the moment it just opens the formula">

Just disable this, and you can then "jump" to the linked cell.

<Tools> <Options> <Edit> tab,
And *uncheck* "Edit Directly In Cell".
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I have seen it where you can double click a link in a
worksheet to another worksheet in the same Workbook and it
opens the worksheet that is being referenced.
eg. in sheet one there is a value in cell a1 that is
coming from sheet 2
when you double click the cell it opens sheet two.
At the moment it just opens the formula.
any ideas people??????
Thanks you.
Jazza
 
Back
Top