Timed message box

[Guest]

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

 

[Trevor Shuttleworth]

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

 

[Tom Ogilvy]

http://www.cpearson.com/excel/ontime.htm

 

[Guest]

Thank Tom,

Also found a good proceedure in my Excel VBA for Dummies book.

 

[Guest]

Tom, everything works great, except for when a worksheet is protected, any
suguestions?.

 

[Dave Peterson]

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.

 

[Guest]

Thank You.

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.