View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 1,327
Default Run some code on a left click

Not that I know of, leftclick is used by the worksheet itself to decide
where you want to go to.
You could put a transparent object from the drawing toolbar over the range
and assign the code to it perhaps ? I do that a lot.

HTH. Best wishes Harald

"cdb" skrev i melding
...
I have some code that I have managed to get to run when you right click in

a
certain range of cells using the Worksheet_BeforeRightClick option. Is

there
anyway of getting some code to work in the same range when there is a left
click??