Sleep, Wait and Busy cursor functionality

[Sudarshan]

Hi,

I want to sleep my Excel for certain seconds ( I did this
using Sleep API's) Now during sleep, I want to show the
Busy cursor to user, so that user should not update any
thing in Excel... How to show Busy cursor to user in Excel
VBA...

Thanks in Advance..

Sudarshan

 

[Chip Pearson]

Sudarshan,

Try something like the following:


Application.Cursor = xlWait
' sleep
Application.Cursor = xlDefault


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Sudarshan]

Hi,

Thanks for Quick reply... This way we can show the busy
cursor to user... but how do we prevent user to do changes
in Workbook.

Thanks

Sudarshan

 

[Chip Pearson]

The user cannot work cannot do anything while Sleep is running.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Guest]

Thanks,

News group is really great..

-----Original Message-----
The user cannot work cannot do anything while Sleep is running.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com





.