Thanks Peter but I was actually wanting to know if there is something that
appears on screen that completely hides the macro that is working in the
background. Perhaps some code which keeps "Sheet1" only visible whilst the
macro is working on other sheets. It is so the users can not see the macro
physically working.
Does that make sense?
"Peter Jausovec" wrote:
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?