Activewindow.close - remove prompt that user sees 2

[LisaBee]

When I use ActiveWindow.Close in an Excel macro, I don't want the user to receive the prompt "do you want to save changes? yes, no, cancel" -- What is the correct syntax to automatically select "no" without the user ever seeing the prompt. I apologize in advance as I'm sure this is something so simple, but I've been searching for days (and I admit that I'm not sure about how to use the VBA help in Excel to locate this)!

Thanks very much!

 

[PHV]

Set the Saved property of the workbokk before:
ActiveWorkbook.Saved = True

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[dgillz]

ActiveWindow.Close (False)

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[LisaBee]

activewindow.close (false) was exactly what I was looking for -- works perfectly! Thanks so very much,