Dave, I don't know if your saw my reply to Peter (I don't think I explained
myself very well actually!). I was 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. In other words, I have a macro button on a front sheet
which than does a whole lot of work on various sheets within the file. It
would be nice if the front sheet remained the only visible sheet whilst the
macro performed it's operations in the background. Is this possible?


"Dave Peterson" wrote:

You could add:

option explicit
sub yoursub()
application.screenupdating = false
'your code
application.screenupdating = true
end sub

to stop the flickering.

And pepper this kind of thing where you want:

application.statusbar = "Please wait. I'm sorting data!"

and remember to reset the statusbar before your code ends:

application.statusbar = false



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?

--

Dave Peterson