Active screenupdating false updating applications in itunes
Screen Updating = False" statement) while the "Application.
Screen Updating = True Try running it and you should see a short pause followed by column A getting filled with numbers.I was watching the state of an object within the Workbook (the locked property of a specific style).no matter what I did in code to turn off screen updating, it would not work and my app slowed to a crawl.I was killing myself over why the heck screen updating was not set to false!!!! I solved my problem with a very simple solution: At the very very end of the code put: Application. Just try everything on this page and see if it works for you!Although I'm using VBA, not VB, I experienced the same symptoms when using Application.
Search for active screenupdating false:
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.