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


"Sudarshan" wrote in
message ...
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

-----Original Message-----
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"
wrote
in
message ...
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


.



.