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

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.

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

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.

---
Regards,
Norman



"esgu" wrote in message
...
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.