View Single Post
  #4   Report Post  
Dave Peterson
 
Posts: n/a
Default

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