stop macro from flashing sheets
 

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.

as usual, POST your code snippet for comments and suggestions. Probably you
need to quit selecting and/or suppress screen updating.

--
Don Guillett
SalesAid Software

"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.

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.

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.