Timer
 

Hi, I would like a snippet of code that runs in the
background when a sheet is opened and every 20 seconds
performs a small bit of code in a sub module....

Can anyone assist ?

Timer
 

I have an example on my website "Schedule a macro to run"

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Neil" wrote in message
...
Hi, I would like a snippet of code that runs in the
background when a sheet is opened and every 20 seconds
performs a small bit of code in a sub module....

Can anyone assist ?

Timer
 

Hi
in addition to Rob's example you may have a look at:
http://www.cpearson.com/excel/ontime.htm

-----Original Message-----
Hi, I would like a snippet of code that runs in the
background when a sheet is opened and every 20 seconds
performs a small bit of code in a sub module....

Can anyone assist ?
.