Using macros updates on Excel Workbook

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

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.

--
regards,
Tom Ogilvy


<[email protected]> wrote in message
news:[email protected]...
> 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
>

Thanks,
I shall try it

Amit