| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Earn when you sleep | New Users to Excel | |||
| sendkeys(keys,wait) how do I use wait | Excel Discussion (Misc queries) | |||
| Calculating Sleep | New Users to Excel | |||
| Baby Sleep log | Charts and Charting in Excel | |||
| Web Query Sleep for until results come | Excel Worksheet Functions | |||
Linear Mode
