Excel 2016 application screenupdating not working dating teenage victim violence

by  |  01-Nov-2019 20:05

By the way, I am having the same problem where I set it to False and it doesn't go false.

excel 2016 application screenupdating not working-39excel 2016 application screenupdating not working-87

791577-Application-Screen Updating-not-working-in-Excel-2013 https:// test the difference in screen updating, try running the one-and-only macros in these files: first file does not use Application. Adding Do Events, which normally makes Excel responsive while a macro is looping, does not help either situation.

which obviously isn't working because the screen updates a whole lot afterwards. I almost wish this were more complicated; the fact that everything looks so simple is making it difficult to think of what could possibly be happening! So this morning application.screen Updating was working as expected. The test code that I wrote is below: Sub test() Debug. One thing that seems to be common among those modules not working, is that they all contain code that changes worksheets. In any case, it's a real mystery why this happens from one day to another!

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.

Here are some ideas: - Check if your code calls for code in a different procedure, maybe the Application.

All those Screen Updating = False's you see is called "sheer desperation". I can still enter the workbook and it is screenupdating away even right after the line set it false. Screen Updating = False" in the immediate window it works as expected. Thanks Colin Correct, when you step through in debug mode the screenupdating remains turned on. To test it properly, try this: Put a commandbutton on your sheet and paste in Application. Net) | Coordinates, Vectors and 3D volumes I've experienced this problem, with code that previously worked!

Community Discussion