I am creating a program that replaces the source data of a chart. I have set
the program up so that it replaces one line of the source data every second.
I would like the updates to play back almost like an animation.

The program flows as follows:
Select "Sheet1", copy the new line data
Select "Sheet2", paste the new line of data.
Select "Sheet1", move to the next cell
Copy
Select "sheet2", move to the next cell
Paste
Repeat....

Every time the program selects a sheet, the sheet becomes the active window
on my screen. Is there a command that will just let me see the chart? I
would like all the copy, paste and update commands to occur in the background.

Thanks for your time