When we switched from Excel 2010 to 2013, we noticed intense screen flashing while long macros created in Excel 2010 were running even though the macro began with
Application.ScreenUpdating = False
and ended with
Application.ScreenUpdating = True
I found out that this code no longer allows me to have two open workbooks where the one we open manually is visible and the other we open by VBA is not visible. This was due largely to my use of code like
to switch between workbooks. I've learned that using code like
Workbooks(1).Sheets(intCounter).Range("C5:H5").Value = strPONumber
resolves the flashing problem.
The one problem with still remains is how to hide the opening of the second workbook from the user while still allowing them to see the changes that are happening in the first workbook. In the first workbook I'm using code like
Application.StatusBar = strMsg
to let them know how the macro is progressing.
Every solution I have tried either gives a big white "flash" while the second workbook opens and is hidden, or completely disables both workbooks so that the status bar shows nothing and the program appears to be "locked" until the macro finishes.
Surely using Excel like this is so common that there has to be a solution. But everything I've been able to find so far may work on other versions of Excel, but not 2013.
I'd appreciate some help.