G'da there Roland,

I know you can make a progress bar, but how I do not know.

That's the easy bit. I got one from one of John Walkenbach's
excellent books and have already used it in an application at work :)

I once found a website that had about 8 or 9 different ones that
were all scripted in VB. That was several years ago, and I've never
found it since.

One thing you
could do is have a msgbox appear with some text in it saying the process is
complete. Just write the code for the msgbox at the end of code you are
waiting for.

Unfortunately, I don't have access to the code in the sheets that
are doing the processing, nor do I think it would matter anyway.

I've had another look at the sheets while at work, and they're
just PivotTables whose updates are a function of changing selected
PivotField values. Those updates are then a built in function of
accessing the OLAP cube. (At least, I think that's how it works but if
anyone can correct my notions then go right ahead!!)

Anyway, I'm off to read the bits of code I DID have access to and
was able to print up. Whether I can make sense of it is entirely another
matter <g.

Thanks for your assistance Roland. I appreciate your response.

See ya
Ken McLennan
Qld, Australia