There are a few reasons why you might want to turn off screen updating in Excel. Maybe you have a macro that runs a lot of code and you don't want the user to see all the flickering as the macro does its thing. Or maybe you are running some code that takes a while to finish and you don't want the user to think that Excel has frozen. In either case, turning off screen updating can make your macro run a lot faster.
There are two main ways to turn off screen updating in Excel. The first is to use the
Application.ScreenUpdating = False
You can put this line of code at the beginning of your macro to turn off screen updating. Then, when your macro is finished, you can put this line of code at the end:
Application.ScreenUpdating = True
This will turn screen updating back on so that the user can see what's going on again.
The other way to turn off screen updating is to use the
Application.DisplayAlerts = False
This will not only turn off screen updating, but it will also prevent any alerts or messages from popping up. So if your macro is going to do something that might cause an alert (like deleting a sheet), then using
DisplayAlerts is a good idea.