Save routine message or progress indicator

[stevespaulding]

I have a Save routine macro in a ‘large’ workbook that takes a lot of time to complete (i.e. execution of the Save As statement(s) takes a lot of time).<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
I would like to indicate to the user that the save is in progress and to please wait for it to complete. I already use the Status Bar = “Processing (saving) . . . PLEASE WAIT”, but the Status Bar is not very conspicuous (rather small and at very bottom of screen).<o></o>
<o> </o>
1. Is there a way to change the format (size, color, blink, etc) of the Status Bar?<o></o>
2. Is it possible to display a message box while the save is actually taking place?<o></o>
3. Is it possible to display a progress indicator while the save is actually taking place?<o></o>
4. Any other workarounds or suggestions?<o></o>
<o> </o>
Just looking for a good way to let the user know that something IS happening and to just wait.<o></o>
<o> </o>
As always, any help/suggestions are appreciated!!<o></o>
--Steve<o></o>
<o> </o>

 

[Diablo II]

yes on progress indicator , you can all so make the mouse turn in to the hour glass. do a serch on progress indicator , their are some posts on here. for that.

 

[Smitty]

Do a board search for "Progress Indicator".

Or do a Google search for "Excel Progress Bar".

HTH,

 

[stevespaulding]

Smitty/Diablo II:

Are you certain that progress bar frame indicator will move while the save statement is actually being executed?

Also, how do I know that save has been completed so that I unload the 'userform progress indicator dialog box'?

--Steve

 

[Smitty]

You can call the Progress Indicator in the Before_Save event. It will unload itself depending on how long you set it.