Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need a busy macro | New Users to Excel | |||
Markers making things too busy | Charts and Charting in Excel | |||
Chart Display -- fit window or zoomable? | Excel Discussion (Misc queries) | |||
Keeping my computer busy | Excel Discussion (Misc queries) | |||
display window | Excel Discussion (Misc queries) |