have a look in vba help for ontime and use it with calculate

--
Don Guillett
SalesAid Software

"Victor H" wrote in message
...
I have a worbook with several worksheets in it.
Each worksheet represent a week, and a new worksheet is
added every week.
On the current worksheet named "05-10-04" I have values in
cells that are calculated based on what time it is.
I can get the updated by pressing F9 (recalculate).
My question is:
Can I have the worksheet recalculate the values
constantly ?(basically can I have it press F9 for me as
long as I am viewing the worksheet and not when the
worksheet is minimized ?)
Thanks in advance for any help.