Supress message window

V

Varun

Guys,

I'd like to disable the information window that pops up when a sheet is
deleted. The code below I thought would accomplish that but for some reason
it does not. Any help would be appreciated. The sheet name is "Temp" and it
does have cells with numbers, etc. How to delete this sheet and suppress the
delete message?

Thanks.

Application.EnableEvents = False

On Error Resume Next

Sheets("Temp").Delete

Application.EnableEvents = True
 
M

Mike H

Hi,

Application.displayalerts=false

delete your sheet

Application.displayalerts=True

Mike
 
Top