Auto refresh every 5 seconds in Excel

Hi,

I would like to have a help in programming the code for Auto refresh every 5 seconds or so in the excel sheet attached.

The file is Downloaded from one of the sites.
Need to modify with adding a code of auto refreshing every 5 seconds instead of default 1 minutes.

Thanks
Pritz

Check this site ... there is explained onTime events

http://www.cpearson.com/excel/OnTime.aspx

I hope it helps you

Best Regards