You don't seem to understand that a progress bar does not run. You have to
have code within your code that progresses the bar. (A progress bar is no
more sophisticated than a text box.) You can't do that for a single
command.

--
Regards,
Tom Ogilvy


"Craig" wrote in message
news:AWisf.209236$Gd6.33533@pd7tw3no...
The size of the file is allways about the same... is it possible to use a
progressbar that takes 20 seconds to run while the workbook is saving?
This
would be fairly close to the time needed.

"Leith Ross"
wrote
in message ...

Hello Craig,

Since you don't control the save process, it is impossible to know
which block of n blocks total has been saved. You might want to display
a animation instead. This at least let's the user know the computer is
processing and not hung up (not entirely true I know). Just a
suggestion.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile:
http://www.excelforum.com/member.php...o&userid=18465
View this thread:
http://www.excelforum.com/showthread...hreadid=496253