Constant refresh.
Thanks Don for pointing me to that direction.
Unfortunately I couldn't find "ontime" in my VBA Help so I
did a Google search and I found a lot of example that do
no apply to me. Most examples trigger another macro at a
certain time while I would only want the spreadsheet to
refresh as long as it is active (visible).
Is this at all possible?
Thanks anyway.
-----Original Message-----
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.
.
|