Share via

Excel 2016 mac VBA debug button does nothing

Anonymous
2016-12-16T19:12:36+00:00

Hi guys, I recently got a new Mac at work, had to install everything fresh, after installing Office 2016 and making sure to be up to date with all the latest updates when using the VBA editor, if an error occurs in the code I get the usual "Microsoft visual basic" popup screen with the two options "Abort" or "debug"  I have noticed that the "debug" option no longer works, no longer highlights the line of code that caused it to crash. Then I looked further and realized that I can no longer step through the code with breakpoints anymore, it ends at the first breakpoint and nothing happens when you press the next button. I have tried removing all of the Microsoft sweet and reinstalling several times.  Any ideas?

Running:

MacOS Sierra version10.12.2

Excel for mac version 15.29.1

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

15 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-01-10T21:29:42+00:00

    Hi Ryan,

    Sorry for the inconvenience.

    We've reported this issue to the related team, you will be informed if there is any update.

    Regards,

    Yoga

    Was this answer helpful?

    0 comments
  2. Anonymous
    2017-01-10T20:03:35+00:00

    Can we confirm if there is any progress on this, i have been using a VM to run VBE for almost a month at this point, it's rather frustrating

    Was this answer helpful?

    0 comments
  3. Anonymous
    2017-01-04T07:12:25+00:00

    Hi Giordano,

    We are investigating the issue, you will be informed if there is any update.

    Regards,

    Yoga

    Was this answer helpful?

    0 comments
  4. Anonymous
    2017-01-03T08:30:41+00:00

    I confirm the same here.

    Can't debug in this way. Hope MS finds a solution really soon.

    Was this answer helpful?

    0 comments
  5. Jim G 134K Reputation points MVP Volunteer Moderator
    2016-12-24T22:24:48+00:00

    I can confirm that in updates 15.29 through 15.31 the VB Editor behavior is as Ryan described. No amount of uninstalling or reinstalling will fix this.

    Microsoft is the process of building a new VB Editor from scratch, and it is my hope that it will be released very soon. Meanwhile, I don't expect fixes to the editor we currently have.

    Was this answer helpful?

    0 comments