deleting worksheet without delete dialog box

  • Thread starter Thread starter Gary
  • Start date Start date
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?
 
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 **
 
Back
Top