Thread: Auto answer - "Do you wish to save changes"
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
crispbd[_31_] crispbd[_31_] is offline
external usenet poster
  
Posts: 1
Default Auto answer - "Do you wish to save changes"

Application.DisplayAlerts=False
newbook.Saved=True
newbook.Close

this will close without attempting to sav

--
crispb
-----------------------------------------------------------------------
crispbd's Profile: http://www.excelforum.com/member.php...fo&userid=1088
View this thread: http://www.excelforum.com/showthread.php?threadid=31459

Reply With QuoteReply With Quote