Jan,

You can use OnTime to do this. See www.cpearson.com/excel/ontime.htm for
example code.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Jan Kronsell" wrote in message
...
Hi NG!

I know I can use the OnTime function to make something happen at a given
time, or in a certain timeinterval, but is there anyway I can make
something
happen in recurring intervals, like once every minute as long as the
spreadsheet is open - and still be able to use the sheet.

Jan