Double-click referencing to other worksheets
 

What do I need to do to enable double-click referencing to other
worksheets? For example, I am working on Workbook A which links to
data in Workbook B. I want to be able to double click on a cell in
Workbook A and pull up the linking data in Workbook B.

Any assistance regarding this matter would be greatly appreciated!
Thanks!


--
apubapu82
------------------------------------------------------------------------
apubapu82's Profile: http://www.excelforum.com/member.php...o&userid=33201
View this thread: http://www.excelforum.com/showthread...hreadid=530191

Double-click referencing to other worksheets
 

ToolsOptionsEdit.

Uncheck "edit directly in cell".


Gord Dibben MS Excel MVP

On Wed, 5 Apr 2006 13:54:55 -0500, apubapu82
wrote:


What do I need to do to enable double-click referencing to other
worksheets? For example, I am working on Workbook A which links to
data in Workbook B. I want to be able to double click on a cell in
Workbook A and pull up the linking data in Workbook B.

Any assistance regarding this matter would be greatly appreciated!
Thanks!

Double-click referencing to other worksheets
 

Thanks so much for the prompt response! :)


--
apubapu82
------------------------------------------------------------------------
apubapu82's Profile: http://www.excelforum.com/member.php...o&userid=33201
View this thread: http://www.excelforum.com/showthread...hreadid=530191