Progress bar to show that the macro is running

[frayner]

Hello all,

I'm a first time poster, and so apologies if the below is a stupid question.

I have a lengthy macro which takes Excel approximately 1 minute to work through.

At present, the user can see everything that the macro is doing, which I think makes it look a little amateurish.

What I'd like to do is present a blank screen whilst the macro is running with a progress bar to show that it hasn't frozen. From looking through various posts, I realise that progress bars that go from 1 - 100 are particularly tricky to incorporate, and so I was really looking for a progress bar that would just cycle through and repeat until the end of the macro.

Does anyone know of such a thing?

Many thank in advance for your help,

Fran

 

[frayner]

Oh yeah, much quicker, with less flashing as the macro runs through.

Another thing I noticed is that you got rid of all of the:

"ActiveWindow.ScrollRow = ..."

lines. Presumably these don't really do a lot?

 

[Jonmo1]

Yep, those lines are completely unnecessary.