Cancel argument in Before_DoubleClick event

Topic

New Reply

Hi, I’m trying to replace the default action of a double_click (or a right click) on a particular cell with my own action.

I can get my action to happen for the correct cell by testing the Target argument with Worksheet_BeforeDoubleClick or Worksheet_BeforeRightClick, but even though I specify Cancel = True the default action happens immediately afterwards – i.e. the cell goes into Edit mode when there’s a double click, or shows Excel’s default right-click menu when there’s a right-click.

Is this a known bug with Excel 2000 or am I missing something?

Jeremy

Reply | Quote

Replies

I’m not aware of such a bug. Could you post your code, or a copy of the workbook with sensitive info removed or altered?

Reply | Quote

Found the culprit! Took the age-old step of exiting and restarting Excel. Normally (on autopilot) I then load our SAP-BW add-in, but this time I didn’t and my code now works OK.

Obviously the add-in (which provides its own handler for double-clicks and right-clicks within BW query ranges) prevents me doing what I’m trying to do!

Jeremy

Reply | Quote

Obviously the add-in (which provides its own handler for double-clicks and right-clicks within BW query ranges) prevents me doing what I’m trying to do!

Yep, that explains it!

Reply | Quote

I had something similar in another forum a while ago. Turned out a third-party add-in was explicitly setting Cancel to False, for no good reason that I can think of!

Reply | Quote