Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Timed message box
Hi each and all ,
My Idea is to be able to have a msg box appear to reminder the user to perform a task, at say 10 min intervals, the user should have the option to turn this off or vary the interval between mgs box reminders, each time the msg box appears, pressing ok should close the msg box and restart the timer for the next msgbox. Thanks as always |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Timed message box
How long do you think it would be before they switched it off.
Don't think you can do it but, if you can, I think you'd lose a lot of friends ... it's called nagware Regards Trevor "LaDdIe" wrote in message ... Hi each and all , My Idea is to be able to have a msg box appear to reminder the user to perform a task, at say 10 min intervals, the user should have the option to turn this off or vary the interval between mgs box reminders, each time the msg box appears, pressing ok should close the msg box and restart the timer for the next msgbox. Thanks as always |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Timed message box
http://www.cpearson.com/excel/ontime.htm
-- Regards, Tom Ogilvy "LaDdIe" wrote in message ... Hi each and all , My Idea is to be able to have a msg box appear to reminder the user to perform a task, at say 10 min intervals, the user should have the option to turn this off or vary the interval between mgs box reminders, each time the msg box appears, pressing ok should close the msg box and restart the timer for the next msgbox. Thanks as always |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Timed message box
Thank Tom,
Also found a good proceedure in my Excel VBA for Dummies book. "Tom Ogilvy" wrote: http://www.cpearson.com/excel/ontime.htm -- Regards, Tom Ogilvy "LaDdIe" wrote in message ... Hi each and all , My Idea is to be able to have a msg box appear to reminder the user to perform a task, at say 10 min intervals, the user should have the option to turn this off or vary the interval between mgs box reminders, each time the msg box appears, pressing ok should close the msg box and restart the timer for the next msgbox. Thanks as always |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Timed message box
Tom, everything works great, except for when a worksheet is protected, any
suguestions?. "Tom Ogilvy" wrote: http://www.cpearson.com/excel/ontime.htm -- Regards, Tom Ogilvy "LaDdIe" wrote in message ... Hi each and all , My Idea is to be able to have a msg box appear to reminder the user to perform a task, at say 10 min intervals, the user should have the option to turn this off or vary the interval between mgs box reminders, each time the msg box appears, pressing ok should close the msg box and restart the timer for the next msgbox. Thanks as always |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Timed message box
The msgbox code fails when the worksheet is protected?????????
If you're doing more things, maybe you could either: Unprotect the sheet (you'll have to know the password), do the work and reprotect the sheet with the same password. or Check to see if the worksheet is protected. If it is, just give an error message and exit your procedure. LaDdIe wrote: Tom, everything works great, except for when a worksheet is protected, any suguestions?. "Tom Ogilvy" wrote: http://www.cpearson.com/excel/ontime.htm -- Regards, Tom Ogilvy "LaDdIe" wrote in message ... Hi each and all , My Idea is to be able to have a msg box appear to reminder the user to perform a task, at say 10 min intervals, the user should have the option to turn this off or vary the interval between mgs box reminders, each time the msg box appears, pressing ok should close the msg box and restart the timer for the next msgbox. Thanks as always -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Timed message box
Thank You.
"Dave Peterson" wrote: The msgbox code fails when the worksheet is protected????????? If you're doing more things, maybe you could either: Unprotect the sheet (you'll have to know the password), do the work and reprotect the sheet with the same password. or Check to see if the worksheet is protected. If it is, just give an error message and exit your procedure. LaDdIe wrote: Tom, everything works great, except for when a worksheet is protected, any suguestions?. "Tom Ogilvy" wrote: http://www.cpearson.com/excel/ontime.htm -- Regards, Tom Ogilvy "LaDdIe" wrote in message ... Hi each and all , My Idea is to be able to have a msg box appear to reminder the user to perform a task, at say 10 min intervals, the user should have the option to turn this off or vary the interval between mgs box reminders, each time the msg box appears, pressing ok should close the msg box and restart the timer for the next msgbox. Thanks as always -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Timed Message Box | Excel Discussion (Misc queries) | |||
TIMED MSGBOX | Excel Discussion (Misc queries) | |||
timed macro | Excel Worksheet Functions | |||
In Use Message | Excel Worksheet Functions | |||
changing the message in an error message | Excel Worksheet Functions |