Auto refresh

D

dalestanton

Hi,
I have built an excel spread sheet to monitor activities. In it I
use the function"NOW" and use a given time past this to give out a
warning via conditional formatting. It works fine for what I need
except for one snag! Somebody has to press F9 every five minutes.
Obviously this is a waste of time and not always done which makes the
system questionable. Anybody got any idea how I can get it to
automatically refresh/re calculate? I would be very grateful for any
advice on this one.


Regards

Dale
 
J

JMB

You could set up a macro to run every 5 minutes that recalculates the range
or sheet you want.

This would recalculate the named range MyRange every 5 minutes. You will
need to set up a way to get the ball rolling by running one of the macros
(perhaps call test2 using the WorksheetOpen event handler), or assign it to a
button.

Also, see Chip's site - especially for instructions on stopping the timer.
Since OnTime is application level - it will continue even if you close the
workbook (reopening the workbook if necessary).

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

Sub test1()
Application.OnTime Now() + TimeValue("00:05:00"), "test2"
End Sub

Sub test2()
Range("MyRange").Calculate
Call test1
End Sub
 
Top