auto run macro

's Computer Specifications

can someone give me the logic for a macro to automatically run when a
workbook is open. I just want the workbook to do a calculation every
second.

's Computer Specifications

Look in vba HELP index for ONTIME. Then place in the auto_open or
workbook_open events in the ThisWorkbook module

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"Aaron Russell" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> can someone give me the logic for a macro to automatically run when a
> workbook is open. I just want the workbook to do a calculation every
> second.
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sub Macro vrs Function Macro Auto Start	=?Utf-8?B?UGF0?=	Microsoft Excel Misc	7	6th Jun 2007 09:53 PM
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort	=?Utf-8?B?R2F2aW4=?=	Microsoft Excel Worksheet Functions	0	17th May 2007 01:20 PM
Auto-run macro after auto-query refresh (Excel2000,sr1)	=?Utf-8?B?QmlsbCBDdWZmbGlu?=	Microsoft Excel Programming	3	29th Jun 2006 03:30 AM
Re: how do i set up an auto-start/auto end macro	Frank Kabel	Microsoft Excel Worksheet Functions	0	9th Sep 2004 10:30 PM
macro visibility in auto loaded macro sheets?	=?Utf-8?B?Z2hvc3RXb2xm?=	Microsoft Excel Misc	1	29th Jun 2004 08:36 AM