View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Neil[_11_] Neil[_11_] is offline
external usenet poster
 
Posts: 43
Default auto run a macro

Chong/Garima

Have a look at Chip Pearsons's Ontime page
http://www.cpearson.com/excel/ontime.htm

Neil

"Chong Moua" wrote in message
...
Hi Garima,

I don't know of an easy way to set macros to run every
five minutes. What could work is to use the events
feature. Everytime a particular cell or sheet changes
then the macro runs.

Hope this helps...

Chong Moua

-----Original Message-----
Hi,

I want to run a macro inMS excel, in specific time
intervals automatically. I need to update my data and
calculations in every five minutes for that I am using
formulas and macros.

Will it be possible to run a macro automaically, like

auto
refresh facility in MS excel.

Thanks

Garima
.