Link between a cell and a cell on another worksheet
 

Hi,

I have an excel file made by someone else (who is not available right now).
When I double click on a specific cell from worksheet1 it brings me to
worksheet2 at a specific cell. I know that I can create a hyperlink. However
I don't think that a hyperlink was used to create this link since when I pass
over the cell from worksheet1 I do not see the handle (white hand) that
usually appears for a hyperlink. Also I do not see the underlined link that
usually appears for a hyperlink. Any comment on how to create this type of
link is appreciated.

Thanks in advance for your help. Have a good day.

Pablo

Link between a cell and a cell on another worksheet
 

Pablo,

There is VBA programming "Event" code built into each sheet in a workbook.
The Worksheet_BeforeDoubleClick event sub is one of these events.
You can right-click the sheet tab and select View Code to see the module
that would or does contain the code.
The code is executed any time a cell is double-clicked on that worksheet.
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"Pablo"
wrote in message
Hi,
I have an excel file made by someone else (who is not available right now).
When I double click on a specific cell from worksheet1 it brings me to
worksheet2 at a specific cell. I know that I can create a hyperlink. However
I don't think that a hyperlink was used to create this link since when I pass
over the cell from worksheet1 I do not see the handle (white hand) that
usually appears for a hyperlink. Also I do not see the underlined link that
usually appears for a hyperlink. Any comment on how to create this type of
link is appreciated.

Thanks in advance for your help. Have a good day.

Pablo

Link between a cell and a cell on another worksheet
 

If you have ToolsOptionsEdit "edit directly in cell" unchecked, a double-click
on a cell with a formula referencing another cell will jump you to the
referenced cell.


Gord Dibben MS Excel MVP

On Mon, 2 Jun 2008 18:56:01 -0700, Pablo
wrote:

Hi,

I have an excel file made by someone else (who is not available right now).
When I double click on a specific cell from worksheet1 it brings me to
worksheet2 at a specific cell. I know that I can create a hyperlink. However
I don't think that a hyperlink was used to create this link since when I pass
over the cell from worksheet1 I do not see the handle (white hand) that
usually appears for a hyperlink. Also I do not see the underlined link that
usually appears for a hyperlink. Any comment on how to create this type of
link is appreciated.

Thanks in advance for your help. Have a good day.

Pablo

Link between a cell and a cell on another worksheet
 

Gord,
Nice to know, thanks.
Jim Cone


"Gord Dibben" <gorddibbATshawDOTca
wrote in message
If you have ToolsOptionsEdit "edit directly in cell" unchecked, a double-click
on a cell with a formula referencing another cell will jump you to the
referenced cell.
Gord Dibben MS Excel MVP

Link between a cell and a cell on another worksheet
 

Thanks to both of you I will give it a try tomorrow at work and keep you
updated.

Pablo

"Jim Cone" wrote:

Gord,
Nice to know, thanks.
Jim Cone


"Gord Dibben" <gorddibbATshawDOTca
wrote in message
If you have ToolsOptionsEdit "edit directly in cell" unchecked, a double-click
on a cell with a formula referencing another cell will jump you to the
referenced cell.
Gord Dibben MS Excel MVP