Display a busy window while processing
 

I have written a set of macros to open a number of
spreadsheets to perform various finance consolidation.
This takes from 5 - 20 minutes depending on the when it is
run. I notice when the user move the mouse away from my
form, the busy cursor dispear giving the impression to
users it is complete.

Can someone tell me what kind of system call to write
such that I can have a proc to display a Busy window and
continue to let may main process proc to do the work.
when the proces is complete, it automatically close the
window. ? If there is a sample or existing code I can
use, that's even better.

Any suggestions are appreciated.

Regards

Display a busy window while processing
 

Mohair,
Check out the PRogress Indicator at
http://www.j-walk.com/ss/excel/files/developer.htm
Alex@JPCS



"Mohair" wrote in message
...
I have written a set of macros to open a number of
spreadsheets to perform various finance consolidation.
This takes from 5 - 20 minutes depending on the when it is
run. I notice when the user move the mouse away from my
form, the busy cursor dispear giving the impression to
users it is complete.

Can someone tell me what kind of system call to write
such that I can have a proc to display a Busy window and
continue to let may main process proc to do the work.
when the proces is complete, it automatically close the
window. ? If there is a sample or existing code I can
use, that's even better.

Any suggestions are appreciated.

Regards