Preventing screen flicker

P

Paul

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
 
R

Ron de Bruin

Use this

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