| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Supress message window
Hi,
Application.displayalerts=false delete your sheet Application.displayalerts=True Mike "Varun" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| supress message | Excel Programming | |||
| Supress Warning Message | Excel Programming | |||
| Supress error message | Excel Discussion (Misc queries) | |||
| supress activex message on open workbook | Excel Programming | |||
| supress Solver message | Excel Programming | |||
Hybrid Mode
