#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 131
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,089
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 27,285
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 131
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 131
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 131
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Timed Message Box FARAZ QURESHI Excel Discussion (Misc queries) 3 January 26th 07 04:13 PM
TIMED MSGBOX FARAZ QURESHI Excel Discussion (Misc queries) 6 January 3rd 07 09:24 PM
timed macro Decreenisi Excel Worksheet Functions 3 March 3rd 06 01:33 PM
In Use Message MaryAnn Excel Worksheet Functions 1 August 27th 05 08:29 PM
changing the message in an error message The Villages DA Excel Worksheet Functions 2 February 18th 05 06:30 PM


All times are GMT +1. The time now is 07:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"