Use

Application.ScreenUpdating = False

to prevent Excel from updating the display while your code is
running. This will also cause your code to run faster.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.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.