Application screenupdating true
I have seen the other posts on this topic, where the property does not function in Excel 2016, but there still does not appear to be a remedy for this problem.I, like probably thousands of vba writers are now finding their Excel 2010 (or earlier) macros employing this property to suppress screen flicker (and jumping between workbook windows) now make their applications look very . So I deliberately wrote the code to do a few screen changes as fast as possible and display those changes so the users will keep their hands off the task manager buttons. It takes a little longer to run with screenupdating enabled, on average about 5% longer. The people using it get antsy and many of them wind up killing excel and restarting because they think it froze up.
Many people write their own macros to manipulate the information in a workbook.is your source for cost-effective Microsoft Excel training.This tip (9151) applies to Microsoft Excel 2007, 2010, and 2013.This example demonstrates how turning off screen updating can make your code run faster.The example hides every other column on Sheet1, while keeping track of the time it takes to do so.