Frenda,
In addition to the other comments about this, you don't have to select
sheets or cells to copy, move, or otherwise work on cells.
Worksheets("Sheet1").Range("A1") = Worksheets("Sheet2").Range ("D5")
This would work regardless of the currently selected sheet. It's still
faster do turn off screen updating, as Chip said.
--
Earl Kiosterud
www.smokeylake.com
"frendabrenda1" wrote in message
...
Good afternoon!
I have a macro that refers to multiple sheets. As it goes along in the
process, the sheets flash on the screen. This has caused some of the
users
discomfort. Is there a way to show only 1 sheet (user interface) or a
blank
screen or a progress bar or hourglass or something so the flashing will
not
occur.
Thank you for any help.