Hi Ben,

Try:

Application.ScreenUpdating = False

'Your code

Application.ScreenUpdating = True

---
Regards,
Norman



"Ben H" wrote in message
...
Hi all! I am calling different files in a macro. The macro opens the
files,
reads in some data and then closes them. The problem I have is that the
files that are opened pop up and i was wonderig if there was a way to
suppress that.
Its really annoying to have the tables flash up and then dissapper.
Thanks!