|
Changing the cursor
Greetings !
Some of my spreadsheets take a while to calculate, so I have the facility to calculate just the selection. The routine to do that currently puts "Re-calculating, please wait..." into the StatusBar, which is then re-set when the calculation is finished. How can I also change the cursor for the duration, from the usual cross to the hour-glass, and then back again ? |
Changing the cursor
Try this
Application.Cursor = xlWait For the hourglass Application.Cursor = xlDefault To set it back to normal -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Robin Clay" wrote in message ... Greetings ! Some of my spreadsheets take a while to calculate, so I have the facility to calculate just the selection. The routine to do that currently puts "Re-calculating, please wait..." into the StatusBar, which is then re-set when the calculation is finished. How can I also change the cursor for the duration, from the usual cross to the hour-glass, and then back again ? |
| All times are GMT +1. The time now is 12:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com