Archive of Mr Excel Message Board
Back to Links in Excel archive index
Back to archive home
double click in cell to go to link
Posted by Tomas Matta on February 14, 2002 4:41 AM
I have seen that you can go to a link in a cell by directly double clicking on it. For example, if cell A1 was reading from another file, if you double click on A1 the file you were reading from opens. How do you set up excel to do this?
thanks in advance,
Tomas
Re: double click in cell to go to link
Posted by Scott R on February 14, 2002 1:02 PM
Turn off the "Edit directly in cell" in Tools, Options, Edit dialog box.
Re: double click in cell to go to link
Posted by Tomás Matta on February 14, 2002 2:56 PM
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.