auto run macro

[Aaron Russell]

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.

 

[Don Guillett]

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