Application screenupdating in vba

Application screenupdating in vba

Simply put when you are

Set calculation mode to manual, then at the end, put it back to the user's setting.

As for the EnableEvents

Simply put, when you are turning this property off, you are essentially saying don't let any event be triggered when something happens. As for the EnableEvents, you want to be careful about when to turn this off and on. Of course, this would result from either poor coding or the programmer forgetting to put that line to turn it back on at the end of the process. First, when you are relying on implicit code, relying on such things can cause problems down the road when you make modifications to the code.