Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Feb 2001
    Location
    Springdale, Arkansas
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts
    We have identical settings with Excel 2007. Macros will run normally on my computer but stops on coworkers' computer. After some lines it will stop and bring up the debug/stop dialog.
    If I hit debug and then let it continue it will run a few more instructions and then stop again.

    Any thoughts??

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Bill,

    Can you post the code and indicate the line where it chokes and the error message you get.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Do you have all the same patches and updates installed, and the same add-ins? I've had that issue a few times in the past and it always randomly cleared up after an Office or Windows update.
    Regards,
    Rory

    Microsoft MVP - Excel

  4. #4
    Star Lounger
    Join Date
    Feb 2001
    Location
    Springdale, Arkansas
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts
    This has happened on multiple macros and never seems to stop at the same place. Also these are new computers supplied by employer so I'll check to make sure with help desk there are no updates required.

Posting Permissions

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