[Excel VBA] Execute macro processing without displaying it on the screen

When you try to run a macro, you will see the macro’s movements on the screen.

If you want to make it appear as if it is running in the background, you may want to hide the processing scenery.

For example, if you’re working with files that are normally hidden, or if you’re frequently moving workbooks or sheets, your screen won’t be busy and will consume resources.

In such a case, you can hide it using the code below.

Application.ScreenUpdating = False

If you want to display it in reverse

Application.ScreenUpdating = True

will do.