Sleep, Wait and Busy cursor functionality

S

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
 
C

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
 
S

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
 
C

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
 
Top