Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How-To suppress a warning dialog
Dear Experts
I am trying to delete all but one worksheetsheet named "products" in active workbook. When ever I try running the macro a Warning pops up asking All content of the sheet would be lost, do you wish to continue (or something like this) Is there a way to prevent that from poping up. Please advise I use xl2002 vba on Win 2k Thanks James |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How-To suppress a warning dialog
Hi
try application.displayalerts=false 'your code application.displayalerts=true -- Regards Frank Kabel Frankfurt, Germany James wrote: Dear Experts I am trying to delete all but one worksheetsheet named "products" in active workbook. When ever I try running the macro a Warning pops up asking All content of the sheet would be lost, do you wish to continue (or something like this) Is there a way to prevent that from poping up. Please advise I use xl2002 vba on Win 2k Thanks James |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How-To suppress a warning dialog
Insert
Application.DisplayAlerts = False before the deletes and then Application.DisplayAlerts = True after. -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Suppress dialog from regserver command | Excel Discussion (Misc queries) | |||
how to suppress office assistance dialog | Excel Discussion (Misc queries) | |||
Macro Help - Suppress warning box | Excel Programming | |||
Suppress dialog while opening a write protected Excel document from VBS | Excel Programming | |||
Unable to suppress warning message... | Excel Programming |