Help hiding macro work
 

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

Help hiding macro work
 

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