I don't want to see what a macro is doing when it's running

[Guest]

When a makro is running, all the activities show on the screen. I know tehre
is a posibility to supress this, which has also the effect, that the macor
runs quickier.

 

[Norman Jones]

Hi Esgu,

1) Use the ScreenUpdating property:

Application.ScreenUpdating = False

'Your code

Application.ScreenUpdating = True

2) (Which should be 1)!), avoid selections.
Selections are rarely necessary and tend to make your code less
efficient and harder to maintain. Additionally, they have the unfortunate
side effect you have observed.