MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Supress Pop Up Box

Posted by Wayne Satterfield on July 02, 2001 2:17 PM

I am running a macro to open a .txt file.
When I close the .txt file using the macro,
I get a pop up that asks if I want to save a large
amount of data to the clip board or discard.

How can I automatically answer "NO' or not have
the pop up occur?


Posted by Damon Ostrander on July 02, 2001 7:11 PM

Hi Wayne,

I believe that if you set the CutCopyMode to False prior to closing the file, the prompt will not occur. Here's the code:

Application.CutCopyMode = False