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