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

Unprotect sheet when Saving As 2
Application.EnableEvents = False not working 2
Change report firlds in pivot tables and charts with one selection 0
Addin not allowing thisworkbook.save in before save event 3
If statement works here, case doesn't 1
Run macro on all files in a specific folder 3
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
VBA for Dependents shortcut menu 0

Top