double click event suddenly not working

[IncurableTrekkie]

hi all, I'm stumped with this problem. I have a spreadsheet that uses doubleclick macros on various sheets to return a value to another sheet and it's been working perfectly since the beginning. Now all of a sudden the double click event doesn't trigger, just puts you in edit mode in the cell.

The only thing I have done in the last few days is to add another macro using the calculate event to highlight if there is a filter on anywhere in the sheet (I copied that from this site and it worked fine).
I've removed all vestiges of that macro and the double click still doesn't work.

I must be something that I've done, I'm not a VB expert but I'm in big trouble unless I can get this working again.

thanks in advance for all your help, here's the miscreant macro.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)

Dim SourceCol As Integer
Dim LinkName As String

SourceCol = ActiveCell.Column

' If double click is in column C Pass a name to the Input screen
   If SourceCol = 3 Then
        LinkName = ActiveCell
        LinkToAuditInput (LinkName)
    End If
      
' If double click is in column AR Pass a name to the courses filter
    If SourceCol = 49 Then
        FilterCourses
    End If
      
End Sub

 

[RoryA]

Have you restarted Excel? The most likely explanation is that some code disabled events and then didn't re-enable them. Restarting Excel will rectify that although you should really find that code and make sure it can't leave events disabled.

 

[IncurableTrekkie]

the reboot worked! I had tried re-enabling events and confirmed it by running another little macro I found on here that displays a enabled or disabled message. This is going to bug me until I figure out how I broke it but meanwhile all is well.
Thanks a million, there's a reason you are one of the few sites our over-zealous site blockers allows

 

[RoryA]

Glad to help.

tThis is going to bug me until I figure out how I broke it

Search for:

Application.EnableEvents = False

in your code and then figure out how it might end without re-enabling them.