Hi,
I'm running Office 365 V16.47 & Catalina 10.15.6
I've narrowed down the scenario a little. I have two monitors with one the Excel sheets and the other the VBE. If I run a macro with a code error from the Excel directly (ie a shape with the macro assigned to it) the error debug popup appears on over the Excel sheet. No problems, press debug and off we go correcting the code.
If I run the macro from the arrow in the VBE, the same error debug occurs but isn't visible on either of the monitors, behind either Excel or the VBE applications. If F3 (the Mission Control feature) is pressed, the error debug box appears where it can be selected as the active application (by mouse or spacebar) but then pressing on the debug/ end etc buttons only exists out of Mission Control.
Microsoft called me back after they fast tracked the issue but I couldn't take their call at the time and asked them to call me back later. Instead, they just closed the case. Good stuff Microsoft.
Sahobbi, can you try to emulate the above and tell me if the same scenario is tru for you too, please?
I'm going to get back to Microsoft as my feedback to reopen the case has fallen on a deaf ear.
@Sahobbi
