ToolsOptionsEdit.

Uncheck "edit directly in cell".

Now when you double-click on a linked cell, you will switch to the source
worksheet.

Won't go back to original linked cell.

It's a one-way street.

Alternative..........

In an unused cell enter a hyperlink to the linked sheet.


Gord Dibben Excel MVP


On Mon, 21 Mar 2005 08:55:03 -0800, "Animesh"
wrote:

How do I navigate on a click between linked worksheets in Excel?