linked cells

[Guest]

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,

 

[Tom Ogilvy]

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.