You can read about the scheduling procedures at Chip Pearson's site:
http://www.cpearson.com/excel/ontime.htm
You could schedule a macro that just recalculates (over and over and ...)
(I, too, wouldn't do this. But good luck if you do!)
JENNYC wrote:
Hi! DOes anyone know how...if it is even possible... to display the
CURRENT time in a worksheet automatically? I am using the "now"
function, but in "help" it says the time will not update unless "the
worksheet is calculated" or when a macro is run. I need to be able to
just have this page up throughout the afternoon and have an alert
message pop up 15 minutes before a "promised completion time" without
having to do anything in the workbook. Is this possible? Any feedback
is greatly appreciated!! thank you!
--
JENNYC
------------------------------------------------------------------------
JENNYC's Profile: http://www.excelforum.com/member.php...o&userid=19579
View this thread: http://www.excelforum.com/showthread...hreadid=391063
--
Dave Peterson