MousePointer
 

I have an excel application with some VB. When I press a commandbutton on a
spreadsheet, my application starts performing some action and goes on for a
minute or so. During this time, I would like to force the mouse icon to
display the "busy" icon (the hourglass figure). Once the calculation is
over, I would like to change it back to the default.

Google-ing over the past posts gave me how to acieve this for a button or a
form, but not for the whole application.


--
- Mangesh
------------------------------------------
Office 2003 & Windows XP

MousePointer
 

Found the solution:

Application.Cursor = xlWait

and

Application.Cursor = xlDefault


Mangesh




"Mangesh Yadav" wrote in message
...
I have an excel application with some VB. When I press a commandbutton on
a
spreadsheet, my application starts performing some action and goes on for
a
minute or so. During this time, I would like to force the mouse icon to
display the "busy" icon (the hourglass figure). Once the calculation is
over, I would like to change it back to the default.

Google-ing over the past posts gave me how to acieve this for a button or
a
form, but not for the whole application.


--
- Mangesh
------------------------------------------
Office 2003 & Windows XP