MrExcel.com - Your One Stop for Excel Tips & Solutions

Set Warning Off

Posted by Thomas Venn on March 23, 2000 9:57 AM

Hi, I wrote a macro where it would take data from one sheet, then copy it to another sheet, then go back to the original sheet and delete that sheet. However, when I delete a sheet, it give me a warning message asking me if I am sure that I want to delete that sheet. Is there anyway to turn this warnig off, and allow the macro to run without being interrupted by the warning message? thanks,

Thomas

Posted by Tom Morales on March 23, 2000 11:16 AM

Thomas -
Add the following line to your code:

Application.DisplayAlerts = False

Tom

Posted by Thomas Venn on March 23, 2000 2:05 PM

Thanks!!!!!