View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brian Matlack[_54_] Brian Matlack[_54_] is offline
external usenet poster
 
Posts: 1
Default Close without saving


Hi!
I have two workbooks open in the same application. I want to close one
without saving it. I use this code but it still asks me if I want to
save changes.

<Code start
ActiveWindow.ActivateNext
ActiveWorkbook.Saved = False
ActiveWorkbook.Close
<End Code

Can I use code that will close without saving and not ask if I want to
save changes?
Thanks!!


--
Brian Matlack
------------------------------------------------------------------------
Brian Matlack's Profile: http://www.excelforum.com/member.php...fo&userid=3508
View this thread: http://www.excelforum.com/showthread...hreadid=510128