Using macros updates on Excel Workbook

[zamit]

I am new to using macros on excel workbooks.
I am using Analyzer to down load Stock prices on a daily basis and
Momentum indicators to analize the stocks.
Using Tools, I am able to down load prices.
However the indicator macros that are posted on every worksheet I have
to run manualy on each worksheet.
What do I have to do in order for the indicators to automaticly be
updated, once new stock prices are being loaded ?

Amit

 

[Tom Ogilvy]

Possibly using events. See Chip Pearson's overview of events

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

possibly the Worksheet_change event - but it would depend on what you want
to trigger the macro.

 

[zamit]

Thanks,
I shall try it

Amit