title: Excel: Trigger double click event
body: <p>I have an Excel workbook that has been password protected by a third party. The interaction in that worksheet is done with double clicks to toggle check marks in fields. I would have to do 7000 double clicks to finish this task, so I would like to automate it. My suspicion is that the worksheet is using the BeforeDoubleClick event. The password encryption hides the actual implementation.</p>
  
  <p>I started out running a test in my own worksheet, without a password, to rule those issues.</p>
  
  <p>I have tried Application.DoubleClick:</p>
  
  <pre><code>Range("B17").Select
  Application.DoubleClick
  </code></pre>
  
  <p>But that doesn't trigger my event code (Worksheet_BeforeDoubleClick), which do work for "real" double clicks.</p>
  
  <p>That is apparently by design according to MS:
  <a href="http://msdn.microsoft.com/en-us/library/office/aa220809(v=office.11).aspx" rel="nofollow">http://msdn.microsoft.com/en-us/library/office/aa220809(v=office.11).aspx</a></p>
  
  <blockquote>
    <p>The DoubleClick method doesn't cause this event to occur.</p>
  </blockquote>
  
  <p>I can't call the third party event code directly, since the sub is private. Is there a way around this?</p>
  
  <p>I have tried this both in Excel 2003 and 2007.</p>