Look at Chip Pearson's page on using OnTime

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

--
Regards,
Tom Ogilvy

"choice" wrote in message
...
i have "savedata" that saves every 1 minute.
how would i go about stopping this macro if i need to do something else,
then restart it when i am done?
thanks in advance