Application.ScreenUpdating = False

Nifty macro code

Application.ScreenUpdating = True

However, it would be better to design your code so it doesn't do selecting
and activating so you would not have this problem.

--
Regards,
Tom Ogilvy

CLR wrote in message
...
Hi All......

With you fine folks help, I've managed to put together a nifty macro that
does what I want it to do. The only thing now is, during it's executon
the
macro jumps back and forth between screens and this causes each one to
flash
up on the monitor and I would prefer that they not do that.........any way
to "turn off the display at the beginning of the macro and turn it back on
again at the end"......??......or better yet, to put up some "Please wait"
message during processing.......

TIA
Vaya con Dios,
Chuck, CABGx3