I'm having a problem with my VBA app an all Office 2013 computers. When they run some procedures, they get strange errors no one gets in pre-2013 versions. This is the most urgent I'm dealing with now:
Workbook1 is open. Procedure_A calls userform_A which creates a Workbook2 filling it with calculations from Workbook1. When both are finished, Workbook2 is active but its ribbon is frozen, blank. If I switch back to Workbook1, its ribbon is visible and functional. The only way to close workbook2 is by right-clicking on the task bar. This does not happen on Excel 2010.
I know this is happening because SDI doesn't work well with modal user forms, but it would be a pain in the neck to rewrite several parts of my code just to go modeless, not to mention finding ways to prevent users from ruining everything by clicking on the background while the user form is still active.
Is there any work around this?