View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mohair Mohair is offline
external usenet poster
 
Posts: 2
Default 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