View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Activate Excel when double click

Are you sure Target refers to the previous cell. For me it refers to the
actual double clicked cell, even if the first click re-activates Excel to
select the new cell.

Include this in the event -
Debug.Print Target.Address

Regards,
Peter T


"Ran @Comverse" wrote in message
...
Hi,

My issue is as follows: I have 2 applicaions open when one of them is
Excel
(2007).
The active window is the second applicaion and now I double click on a
cell
in Excel which is different than the cell which I was on it in my last
session in Excel.

The event "Beforedouble click" for exmple will rise on the previous cell
which I was on it.

How can I make this event to rise on the new cell which I selected now?

Thanks,
Ran.