Application.Cutcopymode = False
ActiveWindow.Close SaveChanges:=True

or make it false if you don't want to save changes).

--
Regards,
Tom Ogilvy


"raraujo" wrote in message
...
Gentlemen,


Is there any VBA command that avoid the Message " Do you want
save...... YES NO CANCEL" when I am using the command"
ActiveWindow.Close. This message make my macro be interrupted.


Similar is the message that appear when do a copy and I close the file,
" There is a large amount of information on Clipboard......".
I want to avoid this kind of message.

Thanks

Rubens



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/