Macro Problem with calls

[Sandip Patel]

Hello,

I have problem in which I would like to keep a worksheet
open all of the time and have a macro check what is in the
sheet every few minutes. Is there some kind of call
function to have excel execute the macro every few minutes
infinitely? Any suggestions would be greatly appreciated.

Thanks, SP

 

[Kim Mitchell]

You can probably do it with vba and the timer control.

Kim

 

[Dave Peterson]

Take a look at Chip Pearson's notes:

http://www.cpearson.com/excel/ontime.htm