stop macro from flashing sheets

[Guest]

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.

 

[Don Guillett]

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

 

[Chip Pearson]

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

in message
news:[email protected]...

 

[Earl Kiosterud]

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.