Thanks that works - but the only thing I could find that I think
is refreshing the screen is the Save function, everything else gives
me an error message.

George

"AFSSkier" wrote:

This may help you.
http://www.ozgrid.com/Excel/run-macro-on-time.htm

--

"George" wrote:

I am using a shared Excel 2007 spreadsheet on a work LAN. Is there some code
I can add to it to have it auto refresh at a preset interval.