title: BeforeDoubleClick macro trigger not working in excel 2010 VBA
body: <p>I am trying to trigger a macro in excel 2010 using the <code>BeforeDoubleClick</code> procedure. However, it does not appear to be working. I have searched extensively to see if other people have been having the same problems, a couple have but I have tried their solutions and it either wasn't applicable or didn't work. The code is very simple as I have stripped it back in order to test it.Is there something foolishly wrong with my code? (I am a Stack and VB noob so please be patient)</p>
  
  <pre><code>Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
      If Target.Value = "GO" Then Cancel = True
      MsgBox ("done")
  End Sub
  </code></pre>
  
  <p>I have tried setting it to public sub, putting "Application.EnableEvents = True" in the immediate window. Workbook is set to enable all macros. No add ins are running. I have been through the XLSTART folder and its all empty. Even created a digital signature at one point as someone suggested it. Could it still be some from of compatibility issue with previous versions of excel?</p>
  
  <p>Also when you do double click in the work sheet even though cancel = True the cell just opens up for editing as normal.</p>
  
  <p>Please Help</p>