Chris, in your main procedure disable the Screen updating..as below

Sub Macro()
application.ScreenUpdating = False

' your code

application.ScreenUpdating = True
End Sub
--
If this post helps click Yes
---------------
Jacob Skaria


"Chris Stammers" wrote:

Hello,

I have some macros written in VB Script that opens 2 different workbooks,
selects cells from one and pastes/special/values to the other. There are
multiple tabs in the destination files. There are 4 different macros in the
project with each set to call the next one. The script works fine however you
can see it flicking between each sheet as it is copying and pasting. Is there
a piece of code that will hide this? I am using Excel 2003.

Many thanks.
Chris