Hello,

Try using DoEvents inside your code to instruct Excel to execute other
tasks while running your code.

I hope this helps.

Regards,
Karim

arno wrote:
Hi,

just a few thoughts:

you should turn off screenupdating as this will speed up your code.
From time to time, eg. when the statusbar changes, you can turn on
screenupdating and then immediately turn it off again so that you can
see what is going on. I dont know if this will also solve your problem
when switching back to excel from another application.

arno