deleting worksheet without delete dialog box

G

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?
 
P

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 **
 
Top