Cursor remains as a hourglass after the macro has run

Darril

New Member
Joined
Nov 15, 2005
Messages
10
Clicking a command button causes a macro to run.
Once the macro has completed, my cursor remains as a hourglass whilst still positioned over the button. If I move the cursor off the Button, it reverts to its default shape. I want the hourglass cursor to change after the macro has completed without having to move the mouse.

I inserted the following code at the end of the macro:

Application.Cursor = xlDefault

but this did not make a difference. With the cursor as an hourglass, the user thinks the macro is still running.
 
it's good you emailed again
this reply was "lost" in another thread

recieved your workbook:

missing libraries
Microsoft Flexgrid Control 6.0 (SP3)
Microsoft Grid Control

in fact the hourglass is changing when you move the mouse, you don't need to get off the button
while hourglass visible:
type in cell possible
escape not working

commandbutton
mousepointer = default
takefocusonclick was true: even setting to false same symptoms

workaround
Code:
CommandButton2.MousePointer = 0

now checking where the mousepointer would be changed in your code ........

10 minutes later ...
now I cannot replicate the problem anymore
even when deleting the line I added to "work around"

for further information
I cannot close your file without getting Excel to crash
perhaps your workbook is corrupt: so it could be time to rebuild
take a look at the thread REBUILD your workbook
 
Upvote 0

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

Forum statistics

Threads
1,215,066
Messages
6,122,948
Members
449,095
Latest member
nmaske

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top