Is there an easy way (programmatically or otherwise) to show that a macro is
running? The hour glass doesn't always show and simple things, like a
message box, stop the code while there showing. Also, I don't want to kill
the keyboard - just in case something unexpected happens and I need to Break.

I have this same issue in other applications. Most notably MS Project. So
a somewhat universal solution would be nice (I don't want much, do I?).

Thanks,
Will

A progress bar might be what you want. There is a nice one at
http://www.enhanceddatasystems.com/E...rogressBar.htm

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"roadkill" wrote in message
...
Is there an easy way (programmatically or otherwise) to show that a macro
is
running? The hour glass doesn't always show and simple things, like a
message box, stop the code while there showing. Also, I don't want to
kill
the keyboard - just in case something unexpected happens and I need to
Break.

I have this same issue in other applications. Most notably MS Project.
So
a somewhat universal solution would be nice (I don't want much, do I?).

Thanks,
Will

I don't need anything so elaborate, but you pointed me in the right
direction. In reviewing the code related to the progress bar, I learned
about opening a form modeless (as opposed to modal) so that code continues to
run while the form is displayed. That was all I needed. Thanks!
- Will

"Bob Phillips" wrote:

A progress bar might be what you want. There is a nice one at
http://www.enhanceddatasystems.com/E...rogressBar.htm

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"roadkill" wrote in message
...
Is there an easy way (programmatically or otherwise) to show that a macro
is
running? The hour glass doesn't always show and simple things, like a
message box, stop the code while there showing. Also, I don't want to
kill
the keyboard - just in case something unexpected happens and I need to
Break.

I have this same issue in other applications. Most notably MS Project.
So
a somewhat universal solution would be nice (I don't want much, do I?).

Thanks,
Will

You could always use an Application.StatusBar message.

Martin

http://homepage.ntlworld.com/martin.rice1/


--
mrice
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=532400

You could always use an Application.StatusBar message.

Martin

http://homepage.ntlworld.com/martin.rice1/


--
mrice
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=532400