Possibly by setting

ThisWorkbook.Saved = True

Before Excel attempts to close the file.

--
Regards,
Tom Ogilvy

"Neil Bhandar" wrote in message
...
Hello,

I have a auto_close routine that intercepts the file save routine but when
the routine ends I still see the file save Yes, No Cancel dialog.

sub auto_close()


end sub

How do I disable this and continue?

Thanks in advance,
-Neil