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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copy text and logo from protected, hidden sheet 1
Application.EnableEvents = False not working 2
If statement works here, case doesn't 1
preventing comboboxes from triggering when sheet copied 1
Sheets that mirror each other.... 2
Addin not allowing thisworkbook.save in before save event 3
XL2002 - Sheet event BEFORE deactivating. 2
Worksheet_Change vs Worksheet_Calculate 2

Top