View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
steve_doc steve_doc is offline
external usenet poster
 
Posts: 140
Default doubleclick mrehod

Hi Dan

Taken from the VBE help section
"This example double-clicks the active cell on Sheet1."

all that that does is simulates a user dbl Clicking the Active Sheet, which
will not do anything unless you have written an event handler for the
Sheet1_DblClick event

HTH

"Dan" wrote:

According to Microsoft VB help the below should send a double click - but
this is not working - any idea how I can send a double click on a cell in
Excel.

Thnaks
Dan

Worksheets("Sheet1").Activate
Application.DoubleClick