This will do what you want:
http://support.microsoft.com/kb/148209


Regards,
Ryan---


"Roger on Excel" wrote:

I would like a temporary message box to appear momentarily when a macro is
activated.

The macro typically takes 10 seconds or more to run and at the start i would
like a box to pop up saying "calculation in progress" for a few seconds and
then disappear without the need to press a button.

Can anyone help?

Thanks, Roger