Is it possible for me to me to add a progress bar to the bottom of a document
so that the users can see how much longer a macro will take?

I don't want to insert a progressbar object onto the sheet, I just want to
use a progress bar like the one that is displayed when you open or close a
workbook.

Can I use that progressbar?

~Jenny

Hi
try:
http://www.enhanceddatasystems.com/E...rogressBar.htm
http://www.cpearson.com/excel/Progress.htm
http://j-walk.com/ss/excel/files/developer.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"Jenny" schrieb im Newsbeitrag
...
Is it possible for me to me to add a progress bar to the bottom of a
document
so that the users can see how much longer a macro will take?

I don't want to insert a progressbar object onto the sheet, I just
want to
use a progress bar like the one that is displayed when you open or
close a
workbook.

Can I use that progressbar?

~Jenny

This isn't what I need. I can't have another form with a progress bar on it.
I need to know if I can simply access the progress bar built into the status
bar of the Excel object. It is that little blue progressbar that displays
when you open a workbook. Can I access that progressbar?

Jenny

"Frank Kabel" wrote:

Hi
try:
http://www.enhanceddatasystems.com/E...rogressBar.htm
http://www.cpearson.com/excel/Progress.htm
http://j-walk.com/ss/excel/files/developer.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"Jenny" schrieb im Newsbeitrag
...
Is it possible for me to me to add a progress bar to the bottom of a
document
so that the users can see how much longer a macro will take?

I don't want to insert a progressbar object onto the sheet, I just
want to
use a progress bar like the one that is displayed when you open or
close a
workbook.

Can I use that progressbar?

~Jenny

That's available in the third link that Frank provided:

'Control the LED Display in the StatusBar '

--
Regards

Juan Pablo González

"Jenny" wrote in message
...
This isn't what I need. I can't have another form with a progress bar on
it.
I need to know if I can simply access the progress bar built into the
status
bar of the Excel object. It is that little blue progressbar that displays
when you open a workbook. Can I access that progressbar?

Jenny

"Frank Kabel" wrote:

Hi
try:
http://www.enhanceddatasystems.com/E...rogressBar.htm
http://www.cpearson.com/excel/Progress.htm
http://j-walk.com/ss/excel/files/developer.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"Jenny" schrieb im Newsbeitrag
...
Is it possible for me to me to add a progress bar to the bottom of a
document
so that the users can see how much longer a macro will take?

I don't want to insert a progressbar object onto the sheet, I just
want to
use a progress bar like the one that is displayed when you open or
close a
workbook.

Can I use that progressbar?

~Jenny

I have examples on my website.

Commandbar or Statusbar


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Jenny" wrote in message
...
This isn't what I need. I can't have another form with a progress bar on
it.
I need to know if I can simply access the progress bar built into the
status
bar of the Excel object. It is that little blue progressbar that displays
when you open a workbook. Can I access that progressbar?

Jenny

"Frank Kabel" wrote:

Hi
try:
http://www.enhanceddatasystems.com/E...rogressBar.htm
http://www.cpearson.com/excel/Progress.htm
http://j-walk.com/ss/excel/files/developer.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"Jenny" schrieb im Newsbeitrag
...
Is it possible for me to me to add a progress bar to the bottom of a
document
so that the users can see how much longer a macro will take?

I don't want to insert a progressbar object onto the sheet, I just
want to
use a progress bar like the one that is displayed when you open or
close a
workbook.

Can I use that progressbar?

~Jenny

"Juan Pablo González" wrote ...

That's available in the third link that Frank provided:

'Control the LED Display in the StatusBar '

For a simpler version, see Usenet archive:

http://groups.google.com/groups?selm...GP12.phx.gb l

Jamie.

--