Application.DisplayAlerts = False
'code to delete
Application.DisplayAlerts = True

"fabalicious " wrote in message
...
Hi.

From a macro, I want to delete all worksheets in a workbook that are
empty. With the expression

ActiveSheet.Delete (supposed I activate each sheet one after
another)

this happens. Problem here is that I will be asked whether I really
wanted to delete the sheet through a message box. Is there away to turn
this off?

Thanks

F


---
Message posted from http://www.ExcelForum.com/