Well, maybe...
http://www.cpearson.com/excel/ontime.htm
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Carl"

wrote in message
Thanks, Jim. I was afraid this would be the case.


"Jim Thomlinson" wrote:
Nope... the best you will do is to pop a mesage for the user warning them of
the save...
if msgbox("Do you wanna save???", vbyesno) = vbyes then thisworkbook.save
HTH...
Jim Thomlinson




"Carl" wrote:
I have a macro that saves the workbook 30 minutes after opening using
"OnTime". Is there a way to stop this once it has started? I know one way is
to close and reopen the workbook and Excel but is there a way to do it
without having to close the workbook? Thanks in advance.