stop timer
 

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

stop timer
 

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