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

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

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