hourglass remains after macro runs???
Elizabeth,
I have never been much concerned with windows vs. application
cursor differences.
However, I changed the default cursor using Control panel and
discovered that Excel still used its own cursors for the spreadsheet,
but that the new cursor was used for the area immediately outside of
the spreadsheet area.
That makes sense to me, as being able to change the cursors
used on the spreadsheet could only lead to much user confusion.
When using a Userform, or an active x control, Excel offers a wider
selection of cursors to choose from.
Regards,
Jim Cone
San Francisco, USA
"Elizabeth" wrote in message
...
Jim:
Thank you for your response. I like your version better than mine - 1 less
line of code.
After Norman suggested changing the cursor form, I looked "cursor" up in VBE
Help. From the choices, I selected the xlNorthwestArrow since the tester & I
were expecting to see an arrow instead of an hourglass. I then reset the
cursor to the default since VBE Help said to do so.
What I haven't been able to figure out (after researching VBE Help, Google,
the Microsoft website, & my 3 ref books) is the following:
1) What does the "default" cursor mean? I can't find an option in Excel to
change the appearance of the cursor. Is it referring to the user's selection
in Control Panel | ... | Mouse | Pointers tab | Customize?
2) If that is the case, why does "Application.Cursor" work in an Excel macro
when Application (per VBE Help) refers to the Excel application, but the
Control Panel isn't the Excel application? Have I totally misunderstood VBA
basics?
Thank you for any clarification you can provide.
Elizabeth
|