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

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

Ron

Many thanks for your speedy reply problem solved

Paul

"Ron de Bruin" wrote in message
...
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