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.