Sleep, Wait and Busy cursor functionality
 

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

Sleep, Wait and Busy cursor functionality
 

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

Sleep, Wait and Busy cursor functionality
 

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


.

Sleep, Wait and Busy cursor functionality
 

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


.

Sleep, Wait and Busy cursor functionality
 

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


.



.