Hi all, I've got a brand new little workbook I created in Excel 2007 just to demonstrate this problem. It's posted here: http://k5sen.net/Book1.xlsm
If you'd like to create the workbook yourself, then create a chart and define the beforedoubleclick event as such:
Excel crashes to the desktop whenever you trigger this event on the chart. Using the same code body in the chart's BeforeRightClick function works just fine, oddly enough.Please Login or Register to view this content.
Here's the rest of the macro code if you are doing it yourself:
Module "GeneralStuff":
Please Login or Register to view this content.
And the class module...
Class Module "SpecialChart":
Please Login or Register to view this content.
Am I doing it wrong? Or is this just an Excel 2007 bug? I checked the Excel 2010 beta and this code works just fine. Is there a workaround for 2007?
Bookmarks