Hi
try
sub foo()
application.displayalerts=false
'your code
application.displayalerts=true
end sub
-----Original 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/

.