Worksheet_BeforeDoubleClick not firing

[mbt2103]

I have the following code in all four sheets of a workbook I'm working on:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True
Debug.Print Target.Address
End Sub

It doesn't do anything, in any of the sheets.

When I put it in a fresh workbook, it works just fine.

 

[mbt2103]

Answer: VBA was in design mode.

 

[Fluff]

Try typing this in the intermediate window

?application.EnableEvents

if it says False then events have been disabled

 

[mbt2103]

Try typing this in the intermediate window

?application.EnableEvents

if it says False then events have been disabled

Wooooaaah. "?" is shorthand for "debug.print "?!?!!

That's amazing, and I am unnecessarily excited.

 

[Fluff]

Wooooaaah. "?" is shorthand for "debug.print "?!?!!

Only within the the intermediate window.
In the code you have to use debug.print

Have a good weekend

 

[Rick Rothstein]

Only within the the intermediate window.
In the code you have to use debug.print

You can type Debug.? in a module if you want, but VB will automatically expand the question mark to the word Print once you commit the line of code.

 

[Fluff]

You can type Debug.? in a module if you want, but VB will automatically expand the question mark to the word Print once you commit the line of code.

Never new that, admittedly I checked that you couldn't just use the ? in the code & noticed it change to Print. But didn't think to put the two together.

 

[Rick Rothstein]

I checked that you couldn't just use the ? in the code & noticed it change to Print.

The conversion of a solitary question mark to the Print keyword is left over from the compiled versions of Visual Basic (whose core code lies at the heart of VBA) where you were allowed to use the Print command directly to write on the surface of the Form (somewhat equivalent to VBA's UserForm, but with differences, obviously) as well as its PictureBox control.