View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_5_] Dave Peterson[_5_] is offline
external usenet poster
 
Posts: 1,758
Default closing active windows without saving changes

It looks like you're mixing excel and word.

If you want to close a workbook, you could use:

activeworkbook.close savechanges:=false

And
application.cutcopymode = false

should stop the clipboard message.

Tony wrote:

Hi,
Im working with Excel 2003. This line is supposed to allow
me to close an active window without being asked to save
any changes:

ActiveWindow.Close SaveChanges:=wdDoNotSaveChange

It does not work. Any ideas on what does work?

Also, how can I prvent the message about saving the
clipboard from being displayed?


--

Dave Peterson