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.
Forum Rules. Help Forgotten Your Password? Remember Me? ScreenUpdating not working.