Good evening SWMagic

To suppress all screen activity use this line as the first in your
macro:

Application.ScreenUpdating=False

and to turn it on again use:

Application.ScreenUpdating=True

(although, technically you don't need to because screen updating will
be restored at the end of a macro when control of excel is returned to
the user).

To display any kind of message, just design a userform (from the VBE
Insert Userform) showing your message and to call it from within your
macro use this instruction:

UserForm1.Show

and to remove it use:

Unload UserForm1

HTH

DominicB


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