Screen updating is especially important for long-running macros (e.g.interactive macros, long calculations) to let the user know that the macro is still running and that Excel has not crashed.By leaving the main window alone, and forcing other workbooks to become not visible, letting the code run, then bringing them back to visible, it stopped flickering. I have been experimenting with this technique, and although it doesn’t stop the flickering completely, it improves the result in an important way: It restores visibility to the Status Bar message, which I update every few seconds to show the application’s progress. Making the new output workbook invisible will crash the program during some operations, but making the macro workbook invisible after adding the new output workbook seems to suppress all but one flicker, and it preserves the Status Bar display. Here are some links to people who have also noticed this problem:
Screen Updating = True ' Enable to refresh screen Application.
Unfortunately, I have to maintain hundreds of Excel applications each with thousands of lines of code and hundreds of users who are about to migrate to Office 2016, so rewriting is not an option. I wanted to leave a comment but I am not allowed to do so.
Without a code sample it is very dificult to understand your problem (please see https://stackoverflow.com/help/how-to-ask and edit your question appropriately.
- Try this at the beginning of your procedure: This solved my flicker problem, but I didn't like how the excel application disappeared completely then suddenly reappeared for the user.
I was able to solve the issue to my liking by using a workaround this 'which window is on top' problem.