View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Varun Varun is offline
external usenet poster
 
Posts: 37
Default Supress message window

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