Application.ScreenUpdating=false
will stop this anoying flickering
--
Best regards
Luc Nuyts
www.scriptingIT.be


" wrote:

Hello, not sure if this is possible but can anyone help please?

I've got a macro which, amongst other things, opens various files to
retrieve data for processing. It opens these files in turn and gets
the data it needs etc before closing them again, using the following
commands:

Workbooks.OpenText
' Do some processing
ActiveWorkbook.Close

It works OK but the screen flickers madly for a few seconds during
this time and I'm worried I might get epilepsy - not really, but it
does look really bad.

Is it possible to process these files another way without them being
displayed to avoid the flickering? I don't need them to be displayed,
they are only there for a split second anyway.

Thanks.