Here are some ideas: - Check if your code calls for code in a different procedure, maybe the Application. Screen Updating is turned on outside of the procedure.
Screen Updating=False works as prescribed in all our Windows Excel versions and in Excel 2011 for the Mac.
In our copy of Excel 2016 (Version 15.26) for the Mac it has no effect.
It would be useful to know if there are any Excel 2016 for Mac users out there for whom Screen Updating =False does work. This comprehensive step-by-step guide will help get your database-driven ASP.
NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
I turned off the debugger and tried the same code and it flickers between the books. But that shouldn't alter the way it works when a routine / function is run.
To evaluate this better, can you post a sample file which replicates the scenarios you explained above?
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.
I guess this wasn't clear from my first post, but is there some reference that I don't have installed?