I used to think that "Thank you"s and "Your welcome"s were
just contributing noise and wasting bandwidth. But I was wrong.

Thank you. (and .. and .. and ..) Dave D-C

Dave Peterson wrote:
The event looks like:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, _
Cancel As Boolean)
You can just use:
Cancel = true 'to stop from going into edit mode.
(same thing with the _beforerightclick event.

Dave D-C wrote:
But I have found out that doing a
Userform1.Show
in a BeforeDoubleClick routine will leave the doubleclicked
cell in 'Edit' or 'Enter' mode, which causes me problems.
It's as if EnableEvents becomes false, but I'm not setting it.

My workaround is ..
Can somebody address this (related) issue?