MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Supress Pop Up Box

Posted by Wayne Satterfield on July 02, 2001 2:18 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 not occur?


Posted by faster on July 02, 2001 4:14 PM

Sub KillAlerts()
Application.DisplayAlerts = False
'but you should turn them back on after the
'point of popup
Application.DisplayAlerts = True
End Sub