Hi
use
application.displayalerts=false
ActiveWorkbook.Close
--
Regards
Frank Kabel
Frankfurt, Germany
"okanem" schrieb im Newsbeitrag
...
I am trying to close a spreadsheet without saving any changes to it
from
within a macro, but at the moment it keeps asking me do I want to
save
changes.
The code so far is
Windows("control of contract - item 1.xls").Activate
ActiveWorkbook.Close
Can someone help.
I don't want to save before closing which would get rid of the
message
because it takes about 10 seconds to close.
Thanks for any replies
Okanem
--
okanem
---------------------------------------------------------------------
---
okanem's Profile:
http://www.excelforum.com/member.php...fo&userid=9301
View this thread:
http://www.excelforum.com/showthread...hreadid=320054