Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can you link a worksheet name into a cell? | Excel Discussion (Misc queries) | |||
How can I link cell colours from worksheet to worksheet/workbook? | Excel Worksheet Functions | |||
Why can't I link a cell from worksheet to another when it has an . | Excel Worksheet Functions | |||
How can I link a cell in one worksheet to a cell in another works. | Excel Worksheet Functions | |||
Why am I unable to link a cell in one worksheet to a cell in anot. | Excel Discussion (Misc queries) |