Hi,

You can use Application.Status e.g.:

Application.Status = "Please wait .. working ... "


--
Best regards,
Peter Jaušovec
http://blog.jausovec.net
http://office.jausovec.net


"Ant" wrote:

I have a macro which takes about one minute to run and switches around
between sheets etc. I was wondering if it is possible for a status bar or
status page to appear on the screen whilst the macro runs in the background.
It's just a visual thing but I think it would appear a lot more tidy for the
user.

Is this possible?