to start the macro use the workbook_Open event

http://www.cpearson.com/excel/events.htm

to repeat it use Application.Ontime
http://www.cpearson.com/excel/ontime.htm

that also includes how to stop it.

--
Regards,
Tom Ogilvy

"grime" wrote in
message ...

Hopefully an easy one for all you gurus out there... :)

I have a macro, the contents of which aren't really necessary to post
here. I want that macro to "autostart" when the workbook is opened and
continue to repeat. I also need a seperate macro to break the loop and
stop the macro, and another to restart it (from the beginning).

Any help is much appreciated.


--
grime
------------------------------------------------------------------------
grime's Profile:
http://www.excelforum.com/member.php...o&userid=19227
View this thread: http://www.excelforum.com/showthread...hreadid=546460