Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
deleting sheets
When I delete a sheet in a workbook with a macro it always
has a pop-up that asks if I really want to delete that sheet. How do I get the macro to tell it yes for me? Thanks, David |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
deleting sheets
Add this before the statement that deletes
application.displayalerts = false then before your macro quits application.displayalerts = True "david" wrote in message ... When I delete a sheet in a workbook with a macro it always has a pop-up that asks if I really want to delete that sheet. How do I get the macro to tell it yes for me? Thanks, David |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
deleting sheets
David
Sub delete() Application.DisplayAlerts = False ''do the deleting Application.DisplayAlerts = True End Sub Gord Dibben Excel MVP - XL97 SR2 & XL2002 On Wed, 30 Jul 2003 16:13:01 -0700, "david" wrote: When I delete a sheet in a workbook with a macro it always has a pop-up that asks if I really want to delete that sheet. How do I get the macro to tell it yes for me? Thanks, David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
comparing values on different sheets and deleting | Excel Discussion (Misc queries) | |||
inserting deleting rows?how do i get the other sheets to do the sa | Excel Discussion (Misc queries) | |||
deleting sheets 2&3 | Excel Discussion (Misc queries) | |||
deleting sheets | Excel Discussion (Misc queries) |