hourglass remains after macro runs???
Hi Elizabeth,
If you look at the exchange between Jim amd me, you will see that, as result
of your posts and Jim's experience, I have decided to change the cursor in
such situations.
Jim has provided appopriate code to achieve this.
If there are any residual problems, please post back.
---
Regards,
Norman
"Elizabeth" wrote in message
...
Norman:
THANK YOU!!!
I thought my problem was the macro was in some kind of inefficient loop.
It
never occured to me that it was just the cursor's appearance, or even that
the cursor's appearance can be changed. I added "Application.Cursor =
xlNorthwestArrow" before, & "Application.Cursor = xlDefault" after the
msgbox
line & it now works flawlessly. Thanks again!
Elizabeth
"Norman Jones" wrote:
Hi Elizabeth,
Running your procedure from Excel (either via Alt-F8 or from a
rectangle,
to simulate your scenario), I get the hourglass, indicating that the
macro
is waiting for user response. Running the macro manually from the VBE, I
get
the arrow cursor.
If you find this disconcerting, you could specify the cursor form.
I guess that, in analagous situations, the curssor form has never
adversely
impinged for me.
---
Regards,
Norman
|