Hi JustaGuyFromKY"

Top your code with the line:

Application.Screenupdating = False

and tail it with the converse line:

Application.Screenupdating = True

You can normally reduce/eliminate the flicker by removing select actions
from your code. Such selections are usually unnecessary and tend to slow
processing.


---
Regards,
Norman



"justaguyfromky" wrote in message
...
I have workbook where most of my data is entered on one sheet.
When the data has been entered, I press a macro button that copies and
pastes the values of the cells into other parts of the workbook. Is there
a
way that when the macro is run, you can hide all the sheets from flashing
on
the screen while completing the tasks?

Thanks