+ Reply to Thread
Results 1 to 2 of 2

Simple Macro crashes Excel

  1. #1
    Registered User
    Join Date
    04-28-2010
    Location
    United States
    MS-Off Ver
    Excel 2003, 2007, 2010 beta
    Posts
    1

    Exclamation Simple Macro crashes Excel

    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:
    Please Login or Register  to view this content.
    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.

    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?
    Last edited by ibsteveog; 04-28-2010 at 06:17 PM. Reason: Added note about crash not occurring in Excel 2010 Beta

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,298

    Re: Simple Macro crashes Excel

    Seems to be a bug. If you use Ontime to run a macro that activates A1, the crash doesn't occur.
    Remember what the dormouse said
    Feed your head

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1