Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Mar 2001
    Location
    Blue Mountains, New South Wales, Australia
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Msgbox "No Return or Halt Function... (Excel 97 (SR-2))

    I sometimes(?) get the attached msgbox ( I think) when the autosave add-in runs? I think it has also appeared at other times as well...

    I've checked my files, and cannot find any macro sheets, which I guess are a carryover from Excel 95.

    Any ideas?
    Attached Images Attached Images

  2. #2
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Msgbox "No Return or Halt Function... (Excel 97 (SR-2))

    YIKES!!! I'm having flash backs, make them go away!!! Can you tell I've had this problem before and spent lots of time with MS support? Bottom line = you're screwed. It's rebuild time. I got this mysterious message on my project (large xl97/xl2000 project with 15,000 lines of VBA and other stuff). It would flash on my screen many times a day. I finally contacted MS and they told me it's a message from the old style Excel95 macros and agreed that it shouldn't be coming up in my project since I'm not using that style of coding (I don't even know what it looks like).

    After some troubleshooting I figured out that you CAN get these old style macros stuck in your xl97/xl2000 project if you use the 'assign macro' from the right-click button (like if you used the drawing tool to make a button). I proved this to MS and sent them a spreadsheet, the tech support guy didn't know about this error). Also if you remove the code the error still exists as you can't really get rid of it, it's buried deep inside Excel and it can't be deleted (major bug but the MS tech guy said that yes, Excel still is very bad at cleaning itself up).

    So for the 5th time in a year, I rebuilt my entire project from scratch. Ahhhh, okay, I'm much calmer now, don't worry about me....

    Deb <img src=/S/bash.gif border=0 alt=bash width=35 height=39>

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Msgbox 'No Return or Halt Function... (Excel 97 (SR-2))

    Have you tried reinstalling the add-in?

    In addition to this, check out my improved autosave utility at Stephen Bullen's website, find it at the bottom of this page:

    www.bmsltd.ie/mvp

    Edited Mar 13th 2004 to update link
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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