+ Reply to Thread
Results 1 to 5 of 5

Macro Crashes Excel when run from Developer ribbon, Not from Immediate Window

  1. #1
    Forum Contributor
    Join Date
    10-02-2013
    Location
    Harrisburg, PA
    MS-Off Ver
    Office 365 MSO (16.0.10730.20264) 32-bit
    Posts
    160

    Macro Crashes Excel when run from Developer ribbon, Not from Immediate Window

    Hi All.

    On my system, when I run a macro from the immediate window it works fine. If I try to run it from "Developer|Macro|run" it causes excel to crash!!!

    I wrote the macro a year ago. It used to work on my system from the Developer ribbon. I tried it on 2 other colleagues' system and it worked fine from the developer ribbon.

    I have no Idea???

    Thanks.
    Steve
    Harrisburg, PA

  2. #2
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Macro Crashes Excel when run from Developer ribbon, Not from Immediate Window

    Is the office version the same on all the systems?
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  3. #3
    Forum Contributor
    Join Date
    10-02-2013
    Location
    Harrisburg, PA
    MS-Off Ver
    Office 365 MSO (16.0.10730.20264) 32-bit
    Posts
    160

    Re: Macro Crashes Excel when run from Developer ribbon, Not from Immediate Window

    Yep. All same office versions - 2013

  4. #4
    Forum Contributor
    Join Date
    10-02-2013
    Location
    Harrisburg, PA
    MS-Off Ver
    Office 365 MSO (16.0.10730.20264) 32-bit
    Posts
    160

    Re: Macro Crashes Excel when run from Developer ribbon, Not from Immediate Window

    I just added a new sub called "Do Nothing" with nothing between the declaration and end sub statement. This crashes excel when run from Developer|Macro|run. Runs fine from Immediate window

    Steve

  5. #5
    Forum Contributor
    Join Date
    10-02-2013
    Location
    Harrisburg, PA
    MS-Off Ver
    Office 365 MSO (16.0.10730.20264) 32-bit
    Posts
    160

    Re: Macro Crashes Excel when run from Developer ribbon, Not from Immediate Window

    More Info. I added the option to run the macro with a ctrl key... I set the macro to run with CTRL+J. It ran fine. Then I ran it from Developer|Macro|Run and it worked fine... I closed the file and re-opened it. Tried to run from Developer|Macro|Run and it crashed again. I closed / reopened, ran with Ctrl+j and it worked fine. Then ran fine from Deveoper|Macro|Run ...

    ????

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. why i am not able to see the macro in my excel file under developer-macro tab?
    By sumesh56 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-13-2016, 10:38 AM
  2. [SOLVED] Excel Crashes when using locals window to view custom-defined class
    By joe31623 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-11-2016, 04:23 PM
  3. Excel crashes when Macro is run, but only when the VBA window has been opened
    By EchoPassenger in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-04-2015, 08:55 AM
  4. Replies: 2
    Last Post: 05-01-2014, 02:11 AM
  5. Control SQL Developer via Excel Macro - An interesting challenge for you Geeks .. :)
    By georgemathew46 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-05-2013, 01:27 PM
  6. [SOLVED] Font in developer (code) window too small to read
    By Juli in forum Excel General
    Replies: 2
    Last Post: 03-28-2012, 05:06 PM
  7. Excel 2007 Crashes when attempting to enter Developer Mode
    By TwoyTaylor in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-01-2009, 04:42 PM

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