Application.ScreenUpdating = False

Application.StatusBar = "Working . . . "

' long code

' return status bar to excel.
Application.StatusBar = False
' turn screen updating back on.
Application.ScreenUpdating = True

Maybe that will speed it up enough you don't need to display anything.

--
Regards,
Tom Ogilvy


"SWMagic" wrote in
message ...

This is probably easy for many of you but I just don't think I've ever
done it.

While a long macro is running how to I give the user a display message
that says "Working..." and also suppress all the wild visible displays
of what's going on?

Thanks


--
SWMagic
------------------------------------------------------------------------
SWMagic's Profile:
http://www.excelforum.com/member.php...o&userid=26660
View this thread: http://www.excelforum.com/showthread...hreadid=399932