View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Tjia John Tjia is offline
external usenet poster
 
Posts: 32
Default Closing the save changes box

This closes the workbook and discards any changes

Thisworkbook.close saveChanges:=False


CrazySultana wrote in message ...
Hello :)

I have written a macro that opens up a file (1), changes a few things and copies the data to an already open file.
The macro then proceeds to close file 1, and the save changes dialogue box pops up. How can I make my code automatically select no or prevent that box from popping up?

Thanks for any help