Vb application screenupdating


Screen Updating=false is not working Here is my code: Application. If macro3 does turn screenupdating off but then turns it back on at the end, you'll see the screen redraw then. Simply removing Screenupdating = True from all the macros should resolve that. If your question is answered then please remember to mark it solved Computers are like air conditioners. Check other procedures that are called within your current one to check if they are changing your Application. However, as soon as I removed the watch, it worked fine. I ran into this problem a few times myself recently.



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!

Example This example demonstrates how turning off screen updating can make your code run faster.