deleting worksheet without delete dialog box

[Gary]

I am trying to delete a worksheet in a macro, and it will
always pop up a 'delete' dialog box to confirm....how can
I remove it, is there special code to do so?

 

[Paul B]

Gary, try this

Application.DisplayAlerts = False
'Your Code
Application.DisplayAlerts = True

--
Paul B
Always backup your data before trying something new
Using Excel 97 & 2000
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **