Activeworkbook.Close SaveChanges:=False

or set it to True based on your preference.

--
Regards,
Tom Ogilvy

"PaulOakley" wrote
in message ...

Hello,

I am trying to turn off the saving msg box that flashes up whenever a
document is closed, i am currently running a macro that opens many
different files, but when they are closed back down i have to press no
to the saving options.

Anyway i can stop this?

Thanks in advance,

Have a good day


--
PaulOakley
------------------------------------------------------------------------
PaulOakley's Profile:
http://www.excelforum.com/member.php...o&userid=25103
View this thread: http://www.excelforum.com/showthread...hreadid=390144