autostart and "on" and "off" macro
 

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

autostart and "on" and "off" macro
 

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

autostart and "on" and "off" macro
 

Thanks for the reply, Tom, but this isn't exactly my intention.

Here is my current macro (which works, i suppose, but there may be a
more elegant way)...


Code:
--------------------
Public Sub Macro1()
Do Until OnOff = 0
DoEvents

autostart and "on" and "off" macro
 

If you can get macro2 to run when macro1 is running, then I suppose that is
fine. I don't see the point of calling macro1 when you have set the variable
to off.

I think the references I gave your are better, but it depends on what you
are doing and how much time macro1 takes to run and if it needs to be run as
much as you have it run.

Also, what your are doing may better be handled with events - again, I don't
know what you are doing.

--
Regards,
Tom Ogilvy


"grime" wrote:


Thanks for the reply, Tom, but this isn't exactly my intention.

Here is my current macro (which works, i suppose, but there may be a
more elegant way)...


Code:
--------------------
Public Sub Macro1()
Do Until OnOff = 0
DoEvents
.
.
.
Loop
End Sub
--------------------



Code:
--------------------
Private Sub Macro2()
If OnOff = 0 Then
OnOff = 1
Macro1
ElseIf OnOff = 1 Then
OnOff = 0
Macro1
End If
End Sub
--------------------


Is there an easier way? :confused:


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