Automatically select "No" when a alert window pops up.

I have a code where I'm copying information from one spreadsheet to another. When I close the one spreadsheet, an alert window pops up asking if I want to save the copied information on the clipboard. The default answer is "Yes", but I don't want to, so I don't think ThisWorkbook.Close SaveChanges:=False will work. Is there a different code to answer this pop up "no"?

ThisWorkbook.Close (False) should work, but that is the same as the one you suggested. Have you tried using it to verify?

I did, and it still popped up that alert window.

Try putting

Please Login or Register  to view this content.

before that command. After this, remember to set it back to True.

Just clear the copy buffer...

Please Login or Register  to view this content.

Should prevent the pop-up altogether.

Clearing the buffer before I closed it worked... Thanks cytop. I figured it was something simple like that.