hourglass remains after macro runs???
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
|