+ Reply to Thread
Results 1 to 4 of 4

Running macros automatically

  1. #1
    Registered User
    Join Date
    10-04-2005
    Posts
    73

    Running macros automatically

    Is it possible to get macros to run automatically everytime the document is opened?

    Is it also possible for macros to run automatically everytime something in the worksheet changes?

    Is it possible to get macros to run automatically everytime something in a specific range of cells changes?

    Is it possible for macros to run automatically every 30 seconds or one minute?

    If the answer to any of these is yes, I would like to know how its done.

    Finally if I have a lot of macros running automatically everytime say something in the worksheet changes, will everything be running slower?

    Thanks for the help

  2. #2
    Lonnie M.
    Guest

    Re: Running macros automatically

    Hi, the answer is yes--the link below should get you started:
    http://www.cpearson.com/excel/events.htm

    HTH--Lonnie M.


  3. #3
    Lonnie M.
    Guest

    Re: Running macros automatically

    >Is it possible for macros to run automatically every 30 seconds or
    >one minute?


    See the 'OnTime' function VBA help and the link below should help:
    http://groups.google.com/group/micro...=ontime&qt_g=1

    HTH--Lonnie M.


  4. #4
    Registered User
    Join Date
    10-04-2005
    Posts
    73
    Thanks for the help

+ 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