DoubleClick Event - Supress CutCopyPaste after Cancel?

[aussieboykie]

When a Workbook_SheetBeforeDoubleClick event sets Cancel = True the normal double-click cell edit action is suppressed, as expected, but CutCopyPaste mode is activated as a side effect. Adding an Application.CutCopyMode = False statement to the event code does not have any effect. The user has to press Escape to get rid of the "Select destination and press ENTER or choose Paste" prompt.

DblClickCancel.png

Is there any way of suppressing the CutCopyPaste prompt or is this working as designed?

Regards, AB

[JosephP]

do you have any code in the worksheet?

[aussieboykie]

do you have any code in the worksheet?

No. The only code in my test case is the Workbook_SheetBeforeDoubleClick subroutine in ThisWorkBook and I said in my OP, the Application.CutCopyMode makes no difference.

Please Login or Register  to view this content.

[JosephP]

if you comment out that code and doubleclick a cell what happens? do you get the same copy mode? which version of excel do you have?

[aussieboykie]

If the DoubleClick event is missing or supressed, then double click puts the cell into edit mode. This is normal behaviour. I first noticed the symptom in Excel 2003 running in an XP virtual machine. I subsequently created a test case (new blank Excel workbook, no macros except for the DoubleClick event handler) in Excel 2010 on my work laptop. Symptoms are the same in both environments.

[JosephP]

it doesn't happen for me. do you get the same behavior if you run excel in safe mode? also if you use a worksheet_beforedoubleclick do you get the same issue?

[aussieboykie]

it doesn't happen for me.

That's useful input. When I get home I'll try on another system. Given that it doesn't happen to you, and I'm not prone to paranoia, I'll have to explore other avenues. Regional settings spring to mind but that may be grasping at straws.

In answer to your question, I do see the same symptom with worksheet_beforedoubleclick.

[JosephP]

and safe mode?

[aussieboykie]

and safe mode?

I haven't tried that yet but I have confirmed that the same code does not display the symptom on my desktop (Excel 2010) at home. If, as and when I get to the bottom of what's causing this I'll report back to close the loop. Thanks for your help.

Regards, AB

[JosephP]

if it doesn't happen when you run Excel in Safe Mode then you'll know that it's one of your addins or startup files (most likely cause imo)

[aussieboykie]

if it doesn't happen when you run Excel in Safe Mode then you'll know that it's one of your addins or startup files (most likely cause imo)

I'd agree with you if it just happened on the top level system but the virtual machine (Excel 2003) system is pure vanilla. No addins, no startup files.

[JosephP]

that might depend on what folders you shared between the two? anyway, would only take a minute to test. :-)

[aussieboykie]

Further testing suggests that this may be caused by a combination of some mix of a VM running on VMWare ESXi under VMWare Workstation on a corporate Intranet. Much more debugging to be done.... (tomorrow). Exciting stuff. I'll keep you posted.

[JosephP]

of course, I should have thought of that. ;-)

[aussieboykie]

of course, I should have thought of that. ;-)

Well, the answer turns out to be even more esoteric than I had imagined. I have narrowed it down to an application - Concise Oxford English Dictionary 12th edition, revised, on CD-ROM (v1.0) - which I fire up reasonably often. When this application is open, double click in Excel (where the workbook includes a BeforeDoubleClick event that sets Cancel = True) sets the CutCopy marquee active. When the application is closed, double click behaves normally. I will report this to the COED developers.

Regards, AB