Hey Chuck,

Merry Christmas/Happy New Year...

You can use the following to calm the screen display:

Application.ScreenUpdating = False

then before exiting your sub use:

Application.ScreenUpdating = True

Be aware that showing a message box while ScreenUpdating is turned off may
confuse your users if they move/drag the message box.

Regards,
Jim Cone
San Francisco, CA
D582

"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