Application.DisplayAlerts = False
'Your Code
Application.DisplayAlerts = True
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **
"ssmith " wrote in message
...
I'm writing a macro and deleting a worksheet. How can I suppress the
warning box for the user about deleting the worksheet?
Thanks,
Steve
---
Message posted from http://www.ExcelForum.com/