Thank you Tom
Paul

"Tom Ogilvy" wrote in message
...
use application.Ontime

see Chip Pearson Site
http://www.cpearson.com/excel/ontime.htm

--
Regards,
Tom Ogilvy

"Paul" wrote in message
...
Hello All
I have an excel spreadsheet linked to remote sources and auto updating
itself. I use it for display purposes. Production numbers mostly. Anyway
it
works good except for one thing. It just seems to shut itself off after
about 10 or 11 hours. I haven't actually caught it happening but there's
no
message, or error displayed. I just find windows back at the desktop.
Excel
is closed. It's not in the taskbar. My code is pretty straight forward.
Do,
mycode, wait 2 secs, loop. I would like this display to run 24/7. I
thought
maybe I had a stack error but usually you get a message for that. I'm not
sure what to look for. Any help would be much appreciated.
I hope this all makes sense.
Any ideas?
Paul