Stewart,

You can use the Status Bar (at the bottom of the screen)

Put
Application.StatusBar = "Your message"
at the start of your code, and
Application.StatusBar = False
at the end.

You can also have any number of the messages spread thru your code
to indicate where the code is at.

Additionally - you can set up a timer function to show elapsed time,
remaining time, or what ever in the message.

--
sb
"Stewart Walker" wrote in message
...
How can I show a 'busy message' whilst a macro still runs
in the background?

Thank you for any help you can give.

Stewart