Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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


--
frustrated
------------------------------------------------------------------------
frustrated's Profile: http://www.excelforum.com/member.php...o&userid=27778
View this thread: http://www.excelforum.com/showthread...hreadid=494117

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 184
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 184
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Running macros automatically


Thanks for the help


--
frustrated
------------------------------------------------------------------------
frustrated's Profile: http://www.excelforum.com/member.php...o&userid=27778
View this thread: http://www.excelforum.com/showthread...hreadid=494117

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Running macros automatically-AutoFit Cindy B Excel Worksheet Functions 1 January 16th 06 06:26 AM
HELP - Running Macros in VBA Louise New Users to Excel 7 April 6th 05 03:21 PM
Running Macros Steve Excel Programming 5 September 21st 04 02:54 PM
Automatically running macros Jonathan Vickers Excel Programming 1 February 24th 04 12:43 AM
HELP: Running two Macros, one before the other Bobbak Excel Programming 4 December 9th 03 01:27 PM


All times are GMT +1. The time now is 05:51 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"