linked cells
 

Hi,

On Sheet1 I have cells linked to cells in Sheet2, Sheet3.... (I did Copy and
Paste Link). With about 20 sheets in a workbook, it gets difficult to go
between Sheet1 and the rest of the sheets.
Is there a way, e.g. double click on a linked cell on Sheet1 to activate the
sheet (Sheet2, Sheet3 ...) with the source cell on it?

Thanks,

linked cells
 

If you go to Tools=Options=Edit tab and uncheck "Edit Directly in Cell",
then you can double click on it an be taken to the link.


--
Regards,
Tom Ogilvy


"Penka" wrote in message
...
Hi,

On Sheet1 I have cells linked to cells in Sheet2, Sheet3.... (I did Copy
and
Paste Link). With about 20 sheets in a workbook, it gets difficult to go
between Sheet1 and the rest of the sheets.
Is there a way, e.g. double click on a linked cell on Sheet1 to activate
the
sheet (Sheet2, Sheet3 ...) with the source cell on it?

Thanks,