Timer

[Neil]

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 ?

 

[Rob van Gelder]

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

 

[Frank Kabel]

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