MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Kill Warning Message

Posted by Sandro on January 22, 2002 10:49 AM

I'm writing a macro to delete a sheet on exit. When the program executes, I get the warning "The selected sheets will be permanently deleted". I would like to get rid of this message.

Posted by Michael on January 22, 2002 10:58 AM

at the beginning of you macro:

DisplayAlerts = False

Posted by Tom Urtis on January 22, 2002 11:00 AM

Yes, and be sure to set it back to True at the end of the code, before End Sub.

Posted by Joe Was on January 22, 2002 11:04 AM

Application.ScreenUpdating = False
Application.DisplayAlerts = False

Your code...

Application.ScreenUpdating = True
Application.DisplayAlerts = True
End Sub

Put this in your code. JSW