Use this

Application.ScreenUpdating = False
'your code
Application.ScreenUpdating = True



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Paul" wrote in message ...
Hi

I remember a long time ago being able to turn of screen changes when Macro's are running between different work books in an Excel
sheet.Can anybody remind me.

Thanks Paul