Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default doubleclick in cell to open link - how

Used to work with Excel 2003 and went in option and changed the setting there
- how to this in 2007 excel
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 523
Default doubleclick in cell to open link - how

Click on the office button, and at the bottom of the pop-up click "Excel
Options". Under "Advanced" there's a tick box for "Allow editing directly in
cells", make sure this is un-ticked.

"bjerre" wrote:

Used to work with Excel 2003 and went in option and changed the setting there
- how to this in 2007 excel

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default doubleclick in cell to open link - how

Excel 2003 has no function that would open a link with a double-click.

You can double-click in a cell to enter edit mode if your
ToolsOptionsEdit"edit directly in cell" is enabled.

If you have that disabled, a double-click will send you to cells referenced by a
formula in that cell.


Gord Dibben MS Excel MVP


On Tue, 16 Oct 2007 23:39:00 -0700, bjerre
wrote:

Used to work with Excel 2003 and went in option and changed the setting there
- how to this in 2007 excel


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
XLT files not opening on doubleclick Daniel Excel Discussion (Misc queries) 2 August 22nd 07 03:16 PM
ON.DOUBLECLICK function C Brandt Excel Discussion (Misc queries) 8 May 20th 07 12:27 AM
Force VB to doubleclick in a cell Brettjg Excel Discussion (Misc queries) 4 March 2nd 07 03:21 PM
Need VB code for workbook open to open a link Daniel Baker Excel Discussion (Misc queries) 2 August 18th 06 01:30 AM
doubleclick PH NEWS Excel Worksheet Functions 1 March 10th 06 11:54 AM


All times are GMT +1. The time now is 02:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"