+ Reply to Thread
Results 1 to 3 of 3

Using macros updates on Excel Workbook

  1. #1

    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


  2. #2
    Tom Ogilvy
    Guest

    Re: Using macros updates on Excel Workbook

    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
    >




  3. #3

    Re: Using macros updates on Excel Workbook

    Thanks,
    I shall try it

    Amit


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1