Excel vba screenupdating not working

I've been developing this really massive VBA Excel Application as part of a government contract and it's gotten to be about 55, lines of code, optimized down from more than double that of course. Everything seems to be working nearly perfect and I think I've even solved my problem with the call to Application. ScreenUpdating, but I'm not really sure why, and I couldn't find documentation relating to the problem I found or the work around that I developed. It seems that making a change to any cell on any sheet in VBA code will cause the application to change the users view to that sheet.

Forums New posts Search forums. What's new New posts New profile posts Latest activity. Members Current visitors New profile posts Search profile posts. Log in Register. Search titles only.

By using our site, you acknowledge that you have read and understand our Cookie Policy , Privacy Policy , and our Terms of Service. Stack Overflow for Teams is a private, secure spot for you and your coworkers to find and share information. I know there are lots of threads relating to this topic, like don't use "Select" or "Activate" or set it to false if you need to use it.

Forum Rules. Help Forgotten Your Password? Remember Me? ScreenUpdating not working.